sql server tutorial

sql server tutorial

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?

These step by step video lessons will teach you Sql Server step by step from scratch.

Url: View Details

What you will learn

• SQL Server installation, creating entities like database , tables , rows and columns. Covers fundamentals like primary key,foreign key , referential integrity , constraints , normalization ( first , second and third normal forms), Denormalization,OLTP , OLAP, StarSchema and SnowFlake design.
• Writing DML and DDL query like inner join,left join,right join, outer join, union , co-related queries, union all, alias,case statements,cartesian,ISNULL, aggregate( sum/count),wild card , top, order by, create , insert, bulk insert , update , backup , restore,ISNULL,Coalesce,Row_Number, Partition, Rank ,DenseRank , Pivot and Unpivot.
• Understanding importance of indexes , how it makes our search faster , non-clustered indexes vs clustered indexes , page splits in indexes and column store indexes.

Rating: 4.6

Level: Beginner Level

Duration: 7 hours

Instructor: Shivprasad Koirala