Managing Tables using DML Statements

Practice Labs Module
Time
36 minutes
Difficulty
Intermediate

"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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

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
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.