These step by step video lessons will teach you SQL Server step by step from scratch.
SQL Server is a huge giant and how much ever we learn its not enough. As a part of this ongoing learning journey we have added course title "Learn SQL Server Step by Step" Tutorials which has currently 21 labs covering not all but the most required handfull skilled essentials to become SQL professional developer as required by today's software industry with the help of e below mentioned syllabus:
Below is the insight learning from the above labs.
SQL Server installation, creating entities like a 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.
My name is Shivprasad Koirala (this is my recent time photo), I love teaching and learning, I started QuestPond website 15 years back with the one single goal creating quality step by step IT programming related lessons.
I saw many lessons online, either they are done too fast or too slow or are too complicated.
The main goal of Questpond is to create Step by Step lessons on C#, ASP.NET, Design patterns, SQL and so on. As years moved on, I added other step by step lessons like Angular, SharePoint, MSBI, Azure and so on.