Managing Tables using DML Statements

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