SQL Champion Program

Course Instructor Sumit Mittal

Request Callback Program Details

Course Curriculum

9 Subjects

Week 1 : SQL Fundamentals

1 Exercises • 11 Learning Materials

Notes

Running Notes : Week 1

PDF

SQL Fundamentals

MySQL Installation - Windows

PDF

Getting Started with SQL - MySQL Installation

Video

40:46

Database,Table Creation and Management | SQL Datatypes

Video

47:4

SQL Command - INSERT, SELECT | Table Data Import

Video

1:14:33

DCL Commands (Revoke | Grant)

Video

24:56

More on SQL Commands - TCL

Video

19:45

Additional Support Documents

PostgreSQL Installation Steps

PDF

SQL Server Installation Steps

PDF

Week-1 Quiz

SQL Fundamentals

Exercise

Weekly Assignment

Week-1 Assignment

PDF

Week-1 Assignment Solution

PDF

Week 2 : SQL Commands & Constraints

1 Exercises • 14 Learning Materials

Notes

Running Notes : Week 2

PDF

Downloadable Resources : Datasets

Customers Dataset

ZIP

SQL Fundamentals Continuation

SQL DDL Command - ALTER

Video

46:28

SQL Constraints - CHECK

Video

39:52

SQL Constraints - NOT NULL & PRIMARY KEY

Video

27:48

SQL Constraints - UNIQUE KEY

Video

15:25

SQL Constraints - DEFAULT & AUTO-INCREMENT

Video

24:2

SQL Constraints - FOREIGN KEY

Video

38:59

More on DML Commands - Update & Delete

Video

26:35

DQL Command | FILTER - SELECT Statement

Video

21:23

Filters & Logical Operators

Video

27:23

Week-2 Quiz

SQL Commands & Constraints

Exercise

Weekly Assignment

Assignment Datasets

ZIP

Week-2 Assignment

PDF

Week-2 Assignment Solution

PDF

Week 3 : Advanced SQL Filtering & Query Execution

1 Exercises • 16 Learning Materials

Notes

Running Notes : Week 3

PDF

Downloadable Resources : Practice Datasets and Scripts

Orders_complete Dataset | Practice DDL & DML Scripts

ZIP

SQL Filtering & Aggregate Functions

Basic Pattern Matching (LIKE, %, _)

Video

36:46

Complex Pattern Matching using REGEX

Video

38:32

Aggregate Function COUNT() | ORDER_BY Clause

Video

26:5

DISTINCT Keyword

Video

29:11

SQL Query - Order of Execution

Video

38:27

SQL Aggregate Functions - MIN, MAX, COUNT, AVG

Video

30:11

GROUP BY Clause

Video

36:47

GROUP BY : HAVING Clause

Video

30:15

More on HAVING & ORDER BY

Video

37:51

Query Execution Order

Video

11:51

Week-3 Quiz

SQL Filtering & Query Execution

Exercise

Weekly Assignment

Assignment Data Insert Scripts & Datasets

ZIP

Execution Scripts

ZIP

Week-3 Assignment

PDF

Week-3 Assignment Solution

PDF

Week 4 : SQL In-built Functions & JOINS

1 Exercises • 13 Learning Materials

Notes

Running Notes : Week 4

PDF

Downloadable Resources : Practice Datasets and Scripts

Practice Scripts

ZIP

SQL In-built Functions

Built-In Functions : STRING Related Functions

Video

46:16

Built-In Functions : DATE Related Functions

Video

32:00

Numeric Built-In Functions

Video

39:36

SET Operations

Video

40:38

SQL Joins

INNER JOIN

Video

52:13

LEFT | RIGHT & FULL OUTER JOIN

Video

24:15

CROSS JOIN

Video

27:44

Week-4 Quiz

SQL In-built Functions & JOINS

Exercise

Weekly Assignment

Week-4 Assignment

PDF

Week-4 Assignment Solution

PDF

Week 5 : SQL Interview Preparation Module

19 Learning Materials

Solutions - Running Notes

Running Notes : Week 5

PDF

Important Interview Questions

Interview Questions of Top-Notch Companies

PDF

Solutions

Interview Question 1

Video

20:41

Interview Question 2

Video

28:28

Interview Question 3

Video

7:26

Interview Question 4

Video

16:2

Interview Question 5

Video

7:57

Interview Question 6

Video

20:52

Interview Question 7

Video

3:37

Interview Question 8

Video

16:47

Interview Question 9

Video

17:41

Interview Question 10

Video

12:2

Interview Question 11

Video

000

Interview Question 13 - Part1

Video

10:8

Interview Question 13 - Part2

Video

15:36

Interview Question 14

Video

16:7

Interview Question 15

Video

33:30

Interview Question 17

Video

21:58

Interview Question 18

Video

24:56

Week 6 : SQL Sub-Queries & CTEs

1 Exercises • 10 Learning Materials

Notes

Running Notes : Week 6

PDF

SQL Sub-Queries

4 Ways of Solving Use-Case 1

Video

31:17

4 Ways of Solving Use-Case 2

Video

26:42

Multiple Sub-Queries to Solve a Use-Case

Video

30:41

Types of Sub-Queries

Video

34:24

SQL CTEs

Session 5

Video

23:23

Session 6

Video

29:23

Session 7

Video

24:36

Week-6 Quiz

SQL Sub-Queries & CTEs

Exercise

Weekly Assignment

Week-6 Assignment

PDF

Week-6 Assignment Solution

PDF

Week 7 : SQL Window Functions

1 Exercises • 14 Learning Materials

Notes

Running Notes : Week 7

PDF

Window Aggregate Functions

Use-cases for Window Functions

Video

16:18

Window Function : ROW_NUMBER

Video

37:30

Example Retail-DB Use-case for ROW_NUMBER

Video

28:6

ROW_NUMBER Vs RANK Vs DENSE_RANK

Video

20:29

LEAD & LAG Window Functions

Video

33:20

More on Window Functions

Video

33:33

More Examples of Window Functions

Video

40:21

Window Functions : Sample Interview Question 1

Video

18:39

Window Functions : Sample Interview Question 2

Video

36:56

Window Functions : Sample Interview Question 3

Video

24:10

Window Functions : Sample Interview Question 4

Video

19:32

Week-7 Quiz

SQL Window Functions

Exercise

Weekly Assignment

Week-7 Assignment Solution

PDF

Week-7 Assignment

PDF

Week 8 : SQL Query Optimization and Indexes

1 Exercises • 11 Learning Materials

Notes

Running Notes : Week 8

PDF

SQL Query Optimization & Indexes

Introduction to Indexes

Video

35:10

Clustered Indexes

Video

32:10

Non-Clustered Indexes

Video

39:31

Example Scenarios

Video

19:14

Continuation of Example Scenarios

Video

36:8

Query Optimization

Video

32:10

Query Execution Plan

Video

18:31

Joins & Aggregates

Video

31:6

Statistics in SQL

Video

49:59

Support Documents

SQL Server Installation Reference

Week-8 Quiz

SQL Query Optimization and Indexes

Exercise

Week 9 : SQL Stored Procedures | UDF | Recursive CTE | Data

1 Exercises • 15 Learning Materials

Notes

Running Notes : Week 9

PDF

SQL Stored Procedures | UDF | Recursive CTE

Stored Procedures

Video

13:11

Stored Procedure with Input Parameters

Video

11:24

More Scenarios - Stored Procedures

Video

22:36

User Defined Functions

Video

26:32

Recursive CTEs

Video

27:46

Introduction to Data Modeling

Video

4:14

Data Modeling

Session 1

Video

23:46

Session 2

Video

14:54

Session 3

Video

31:48

Session 4

Video

16:54

Session 5

Video

10:55

Session 6

Video

14:12

Session 7

Video

24:26

Session 8

Video

14:19

Quiz

Stored Procedures,UDF,Recursive CTE

Exercise

SQL Champion Program

Course Overview

Schedule of Classes

Course Curriculum

Week 1 : SQL Fundamentals

Notes

Running Notes : Week 1

SQL Fundamentals

MySQL Installation - Windows

Getting Started with SQL - MySQL Installation

Database,Table Creation and Management | SQL Datatypes

SQL Command - INSERT, SELECT | Table Data Import

DCL Commands (Revoke | Grant)

More on SQL Commands - TCL

Additional Support Documents

PostgreSQL Installation Steps

SQL Server Installation Steps

Week-1 Quiz

SQL Fundamentals

Weekly Assignment

Week-1 Assignment

Week-1 Assignment Solution

Week 2 : SQL Commands & Constraints

Notes

Running Notes : Week 2

Downloadable Resources : Datasets

Customers Dataset

SQL Fundamentals Continuation

SQL DDL Command - ALTER

SQL Constraints - CHECK

SQL Constraints - NOT NULL & PRIMARY KEY

SQL Constraints - UNIQUE KEY

SQL Constraints - DEFAULT & AUTO-INCREMENT

SQL Constraints - FOREIGN KEY

More on DML Commands - Update & Delete

DQL Command | FILTER - SELECT Statement

Filters & Logical Operators

Week-2 Quiz

SQL Commands & Constraints

Weekly Assignment

Assignment Datasets

Week-2 Assignment

Week-2 Assignment Solution

Week 3 : Advanced SQL Filtering & Query Execution

Notes

Running Notes : Week 3

Downloadable Resources : Practice Datasets and Scripts

Orders_complete Dataset | Practice DDL & DML Scripts

SQL Filtering & Aggregate Functions

Basic Pattern Matching (LIKE, %, _)

Complex Pattern Matching using REGEX

Aggregate Function COUNT() | ORDER_BY Clause

DISTINCT Keyword

SQL Query - Order of Execution

SQL Aggregate Functions - MIN, MAX, COUNT, AVG

GROUP BY Clause

GROUP BY : HAVING Clause

More on HAVING & ORDER BY

Query Execution Order

Week-3 Quiz

SQL Filtering & Query Execution

Weekly Assignment

Assignment Data Insert Scripts & Datasets

Execution Scripts

Week-3 Assignment

Week-3 Assignment Solution

Week 4 : SQL In-built Functions & JOINS

Notes

Running Notes : Week 4

Downloadable Resources : Practice Datasets and Scripts

Practice Scripts

SQL In-built Functions

Built-In Functions : STRING Related Functions

Built-In Functions : DATE Related Functions

Numeric Built-In Functions

SET Operations

SQL Joins

INNER JOIN

LEFT | RIGHT & FULL OUTER JOIN

CROSS JOIN