This is the standard language of DBMS in storing, updating and retrieving data in the database.
SQL
What are the 3 common clauses for SQL?
Select, From, Where
This clause identifies the columns or fields to be displayed.
Select
This clause identifies the table or relation where the data is to be retrieved.
From
This clause identifies some criteria in retrieving data in the database.
Where
What does DML stand for?
Data Manipulation Language
What does DDL stand for?
Data Definition Language
This command ensures that transactions are either completed or rolled back.
Transaction controls
These are used to control access to the database and concerns about the creation of user permissions.
Security statements
Used to add, access and process data stored in the computer database
Database management system
This is an Open Source SQL database management system developed, distributed and supported by Oracle Corporation.
MySQL
This stores data into tables consisting of rows and columns. It is govern by the rules in relationship such as one-to-one, one-to-many and many-to-many
Relational database