Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn SQL server step by step
First Section
Lab 1:- Basic Fundamentals Database, Tables, rows and columns. (16:14)
Lab 2:- Primary key, foreign key, referential integrity and constraints. (23:46)
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms). (33:35)
Lab 4: - SQL basics(Select, Insert, Update and Delete) (80:00)
Lab 5 :- DDL (Data definition language) Queries. (31:33)
Lab 6: - Transactions, Locks and Isolation level in SQL Server. (68:04)
Lab 7: - ISNULL and Coalesce functions. (6:16)
Lab 8: - Row_Number, Partition, Rank and DenseRank (10:49)
Lab 9: - Triggers, inserted and deleted tables (15:39)
Lab 10: - Instead of and after triggers. (15:52)
Lab 11: - Denormalization, OLTP and OLAP. (10:25)
Lab 12: - Understanding Star schema and Snow flake design. (4:31)
Lab 13: - SQL Server 8 kb pages. (18:09)
Lab 14 :- Index and performances (9:55)
Lab 15 :- Page Split and indexes (8:52)
Lab 16 :- Clustered vs non-clustered (5:56)
Lab 17: - Stored procedures and their importance. (24:16)
Lab 18: - Change Data Capture. (8:40)
Lab 19: - Explain Columnstore Indexes? (11:27)
Lab 20: - SQL Server agent (8:40)
Lab 21: - How can we implement Pivot & Unpivot in SQL Server? (10:27)
Lab 21: - How can we implement Pivot & Unpivot in SQL Server?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock