The Complete SQL Bootcamp (30 Hours): Go from Zero to Hero

The Only SQL Course with 200+ Visual Animations: Learn Fast, Practice Hard & Build Real-World Projects

  • 0.0 (0 Reviews)
  • 0 Students
  • 349 Lessons
  • Baraa Khatib Salkini

Course Overview

The most visual and complete SQL course on the internet — built by a real data professional.

This isn’t your average SQL course with boring slides and textbook examples.

This is a fully animated, hands-on SQL bootcamp where you’ll not only learn how to write SQL — you’ll actually see how SQL works behind the scenes through 200+ custom-made animations, hand-drawn to help you truly understand each concept at its core.

This course is based on over 17 years of real-world experience working with data at top global companies like Mercedes-Benz and Bosch. Every lesson, project, and topic comes directly from real enterprise use cases — not academic theory.

Whether you're an absolute beginner or someone looking to level up, this course is designed to take you from zero to hero in SQL.

If you’ve never written a line of SQL, don’t worry - everything is explained from scratch, step by step. You’re not too old or too young — SQL is one of the easiest and most rewarding skills you can learn.

What makes this course truly unique:

  1. 200+ visual animations that make even complex SQL concepts easy to understand

  2. Built by a senior data expert with over 17 years in the industry — not a generic instructor

  3. Real-world projects based on tasks I’ve personally handled in enterprise environments

  4. Covers everything in SQL — from the absolute basics to advanced topics like Window Functions, CTEs, Query Optimization, SQL Warehousing, and Advanced Analytics

  5. Practice with real scenarios to go from beginner to job-ready with confidence


Topics covered in this complete course :

  • Introduction: Learn what SQL is, why it matters, how databases work, and how to set up your full SQL environment.

  • Querying Data (SELECT): Master SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, DISTINCT, TOP, and query execution order.

  • Data Definition (DDL): Create, modify, and remove database objects using CREATE, ALTER, and DROP commands.

  • Data Manipulation (DML): Add, update, and delete records using INSERT, UPDATE, and DELETE with real-world logic.

  • Filtering Data: Use comparison and logical operators like AND, OR, NOT, BETWEEN, IN, and LIKE to filter data effectively.

  • Combining Data: Join and merge tables using INNER, LEFT, RIGHT, FULL, CROSS joins and SET operations like UNION, INTERSECT.

  • Row-Level Functions: Use string, numeric, date, null-handling functions, and CASE expressions to transform your data.

  • Aggregation & Analytics: Apply aggregate functions and advanced window functions like RANK, DENSE_RANK, LAG, and LEAD.

  • Advanced SQL Techniques: Work with subqueries, CTEs (recursive and non-recursive), views, temp tables, procedures, and triggers.

  • Performance Optimization: Improve query speed using indexes, partitions, and practical performance tips.

  • AI & SQL: Use ChatGPT and GitHub Copilot to generate, explain, optimize, and debug SQL — plus translate and document code.

Hands-On Projects for Real Experience:

Watching tutorials is not enough – that’s why this course is packed with practical projects so you can immediately apply your new skills in real-world scenarios. Each project is designed to mirror actual work done by professionals:

  • SQL Data Warehouse: Design and implement a full-scale SQL data warehouse from scratch, just like you would in a real enterprise environment.

  • SQL for Data Analysis (EDA): Use SQL to perform exploratory data analysis on real datasets, extracting insights and creating reports as a data analyst would.

  • Advanced Query Optimization: Tackle complex query challenges and practice performance tuning on large datasets to simulate high-pressure, real-world scenarios.


Important Note on Databases

The course files include datasets for multiple database systems (SQL Server, MySQL, PostgreSQL, etc.).

  • This course mainly focuses on SQL Server (which runs only on Windows).

  • If you’re on Mac, you can still follow along by using MySQL or PostgreSQL — the SQL concepts are the same.

The goal of this course is to help you understand SQL concepts and how to apply them in real projects, regardless of the specific database.


By completing these projects, you'll translate theory into practice. You’ll not only reinforce your learning, but also build a portfolio of job-ready examples to show future employers.

Don't miss out on the chance to master SQL, the skill that will set you apart in the job market and propel your career to new heights. Enroll now and unlock the potential of your data with SQL expertise!

See more

FAQ

FAQ area empty

Course curriculum

30 chương 349 bài học 29 giờ 43 phút 7 bài học thử miễn phí
Chương 1 Introduction to SQL
Chương 2 SELECT Query
  • Components of SQL Học thử 2:45
  • What is SQL Query 1:46
  • SELECT & FROM 8:01
  • WHERE 6:03
  • ORDER BY 8:55
  • GROUP BY 8:17
  • HAVING 7:57
  • DISTINCT 3:22
  • TOP 5:13
  • Coding & Execution Order 4:00
  • Cool SQL Stuff 4:50
  • Quiz | SELECT Query
  • Sort a call list with ORDER BY
  • Filter groups with HAVING
Chương 3 Data Definition (DDL)
  • CREATE 6:19
  • ALTER 3:22
  • Create a table with constraints
  • DROP 1:45
  • Quiz | DDL
  • Add columns with ALTER TABLE
Chương 4 Data Manipulation (DML)
  • INSERT 13:26
  • UPDATE 6:30
  • DELETE 4:21
  • Quiz | DML
  • Fix scores with UPDATE
  • Change rows with INSERT and DELETE
Chương 5 Filtering Data
  • Intro - What is Data Filtering 1:16
  • Comparison operators 9:15
  • AND Operator 4:41
  • OR Operator 2:53
  • NOT Operator 3:28
  • BETWEEN Operator 4:28
  • IN Operator 4:14
  • LIKE Operators 10:46
  • Combine conditions in WHERE
  • Search with LIKE and BETWEEN
Chương 6 SQL Joins
  • Intro What is Combining Data 1:33
  • Introduction to JOINs 8:57
  • NO JOIN 1:40
  • INNER JOIN 12:30
  • LEFT JOIN 7:12
  • RIGHT JOIN 4:55
  • FULL JOIN 4:39
  • LEFT ANTI JOIN 4:03
  • RIGHT ANTI JOIN 4:56
  • FULL ANTI JOIN 6:57
  • CROSS JOIN 3:16
  • How to Choose The Correct Join 1:39
  • Multiple Table Joins 13:22
  • Join orders to customers
  • Find unmatched rows with joins
Chương 7 SQL SET Operators
  • Introduction to SET Operators 0:33
  • SET Rules & Syntax 11:58
  • UNION 5:25
  • UNION ALL 3:54
  • EXCEPT 5:18
  • INTERSECT 2:36
  • Use Case: Combine Information 9:43
  • Use Case: Delta Detection 3:55
  • SET Operators Summary 2:02
  • Combine lists with set operators
  • Compare lists with EXCEPT
Chương 8 String Functions
  • Intro - What is Data Transformation 1:03
  • SQL Functions 5:16
  • CONCAT 3:04
  • UPPER & LOWER 2:30
  • TRIM 5:27
  • REPLACE 3:31
  • LEN 1:49
  • LEFT & RIGHT 3:11
  • SUBSTRING 6:08
  • Number Functions 4:14
  • Find hidden spaces with TRIM
  • Clean text with string functions
Chương 9 Date & Time Functions
  • What is Date & Time 3:31
  • Overview Date & Time Functions 2:39
  • Date & Time Scripts
  • DAY, MONTH, YEAR 2:59
  • DATEPART 5:53
  • DATENAME 4:34
  • DATETRUNC 8:10
  • EOMONTH 3:31
  • Use Cases: Date Extraction 5:03
  • Compare Extract Functions 3:38
  • Intro to Formatting & Casting 5:34
  • FORMAT 13:13
  • CONVERT 6:23
  • CAST 5:08
  • DATEADD 4:43
  • DATEDIFF 4:21
  • ISDATE 7:24
  • Date & Time Summary 1:07
Chương 10 NULL Functions
  • Introduction to NULLs 2:36
  • COALESC vs ISNULL 11:30
  • Handling NULL: Data Aggregation 3:39
  • Handling NULL: Mathematic Operations 6:10
  • Handling NULL: Joining Data 7:05
  • Handling NULL: Sorting Data 5:32
  • NULLIF 5:57
  • IS NULL & IS NOT NULL 9:41
  • NULL vs Empty vs Blank 6:01
  • Handling NULL: Data Policies 8:35
  • NULL Summary 1:52
  • Handle NULLs in aggregations
  • Replace missing values with COALESCE
Chương 11 CASE WHEN Statement
  • Introduction to CASE Statements 9:34
  • Use Case: Categorizing Data 5:18
  • CASE Rules 1:30
  • Use Case: Mapping Values 8:51
  • Use Case: Handling Nulls 8:32
  • CASE Statement Summary 1:49
  • Assign levels with CASE
  • Sum by status with CASE
Chương 12 Window Functions Basics
  • Intro - What is Data Aggregation 6:34
  • Window Functions vs Group By 12:41
  • Syntax of Window Functions 5:02
  • Window Partition By 10:11
  • Window Order By 4:16
  • Window Frame 14:26
  • Window Function Rules 7:38
  • Window Basic Summary 2:26
  • Add totals with window functions
Chương 13 Window Aggregate Functions
  • Introduction to Window Aggregate Functions 2:03
  • Window COUNT 16:42
  • Window SUM 7:27
  • Window AVG 9:03
  • Window MIN & MAX 9:37
  • Use Case: Rolling & Running Total 9:36
  • Use Case: Moving Average 9:07
  • Window Aggregate Functions Summary 2:32
  • Calculate shares with window functions
  • Average over a window frame
Chương 14 Window Ranking Functions
  • Introduction to Ranking Functions 4:54
  • Window ROW_NUMBER 4:24
  • Window RANK 4:04
  • Window DENSE_RANK 4:25
  • ROW_NUMBER vs RANK vs DENSE_RANK 1:02
  • Use Cases: Top/Bottom N Analysis 7:15
  • Use Cases: Assign Unique IDs 2:46
  • Use Cases: Identify Duplicates 5:34
  • Window CUME_DIST 4:49
  • Window PERCENT_RANK 7:48
  • Window NTILE 13:39
  • Window Ranking Function Summary 2:09
  • Rank orders inside each product
  • Remove duplicates with ROW_NUMBER
Chương 15 Window Value Functions
  • Introduction to Window Value Functions 3:39
  • Window LEAD & LAG 9:44
  • Use Case: Month-Over-Month (MoM) 6:49
  • Use Case: Customer Retention 8:45
  • Use Case: Time Gap Analysis 5:43
  • Window FIRST & LAST 12:10
  • Window Value Functions Summary 3:16
  • Compare rows with LAG
Chương 16 Subqueries
  • Challenges in Complex Projects 17:26
  • Introduction to Subquery 2:44
  • Why Subquery 2:07
  • Subquery Categories 2:06
  • Subquery Result Types 2:30
  • Subquery in FROM 10:52
  • How DB Executes Subquery 1:35
  • Subquery in SELECT 7:02
  • Subquery in JOIN 5:02
  • Subquery in WHERE 6:44
  • Subquery using IN Operator 8:29
  • Subquery using ALL & ANY Operators 6:13
  • Correlated Subquery 10:46
  • Subquery using Exists 12:19
  • Subquery Summary 1:25
  • Filter with a subquery
  • Find missing rows with NOT EXISTS
Chương 17 Common Table Expression (CTE)
  • Introduction to CTE 6:03
  • Why CTE 4:55
  • How DB Executes CTE 2:16
  • CTE Types 0:35
  • Standalone CTE 8:42
  • Multiple Standalone CTE 8:04
  • Nested CTE 13:37
  • CTE Best Practices 2:41
  • Recursive CTE 27:29
  • CTE Summary 2:22
  • Combine summaries with CTEs
  • Walk a hierarchy with a recursive CTE
Chương 18 Views
  • Database Structure & Views 5:26
  • 3 Levels Architecture 4:47
  • What is View 1:57
  • Views vs Tables 1:39
  • Use Case: Central Logic 3:18
  • Views vs CTEs 1:44
  • CREATE, ALTER, DROP Views 12:15
  • How DB Executes View 2:59
  • Use Case: Hide Complexity 10:35
  • Use Case: Data Security 6:36
  • Use Case: Flexibility 2:13
  • Use Case: Multi-Language 2:04
  • Use Case: Data Warehouse 3:22
  • View Summary 2:31
  • Hide data with a view
  • Reuse logic with a view
Chương 19 CTAS & TEMP Tables
  • Introduction to Tables 3:28
  • CTAS vs CREATE/INSERT 2:44
  • CTAS vs Views 4:50
  • CTAS Syntax 2:43
  • Use Case: Optimize Performance 7:39
  • How DB Executes CTAS 0:53
  • Use Case: Snapshots 1:26
  • Use Case: Data Warehouse 2:15
  • Introduction to TEMP Tables 2:19
  • TEMP Syntax & Example 6:42
  • How DB Executes TEMP Tables 1:26
  • TEMP Table Use Cases 2:47
  • My opinion about TEMP Tables 0:24
  • Table Summary 1:58
  • Compare All Methods 9:28
  • Save results with CTAS
Chương 20 Stored Procedures
  • Introduction to Stored Procedures 9:26
  • Basics of Stored Procedures 4:04
  • Parameters 6:49
  • Multi-Queries in Stored Procedure 3:06
  • Variables 7:39
  • Control Flow IF ELSE 6:35
  • Error Handling TRY & CATCH 5:18
  • Styling Stored Procedures 2:48
  • What are Triggers 2:10
  • Triggers Use Case 8:28
Chương 21 Indexes
  • Introduction Indexes 1:32
  • Types of Indexes 1:41
  • Heap Structure 6:01
  • Clustered Index 6:10
  • NonClustered Index 4:46
  • Clustered vs NonClustered Index 8:07
  • How to Create INDEX 8:44
  • Composite Index 4:51
  • What is Columnstore Index? 1:45
  • Process of Building Columnstore Index 6:30
  • Columnstore vs Rowstore Index 6:54
  • How to Create Coluimnstore Index 10:44
  • Unique Index 5:34
  • Filter Index 5:41
  • Choose Right Index 3:30
  • Monitor Usage 13:41
  • Monitor Missing Indexes 3:15
  • Monitor Duplicate Indexes 3:08
  • Update Statistics 8:20
  • Fragmentations 6:06
  • Execution Plan 25:33
  • SQL hints 6:14
  • Indexing Strategy 1:07
Chương 22 Partitions
  • Introduction to Partitions 4:52
  • The Process of Partitions 17:18
  • Create Partitioned Tables 6:44
  • The Performance of Partitions 3:36
Chương 23 Performance Best Practices
  • Introduction to Performance Tips 1:27
  • Performance Tips for Fetching Data 2:46
  • Performance Tips for Filtering 5:21
  • Performance Tips for Joining 12:49
  • Performance Tips for Aggregation 2:14
  • Performance Tips for Subquiers 5:13
  • Performance Tips for Table DDL 7:36
  • Performance Tips for Indexing 2:04
  • Performance Tips Summary 1:06
Chương 24 Copilot & ChatGPT for SQL
  • Introduction to AI & SQL 0:53
  • What is ChatGPT & Copilot 2:11
  • ChatGPT vs Copliot 4:23
  • How to Use Copilot 5:38
  • ChatGPT Prompt Structure 3:25
  • ChatGPT Prompts for SQL Developers 27:48
  • ChatGPT Prompts for SQL Learning 12:13
Chương 25 SQL Data Warehouse Project
  • Project Resources
  • SQL Project Types 1:24
  • Intro to Data Warehouse (DWH) 6:47
  • What is ETL 3:52
  • ETL Methods 7:11
  • Get Project Resources 0:36
  • Notion for Project Management 7:35
  • Understand Project Requirements 3:12
  • Data Architecture Approaches 6:25
  • Design the Data Warehouse Layers 6:53
  • Draw DWH Architecture 8:18
  • Refine the Project Plan 0:51
  • Define The Naming Conventions 6:26
  • Prepare Your GIT Repo 4:24
  • Create The Database 5:12
  • Bronze Layer | Analyze Source Systems 5:18
  • Bronze Layer | DDL Create Tables 5:36
  • Bronze Layer | Load Scripts 7:52
  • Bronze Layer | Build Stored Procedure 13:06
  • Bronze Layer | Document The Work 4:55
  • Silver Layer | Exploring Data 12:26
  • Silver Layer | DDL Create Tables 3:42
  • Silver Layer | Load Script 1 15:08
  • Silver Layer | Load Script 2 20:40
  • Silver Layer | Load Script 3 16:46
  • Silver Layer | Load Script 4 18:47
  • Silver Layer | Build Stored Procedure 5:47
  • Silver Layer | Document The Work 3:31
  • Gold Layer | Data Modelling 6:57
  • Gold Layer | Analysis 3:49
  • Gold Layer | Build Dimension Customers 16:23
  • Gold Layer | Build Dimension Products 7:08
  • Gold Layer | Build Fact Sales 6:01
  • Gold Layer | Draw The Data Model 5:05
  • Gold Layer | Create Data Catalog 2:38
  • Gold Layer | Document The Work 5:29
Chương 26 Exploratory Data Analysis Project
  • Project Resources
  • Introduction to EDA 0:17
  • Data Analytics Project Roadmap 1:53
  • What is EDA and Why Is It Important? 1:14
  • Get Project Resources 7:03
  • Dimensions vs Measures 4:34
  • Database Exploration 3:16
  • Dimensions Exploration 3:48
  • Date Exploration 5:13
  • Measure Exploration 8:31
  • Magnitude Analysis 11:26
  • Ranking Analysis 7:23
Chương 27 SQL Advanced Data Analytics Project
  • Introduction to the Project 0:42
  • Change Over Time Analysis 8:23
  • Cumulative Analysis 7:50
  • Performance Analysis 12:24
  • Part to Whole Analysis 7:22
  • Data Segmentation 15:49
  • Build Customers Report 19:12
  • Build Products Report 3:37
  • Document Your Work in GIT 2:08
Chương 28 THANK YOU
  • Congratulations & THANK YOU Video 0:18
Chương 29 SQL Practice Lab
  • Customer scores by country
  • Employees without reports
  • Customers in both categories
  • Product stock table
  • Average spend per country
  • Total reports per employee
  • Finance figure check
  • Biggest open orders
  • Top customers by sales
  • Sales per salesperson
Chương 30 SQL Exam
  • SQL Final Exam
  • The SQL Technical Interview

Requirment

  • No prior SQL or programming experience is required!

  • You just need a computer with internet access

  • All tools used in the course are free and easy to set up — we’ll guide you every step of the way

Outcomes

  • You'll learn the basics: what SQL is, how databases work, and why SQL is essential for working with data

  • You’ll learn how to query using SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and more

  • You’ll learn how to combine multiple tables using JOINS, UNION, INTERSECT, and EXCEPT

  • You’ll learn all SQL functions including String, Numeric, Date/Time, and CASE logic

  • You’ll learn how to handle NULL values in SQL

  • You'll master ALL Window Functions (LEAD, LAG, RANK, ROW_NUMBER etc.)

  • You’ll master advanced SQL techniques like Subqueries, CTEs, Views, and Temp Tables

  • You’ll learn how to create and use Stored Procedures and Triggers for automation and logic

  • You’ll learn how to optimize performance, reduce query time, and tune indexes

  • You’ll learn how to integrate SQL with AI and Data Science tools for real business use

  • You’ll learn how to build and query a complete SQL Warehouse from scratch

  • You’ll learn how to use SQL for EDA (Exploratory Data Analysis) on real-world datasets

  • You’ll learn how to apply advanced analytics techniques using SQL

Instructor

...
Baraa Khatib Salkini

0.0

  • ... 0 Student
  • ... 1 Course
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all