Pre-requisites : No experienced required
Covers fundamentals like primary key, foreign key , referential integrity , constraints , normalisation ( first , second and third normal forms), Denormalisation, 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.
IT has 21 sessions which covers the below syllabus
Basic Fundamentals Database, Tables, rows and columns.
Primary key, foreign key, referential integrity and constraints
Database Normalization (1st, 2nd and 3rd normal forms).
SQL basics(Select, Insert, Update and Delete)
IDDL (Data definition language) Queries.
Transactions, Locks and Isolation level in SQL Server.
ISNULL and Coalesce functions.
Row_Number, Partition, Rank and DenseRank
Triggers, inserted and deleted tables
Instead of and after triggers.
Denormalization, OLTP and OLAP.
Understanding Star schema and Snow flake design.
SQL Server 8 kb pages.
Index and performances
Page Split and indexes
Clustered vs non-clustered
Stored procedures and their importance.
Change Data Capture.
Explain Columnstore Indexes?
SQL Server agent
How can we implement Pivot & Unpivot in SQL Server?