Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Fundamentals - Coggle Diagram
Database Fundamentals
SQL
DQL: SELECT
DML: INSERT, UPDATE, DELETE
DDL: INSERT, ALERT, DROP
DCL: GRANT, REVOKE
DBMS
SQL server
MySQL
Oracle
Database, Table, Field and Record
Row in the table is as a record
Database is a colletion of data consisting of a phycial file
The collection of data in the file is stored in different tables
Query
Set of instruction given to the DMS
Schema
A colletion of database objects associated with a database
MySQL workbench
DataGrip