Data Manipulation Language (DML).pptx

Data Manipulation Language (DML) is a subset of SQL (Structured Query Language) that is used to manage and manipulate data stored in a relational database management system (RDBMS). DML consists of a set of SQL commands that enable users to retrieve, insert, update, and delete data within a database. Here are the primary DML commands and their descriptions:

SELECT: The SELECT statement is used to retrieve data from one or more database tables. It allows you to specify which columns to retrieve, apply filters to the data, and sort the results.

INSERT: The INSERT statement is used to add new rows of data into a table. You specify the table, the columns, and the values to be inserted.

UPDATE: The UPDATE statement is used to modify existing data in a table. You specify the table, the columns to be updated, the new values, and a WHERE clause to determine which rows to update.

DELETE: The DELETE statement is used to remove rows from a table based on specified conditions. It does not return the deleted data; it simply removes it from the table.

These DML commands are essential for interacting with databases and managing data within them. They allow users to perform a wide range of operations, from simple data retrieval to complex data transformations. Additionally, DML commands can be used in conjunction with Data Definition Language (DDL) commands, which define the structure of the database, to create and maintain a comprehensive database management system.

1. Data Manipulation Language (DML) College: SST College Arts & Commerce Subject: fundamental database management system Teacher: sunetra ma’am Presented By: Avinash Tare

2. Introduction TO DML Data Manipulation Language (DML) Statements Are Used For Mainpulating Or Managing Data In Database. DML Commands Are Not Auto-Committed Like DDL Statements. It Means Changes Done By DML Command Can Be Rolled Back. In Other Words The DML Statements Do Not Implicitly Commit The Current Transaction. In DML Thare Are 4 Statements. ( i ) Insert Statement , (ii) Update Statement, (iii) Delete Statement, (iv) Select Statement,

3. Insert Statement To Add Or Insert Data In Database Table we need to use insert statement. Syntax: Example: Output:

4. Update Statement To Update Data Added in Database We Use Update Statement. Syntax: Example: Output Without Update: Update Statement Used To Modify The Records Present In Existing Table. Output Without Update:

5. Delete Statement To Remove Data From Database We Use Delete Statement. Syntax: Example: Output Without Delete: Delete Statement Used To Delete The Records Present In Existing Table. Output Without Delete:

6. SELECT Statement To Read Data From Table We Use This Statement. Syntax: Example: Using Select Command We Can Select Multiple Or Single Record As Per Need. Output :