SQL Complete Video Course with Swapnjeet S

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

1. Introduction
2. What is SQL
3. What is Database
4. DBMS vs RDBMS

🔹 Module 2: Creating Database

1. What is Table
2. Connecting to MySQL Workbench
3. Creating Database

🔹 Module 3: Creating Table

1. Creating Table with Query
2. Import Table in SQL

🔹 Module 4: Data Types and Constraints

1. Data Types in SQL
2. Constraints in SQL

🔹 Module 5: DDL Commands

1. Intro to all SQL Commands
2. CREATE, ALTER, DROP, TRUNCATE, RENAME

🔹 Module 6: DQL Commands

1. Import Sales Table
2. SELECT & FROM Clause
3. WHERE Clause

🔹 Module 7: Operators

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

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

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

🔹 Module 9: Aggregate Functions

1. SUM(), COUNT(), AVG(), MAX(), MIN()
2. Assignment

🔹 Module 10: Primary & Foreign Key

1. Introduction to Keys
2. Primary Key
3. Foreign Key
4. Example for Keys

🔹 Module 11: JOINS

1. Introduction to Joins
2. Inner Join, Left Join, Right Join, Full Outer Join
3. Joins Real Time QnA
4. Assignment

🔹 Module 12: Subquery

1. Concept & Example 1–6
2. Corelated Subquery
3. Drawbacks of Corelated Subquery
4. Assignment

🔹 Module 13: Window Functions

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

🔹 Module 14: CTE's

1. Introduction
2. CTE Example 1
3. CTE with WINDOW Function
4. CTE Example 3
5. Recursive CTE
6. Recursive CTE Example

🔹 Module 15: TEXT Functions

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

🔹 Module 16: Numeric Functions

1. Introduction
2. ROUND(), CEIL(), FLOOR(), TRUNCATE(), ABS(), SIGN()

🔹 Module 17: Control Flow Functions

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

🔹 Module 18: Date & Time Functions

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

🔹 Module 19: Views

1. Introduction
2. Create View for single table
3. Create View for multiple table
4. Materialised View

🔹 Module 20: Scenario Based Interview QnA

1. Interview QnA

🔹 Module 21: SQL Complete Material

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

🔹 Module 22: SQL Projects

1. Project 1
2. Project 2
3. SQL + Power BI Project

Why This Course?

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

🔹 How This Course Is Taught

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

🔹 What You Will Learn

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

🔹 Who This Course Is For

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

📞 For Support or Queries

📧 Email: swapnjeet555@gmail.com

📱 WhatsApp: +91 9579005495