arrow_back
1.Course Introduction
About this course
2.Module 1- Add Data
1.Insert SINGLE or MULTIPLE values
2.Insert data with IDENTITY
3.Insert data with CONSTRAINTS
4.Insert data using BULK INSERT
5.Insert data using SELECT
6.Insert a specific field using SELECT
7.Insert data using OUTPUT clause
8.Insert data using SELECT INTO
9.Insert data using STORED PROCEDURE
10.Insert data using MERGE
Module 1 - SQL Scripts
3.Module 2- Modify Data
1.Update data in rows
2.Update data in multiple columns
3.Update data in table with constraints
4.Update data using Join
5.Update data using variables
6.Update data using expression
7.Update data using cursors
8.Update data using OUTPUT clause
9.Update data using ROWCOUNT
10.Update data using Subquery
11.Update data using MERGE
12.Update data using dynamic query
Module 2 - SQL Scripts
4.Module 3- Remove Data
1.Delete specific or multiple records
2.Delete data using multiple column values
3.Delete data using TOP command
4.Delete data with Constraints
5.Delete data using JOIN
6.Delete data with Identity
7.Delete data using OUTPUT clause
8.Delete data using MERGE
9.Delete data using SUBQUERY
Module 3 -SQL Scripts
5.Module 4- Transactions
1.Using BEGIN AND 2.using ROLLBACK
3.Using COMMIT
4.Using SAVE
Module 4 - SQL Scripts
6.Course completion
Thank You!