sql server tutorial

sql server tutorial, These step by step video lessons will teach you Sql Server step by step from scratch.

• Created by Shivprasad Koirala
•  English
•  English [Auto-generated]

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.

This course includes

• 7 hours on-demand video
• 3 downloadable resources
• Full lifetime access
• Access on mobile and TV
• Certificate of Completion

Preview This Course - GET COUPON CODE