SQL Complete Video Course

By Swapnjeet S

Lead Data Analyst | You tuber | Data Tutorials | 220K + Subs

Welcome to the Complete SQL Course designed to take you from absolute beginner to advanced level with strong practical and interview-ready skills.

SQL is one of the most important skills for Data Analysts, Data Scientists, Business Analysts, Developers, and anyone working with data. Almost every company today stores its data in relational databases and SQL is the language used to extract, analyze, and manipulate that data.

🔹 Module 1: Introduction to SQL

Introduction
What is SQL
What is Database
DBMS vs RDBMS

🔹 Module 2: Creating Database

What is Table
Connecting to MySQL Workbench
Creating Database

🔹 Module 3: Creating Table

Creating Table with Query
Import Table in SQL

🔹 Module 4: Data Types and Constraints

Data Types in SQL
Constraints in SQL

🔹 Module 5: DDL Commands

Intro to all SQL Commands
CREATE, ALTER, DROP, TRUNCATE, RENAME

🔹 Module 6: DQL Commands

Import Sales Table
SELECT & FROM Clause
WHERE Clause

🔹 Module 7: Operators

Comparison Operators, AND, OR, NOT, BETWEEN, IN, LIKE, ISNULL, Arithmetic Operators, Assignment

🔹 Module 8: DQL – LIMIT, ORDER BY, OFFSET, GROUP BY & HAVING

LIMIT, ORDER BY, OFFSET, GROUP BY, HAVING
Order of Execution of Query
Assignment 1
Assignment 2

🔹 Module 9: Aggregate Functions

SUM(), COUNT(), AVG(), MAX(), MIN()
Assignment

🔹 Module 10: Primary & Foreign Key

Introduction to Keys
Primary Key
Foreign Key
Example for Keys

🔹 Module 11: JOINS

Introduction to Joins
Inner Join, Left Join, Right Join, Full Outer Join
Joins Real Time QnA
Assignment

🔹 Module 12: Subquery

Concept & Example 1–6
Corelated Subquery
Drawbacks of Corelated Subquery
Assignment

🔹 Module 13: Window Functions

Introduction
OVER() Clause
Types of Functions
SUM(), AVG(), COUNT(), MAX(), MIN(), ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), PERCENT_RANK(), CUME_DIST()
Assignment

🔹 Module 14: CTE's

Introduction
CTE Example 1
CTE with WINDOW Function
CTE Example 3
Recursive CTE
Recursive CTE Example

🔹 Module 15: TEXT Functions

Introduction
UPPER(), LOWER(), LENGTH(), CHAR LENGTH(), TRIM(), LEFT(), RIGHT(), SUBSTRING(), CONCAT(), CONCAT_WS(), LIKE(), REPLACE(), REVERSE(), LOCATE()

🔹 Module 16: Numeric Functions

Introduction
ROUND(), CEIL(), FLOOR(), TRUNCATE(), ABS(), SIGN()

🔹 Module 17: Control Flow Functions

Introduction
CASE() (Scenario 1–4), IF(), IFNULL()

🔹 Module 18: Date & Time Functions

Introduction
NOW(), CURDATE(), YEAR(), DAY(), QUARTER(), WEEK(), DAYNAME(), MONTHNAME(), DAYOFWEEK(), DAY_ADD(), DAY_SUB(), DATEDIFF(), TIMESTAMPDIFF(), STR_TO_DATE()

🔹 Module 19: Views

Introduction
Create View for single table
Create View for multiple table
Materialised View

🔹 Module 20: Scenario Based Interview QnA

Interview QnA

🔹 Module 21: SQL Complete Material

Notes, PDF, PPT’s, All Interview QnA
All Material in Zip File

🔹 Module 22: SQL Projects

Project 1
Project 2
SQL + Power BI Project

Why This Course?

Instructed by Swapnjeet S – Founder of Data Tutorials (220K+ Subscribers) with industry experience.
Covers SQL from beginner to advanced level using MySQL Database (MySQL Workbench).
Strong focus on hands-on learning with real-world business datasets.
Includes Joins, Subqueries, Window Functions, CTEs, and Interview-based scenarios.
Designed to make you job-ready for Data Analyst and SQL roles.

🔹 How This Course Is Taught

Step-by-step explanations with live query execution in MySQL.
Concepts taught using practical, real business datasets.
Clear explanation of why, when, and how to use each SQL concept.
Focus on problem-solving and real industry scenarios.
Assignments and interview-style questions for practice and revision.

🔹 What You Will Learn

Create databases and tables, manage data, and work confidently in MySQL Workbench.
Master DDL, DQL, filtering, GROUP BY, HAVING, Aggregate Functions, and Joins.
Write advanced queries using Subqueries, Window Functions, and CTEs.
Work with Text, Numeric, Date & Time, Control Flow Functions, and Views.
Solve real-world SQL projects and prepare for SQL interviews confidently.

🔹 Who This Course Is For

Beginners starting a career in Data Analytics or SQL.
Students preparing for Data Analyst or Business Analyst roles.
Working professionals who want to upskill in SQL (MySQL).
Excel, Power BI, or reporting professionals who want strong SQL foundations.
Anyone who wants to become job-ready in SQL and database management.