This course has 21 labs which cover the below syllabus:

Lab 1 - Basic fundamentals database, tables, rows, and columns

Lab 2 - Primary key, foreign key, referential integrity, and constraints

Lab 3 - Database normalization (1st, 2nd and 3rd normal forms)

Lab 4 - SQL basics (Select, Insert, Update and Delete)

Lab 5 - DDL (Data definition language) queries

Lab 6 - Transactions, locks and isolation level in SQL server

Lab 7 - ISNULL and coalesce functions

Lab 8 - Row_Number, partition, rank, and DenseRank

Lab 9 - Triggers, inserted and deleted tables

Lab 10 - Instead of and after triggers

Lab 11 - Denormalization, OLTP and OLAP

Lab 12 - Understanding Star schema and Snow flake design

Lab 13 - SQL Server 8 kb pages

Lab 14 - Index and performances

Lab 15 - Page split and indexes

Lab 16 - Clustered vs non-clustered

Lab 17 - Stored procedures and their importance

Lab 18 - Change data capture

Lab 19:- Explain columnstore indexes

Lab 20 - SQL server agent

Lab 21 - How can we implement pivot and unpivot in SQL server