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

00:40:46

Database,Table Creation and Management | SQL Datatypes

Video

00:47:04

SQL Command - INSERT, SELECT | Table Data Import

Video

01:14:33

DCL Commands (Revoke | Grant)

Video

00:24:56

More on SQL Commands - TCL

Video

00: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

00:46:28

SQL Constraints - CHECK

Video

00:39:52

SQL Constraints - NOT NULL & PRIMARY KEY

Video

00:27:48

SQL Constraints - UNIQUE KEY

Video

00:15:25

SQL Constraints - DEFAULT & AUTO-INCREMENT

Video

00:24:02

SQL Constraints - FOREIGN KEY

Video

00:38:59

More on DML Commands - Update & Delete

Video

00:26:35

DQL Command | FILTER - SELECT Statement

Video

00:21:23

Filters & Logical Operators

Video

00: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

00:36:46

Complex Pattern Matching using REGEX

Video

00:38:32

Aggregate Function COUNT() | ORDER_BY Clause

Video

00:26:05

DISTINCT Keyword

Video

00:29:11

SQL Query - Order of Execution

Video

00:38:27

SQL Aggregate Functions - MIN, MAX, COUNT, AVG

Video

00:30:11

GROUP BY Clause

Video

00:36:47

GROUP BY : HAVING Clause

Video

00:30:15

More on HAVING & ORDER BY

Video

00:37:51

Query Execution Order

Video

00: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

00:46:16

Built-In Functions : DATE Related Functions

Video

00:32:00

Numeric Built-In Functions

Video

00:39:36

SET Operations

Video

00:40:38

SQL Joins

INNER JOIN

Video

00:52:13

LEFT | RIGHT & FULL OUTER JOIN

Video

00:24:15

CROSS JOIN

Video

00: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

00:20:41

Interview Question 2

Video

00:28:28

Interview Question 3

Video

00:07:26

Interview Question 4

Video

00:16:02

Interview Question 5

Video

00:07:57

Interview Question 6

Video

00:20:52

Interview Question 7

Video

00:03:37

Interview Question 8

Video

00:16:47

Interview Question 9

Video

00:17:41

Interview Question 10

Video

00:12:02

Interview Question 11

Video

00:00:00

Interview Question 13 - Part1

Video

00:10:08

Interview Question 13 - Part2

Video

00:15:36

Interview Question 14

Video

00:16:07

Interview Question 15

Video

00:33:30

Interview Question 17

Video

00:21:58

Interview Question 18

Video

00: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

00:31:17

4 Ways of Solving Use-Case 2

Video

00:26:42

Multiple Sub-Queries to Solve a Use-Case

Video

00:30:41

Types of Sub-Queries

Video

00:34:24

SQL CTEs

Session 5

Video

00:23:23

Session 6

Video

00:29:23

Session 7

Video

00: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

00:16:18

Window Function : ROW_NUMBER

Video

00:37:30

Example Retail-DB Use-case for ROW_NUMBER

Video

00:28:06

ROW_NUMBER Vs RANK Vs DENSE_RANK

Video

00:20:29

LEAD & LAG Window Functions

Video

00:33:20

More on Window Functions

Video

00:33:33

More Examples of Window Functions

Video

00:40:21

Window Functions : Sample Interview Question 1

Video

00:18:39

Window Functions : Sample Interview Question 2

Video

00:36:56

Window Functions : Sample Interview Question 3

Video

00:24:10

Window Functions : Sample Interview Question 4

Video

00: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

00:35:10

Clustered Indexes

Video

00:32:10

Non-Clustered Indexes

Video

00:39:31

Example Scenarios

Video

00:19:14

Continuation of Example Scenarios

Video

00:36:08

Query Optimization

Video

00:32:10

Query Execution Plan

Video

00:18:31

Joins & Aggregates

Video

00:31:06

Statistics in SQL

Video

00: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

00:13:11

Stored Procedure with Input Parameters

Video

00:11:24

More Scenarios - Stored Procedures

Video

00:22:36

User Defined Functions

Video

00:26:32

Recursive CTEs

Video

00:27:46

Introduction to Data Modeling

Video

00:04:14

Data Modeling

Session 1

Video

00:23:46

Session 2

Video

00:14:54

Session 3

Video

00:31:48

Session 4

Video

00:16:54

Session 5

Video

00:10:55

Session 6

Video

00:14:12

Session 7

Video

00:24:26

Session 8

Video

00: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