IMG-20240923-WA0000.jpeg

# Practical-1 ## Aim To study DDL-create and DML-insert commands. ## DDL (Data Definition Language) DDL or Data Definition Language consists of SQL commands that define the database schema. It is used to create and modify the structure of database objects. ### Examples of DDL commands: * **CREAT...

# Practical-1 ## Aim To study DDL-create and DML-insert commands. ## DDL (Data Definition Language) DDL or Data Definition Language consists of SQL commands that define the database schema. It is used to create and modify the structure of database objects. ### Examples of DDL commands: * **CREATE** - is used to create the database, or its objects (like table, index, function, view, store procedure, and triggers). * **DROP** - is used to delete objects from the database. * **ALTER** - is used to alter the structure of the database. * **TRUNCATE** - is used to remove all records from a table, including all spaces allocated for the records. * **COMMENT** - is used to add comments to the data dictionary. * **RENAME** - is used to rename an object existing in the database. ## DML (Data Manipulation Language) DML commands deal with the manipulation of data present in the database. These commands belong to DML or Data Manipulation Language. ### Examples of DML: * **SELECT** - is used to retrieve data from the database. * **INSERT** - is used to insert data into a table. * **UPDATE** - is used to update existing data within a table. * **DELETE** - is used to delete records from a database table. ## Practical