watching now
3 Students

Course Details

Lessons

21

Skill Level

Beginner

Certificate

Available

RESERVE - Only minutes left for your FREE certificate!

What You Will Learn?

  • SQL Server professional development

Description

Requirements

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

Curriculum

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
Section 4: Lab 4: SQL basics (Select, Insert, Update and Delete) 1:20:06
Section 5: Lab 5: DDL (Data definition language) Queries 31:43
Section 6: Lab 6: Transactions, Locks and Isolation level in SQL Server 1:08:17
Section 7: Lab 7: ISNULL and Coalesce functions 06:16
Section 8: Lab 8: Row_Number, Partition, Rank and DenseRank 10:49
Section 9: Lab 9: Triggers, inserted and deleted tables 15:40
Section 10: Lab 10: Instead of and after triggers 15:53
Section 11: Lab 11: Denormalization, OLTP and OLAP 10:25
Section 12: Lab 12: Understanding Star schema and Snow flake design 04:32
Section 13: Lab 13: SQL Server 8 kb pages 18:10
Section 14: Lab 14: Index and performances 09:55
Section 15: Lab 15: Page Split and indexes 08:52
Section 16: Lab 16: Clustered vs non-clustered 05:57
Section 17: Lab 17: Stored procedures and their importance 24:16
Section 18: Lab 18: Change Data Capture 08:41
Section 19: Lab 19: Explain Columnstore Indexes? 11:27
Section 20: Lab 20: SQL Server agent 08:41
Section 21: Lab 21: How can we implement Pivot & Unpivot in SQL Server? 10:27

About the Instructor

Reviews 1
Students 132
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