Download full course: sql server for beginners | TutsGalaxy
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
- No experienced required , should have the will to learn 🙂