Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Tutorial New
SQL Server Step by Step Videos
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:22)
Lab 20: - SQL Server agent. (8:40)
Lab 21: - How can we implement Pivot & Unpivot in SQL Server? (10:27)
Lab 15: - Page Split and indexes.
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock