Brief Introduction
These step by step video lessons will teach you Sql Server step by step from scratch.Description
It has 21 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: - 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 & Unpivot in SQL Server?
Requirements
- Requirements
- No experienced required , should have the will to learn :-)
Shivprasad Koirala
4.6 Raiting
SDET Training: Selenium WebDriver, Java Project & Code Tests
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Complete SDET Training course on Selenium WebDriver with Java Framework, API & Automation Testing, Coding Interview etc Why it’s important for you to take this course:...
Microsoft SQL Server for Beginners | Crash Course
- 3.9
-
![]()
![]()
![]()
![]()
![]()
Boot-camp to enhanced SQL Query Writing Skills : Database Crash course designed for beginners : Database Programming What is RDBMS (Relational Database Management System)...
Google BigQuery & PostgreSQL : Big Query for Data Analysis
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query 6 Reasons why you should choose this PostgreSQL and BigQuery course...
Complete SQL and Databases Bootcamp: Zero to Mastery [2021]
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises! Never spend time on confusing, out of date, incomplete tutorials anymore....
