Course curriculum

  • 1

    Course Introduction

  • 2

    Module 1- Add Data

    • 1.Insert SINGLE or MULTIPLE values

    • 2.Insert data with IDENTITY

      FREE PREVIEW
    • 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 statement

  • 3

    Module 2- Modify Data

    • 1.Update data in rows

    • 2.Update data in multiple columns

      FREE PREVIEW
    • 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

  • 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

      FREE PREVIEW
    • 8.Delete data using MERGE

    • 9.Delete data using SUBQUERY

  • 5

    Module 4- Transactions

    • 1.Using BEGIN & 2.using ROLLBACK

    • 3.Using COMMIT

    • 4.Using SAVE

  • 6

    Course completion

    • Thank You!