Managing Tables using DML Statements
"Managing Tables using DML statements" In this module, you will explore the concepts of managing the tables using DML statements. It includes various functionality to perform like inserting data, updating data and deleting data Truncate Data, Insert a row into a Table, Update rows in a Table, Delete rows from the Table, Control Transactions.

Introduction
Managing Tables using DML statements
In this module, you will explore the concepts of managing the tables using DML statements. It includes various functionality to perform like inserting data, updating data and deleting data.
- Truncate Data
- Insert a row into a Table
- Update rows in a Table
- Delete rows from the Table
- Control Transactions
Exercise 1 - Truncate Data
In this exercise, you will learn the following about Managing Tables using DML statements:
- Establishing a connection to the database
- Understanding TRUNCATE Operation
Exercise 2 - Insert a Row into a Table
In this exercise you will learn the following about the Managing Tables Using DML Statement:
- Adding Rows Using INSERT Statement
- Inserting a row using DEFAULT column value
- Inserting a row using a sub query
Exercise 3 - Update Rows in a Table
In this exercise you will learn the following about the Managing Tables Using DML Statement:
- Using Update to Modify Existing data into a Table
Exercise 4 - Delete Rows from a Table
In this exercise you will learn the following about the Managing Tables Using DML Statement:
- Using Delete Statement For Removing a Row from a Table
Exercise 5 - Control Transactions
In this exercise you will learn the following about the Managing Tables Using DML Statement:
- Understanding COMMIT statement
- Understanding ROLLBACK statement
- Understanding SAVEPOINT statement
- Understanding What is SET TRANSACTION
- Understanding What is SET CONSTRAINT
- Understanding the difference between Committed Transaction and Uncommitted Transaction
See the full benefits of our immersive learning experience with interactive courses and guided career paths.