SQL Server tutorial

This course will teach you sql server step by step.

Instructed by Shivprasad Koirala

Access all courses with Premium Subscription

  • Monthly
  • Yearly

Monthly

$ 29/mo
Billed Monthly
  • All Courses Access
  • New Courses Instant Access
  • Learning paths Access
  • Course completion certificates
  • Skills Assessment
  • Instructor Support
  • Exercise files & Quizzes
  • Resume & Play
  • Mobile and TV apps
  • Offline viewing
  • Cancel Anytime
Subscribe Now

Yearly

$ 299/yr
Billed Anually
  • One Year Unlimited Access
  • New Courses Instant Access
  • Learning paths Access
  • Course completion certificates
  • Skills Assessment
  • Instructor Support
  • Exercise files & Quizzes
  • Resume & Play
  • Mobile and TV apps
  • Offline viewing
  • Cancel Anytime
Subscribe Now
  • 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.

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?

  • No experienced required , should have the will to learn :-)
  • Developers who want to become SQL Server developers.
View More...

Section 1 : Unpublished Section

  • Lecture 1 :
  • Lab 1:- Basic Fundamentals Database, Tables, rows and columns. Preview
  • Lecture 2 :
  • Lab 2:- Primary key, foreign key, referential integrity and constraints.
  • Lecture 3 :
  • Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
  • Lecture 4 :
  • Lab 4: - SQL basics(Select, Insert, Update and Delete)
  • Lecture 5 :
  • Lab 5 :- DDL (Data definition language) Queries.
  • Lecture 6 :
  • Lab 6: - Transactions, Locks and Isolation level in SQL Server.
  • Lecture 7 :
  • Lab 7: - ISNULL and Coalesce functions.
  • Lecture 8 :
  • Lab 8: - Row_Number, Partition, Rank and DenseRank
  • Lecture 9 :
  • Lab 9: - Triggers, inserted and deleted tables
  • Lecture 10 :
  • Lab 10: - Instead of and after triggers.
  • Lecture 11 :
  • Lab 11: - Denormalization, OLTP and OLAP.
  • Lecture 12 :
  • Lab 12: - Understanding Star schema and Snow flake design.
  • Lecture 13 :
  • Lab 13: - SQL Server 8 kb pages.
  • Lecture 14 :
  • Lab 14 :- Index and performances
  • Lecture 15 :
  • Lab 15 :- Page Split and indexes
  • Lecture 16 :
  • Lab 16 :- Clustered vs non-clustered
  • Lecture 17 :
  • Lab 17: - Stored procedures and their importance.
  • Lecture 18 :
  • Lab 18: - Change Data Capture.
  • Lecture 19 :
  • Lab 19: - Explain Columnstore Indexes?
  • Lecture 20 :
  • Lab 20: - SQL Server agent
  • Lecture 21 :
  • Lab 21: - How can we implement Pivot & Unpivot in SQL Server?

Shivprasad Koirala,

My name is Shivprasad Koirala ( thats my young 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.
View More...

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

SQL for Newcomers - The Full Master...

By : Sameh Sharaf

Lecture 122

Developing SQL Data Models

By : Microsoft

Lecture 9

Implementing a SQL Data Warehouse

By : Microsoft

Lecture 14

Managing SQL Business Intelligence ...

By : Microsoft

Lecture 7

Need any help with the platform? Contact us at: support@learnfly.com