SQL Concepts and Practical Application

1. DDL vs DML SQL commands are mainly divided into: DDL (Data Definition Language): Used to define and structure database objects such as tables. DML (Data Manipulation Language): Used to manage and manipulate data inside those tables. Aspect DDL (Data Definition Language) DML (Data Manipulation Language) Purpose Defines database structure Manipulates data in tables Commands CREATE, ALTER, DROP INSERT, UPDATE, DELETE Effect Changes schema Changes records/data Example CREATE TABLE students INSERT INTO students VALUES (...) 2. Use of CREATE, INSERT, UPDATE, DELETE In my assignment this week i was able to do the to use the below: CREATE was used to define tables such as students, exam results, and subjects. INSERT was used to add records into the tables. UPDATE was used to correct or modify existing data, such as updating a student’s city or correcting marks in the exam results table. DELETE was used to remove incorrect or cancelled records. For example, result_id 9 was deleted from the e