Black friday

Save big!

All courses under $5 - for a limited time!
watching now
1 Students
21 Lessons
Beginner

What You Will Learn?

  • SQL Server professional development

Curriculum

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

Description

Requirements

  • No experienced required, should have the will to learn :-)

About the Instructor

Reviews 0
Students 3
Courses 2

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.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo