🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
97 Students

Description

What Will You Learn?

  • You'll learn SQL server basics from scratch
  • You'll be able to deploy your knowledge really profesionally
  • You'll get the essential understanding of SQL that will be useful in front-end, back-end development and other areas of programming

Requirements

  • No prior experience with SQL required
  • You must be willing to learn!
  • NFT Certificate
  • 21 Lessons
  • Beginner
  • English
  • 3.6 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 7h 3min of content, in total.

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

About the Instructor

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.

See All Instructor Courses

BitDegree platform reviews