These step by step video lessons will teach you SQL Server step by step from scratch.
Instructed by: Shivprasad Koirala | Subject: Development, Databases
Instructed by: Shivprasad Koirala | Subject: Development, Databases
Description
It has 20 labs which covers 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: - ISNULL and Coalesce functions. Lab 7: - Row_Number, Partition, Rank and DenseRank Lab 8: - Triggers, inserted and deleted tables Lab 9: - Instead of and after triggers. Lab 10: - Denormalization, OLTP and OLAP Lab 11: - Understanding Star schema and Snow flake design. Lab 12: - SQL Server 8 kb pages. Lab 13 :- Index and performances Lab 14 :- Page Split and indexes Lab 15 :- Clustered vs non-clustered Lab 16: - Stored procedures and their importance. Lab 17: - Change Data Capture. Lab 18: - Explain Columnstore Indexes? Lab 19: - SQL Server agent Lab 20: - How can we implement Pivot & Unpivot in SQL Server? Who this course is for: Developers who want to become SQL Server developers
@https%3A%2F%2Fwww.udemy.com%2Fsql-server-sql%2F%3Futm_medium=linkshare
Course Info
- 20 Lectures
- 6 Hours
- Language: English
- Subject: Development, Databases
- Instructed by: Shivprasad Koirala
- Platform: Udemy
