sql server tutorial

Free Download sql server tutorial
Last updated 7/2022
Duration: 7h 3m | Video: .MP4, 1280×720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 3.36 GB
Genre: eLearning | Language: English
These step by step video lessons will teach you Sql Server step by step from scratch.

What you’ll 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.
Triggers,Insteadof , After trigger ,Inserted , deleted tables ,Stored Procedures,CDC,8 KB page and SQL Server agent.
Requirements
No experienced required , should have the will to learn 🙂
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?
Who this course is for
Developers who want to become SQL Server developers
Homepage

https://www.udemy.com/course/sql-server-sql/