Database: Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it.
DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
DDL Commands:
1.CREATE: to create a database and its objects like (table, index, views, store procedure, function, and triggers)
2.ALTER: alters the structure of the existing database
3.DROP: delete objects from the database
TRUNCATE: remove all records from a table, including all spaces allocated for the records are removed
4.COMMENT: add comments to the data dictionary
5.RENAME: rename an object.
DML Commands:
DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE, etc., and it is used to store, modify, retrieve, delete and update data in a database.
1.SELECT: retrieve data from a database
2.INSERT: insert data into a table
3.UPDATE: updates existing data within a table
4.DELETE: Delete all records from a database table
5.MERGE: UPSERT operation (insert or update)
