README.md

SQL Ultimate Course

The materials of the SQL course: the databases, every query from the lessons, and the slides.

⭐ If this course helps you, star the repository so other learners can find it too.

New here? Open the setup guide in the 00_setup folder. It walks you through installing SQL Server and creating the databases, on Windows and Mac, with the fixes for the common errors.

sql-ultimate-course/
├── 00_setup/            the setup guide, and the one-click Docker start for Mac
├── 01_datasets/         the two course databases
│   ├── 00_sql-server/   for SQL Server, the one in the videos
│   ├── 01_mysql/        the same databases for MySQL
│   ├── 02_postgres/     the same databases for PostgreSQL
│   └── 03_csv-files/    SalesDB as CSV files, for the import lesson
├── 02_docs/             the slides of every chapter, as PDF
└── 03_scripts/          every query of the course, one file per chapter

The course uses two databases: MyDatabase for the first chapters, SalesDB for the rest. Every script that works on a database starts with a USE line that names it.

The 41 chapters: the minute in the video, the script and the slides of each one

#	Chapter	Video	Script	Slides
1	Intro	0:00:00
2	Introduction to SQL	0:07:38		01_SQL_Introduction.pdf
3	Setup Your Environment	0:22:33	the setup guide
4	Query Data (SELECT)	0:34:01	01_Query_Data_SELECT.sql	02_Query_Data_SELECT.pdf
5	DDL Commands	1:32:31	02_Data_Definition_DDL.sql	03_Data_Definition_DDL.pdf
6	DML Commands	1:43:44	03_Data_Manipulation_DML.sql	04_Data_Manipulation_DML.pdf
7	Filtering Data	2:08:03	04_Filtering_Data.sql	05_Filtering_Data.pdf
8	SQL Joins (Basics)	2:47:57	05_JOINs.sql	06_JOINS_and_SET.pdf
9	SQL Joins (Advanced)	3:27:29	05_JOINs.sql	06_JOINS_and_SET.pdf
10	Set Operators	4:02:09	06_SETs.sql	06_JOINS_and_SET.pdf
11	SQL Functions	4:47:41		07_Row_Level_Functions.pdf
12	String Functions	4:52:58	07_String_Functions.sql	07_Row_Level_Functions.pdf
13	Numeric Functions	5:18:44	08_Number_Functions.sql	07_Row_Level_Functions.pdf
14	Date and Time Functions	5:22:48	09_Date_Time_Functions.sql, 10a, 10b, 10c, 10d	07_Row_Level_Functions.pdf
15	NULL Functions	6:59:06	11_NULL_Functions.sql	07_Row_Level_Functions.pdf
16	Case Statement	8:07:50	12_Case_Statements.sql	07_Row_Level_Functions.pdf
17	Aggregate Functions	8:43:36	13_Aggregate_Functions.sql	08_Aggregation_Analytical_Functions.pdf
18	Window Functions Basics	8:50:11	14_Window_Functions_Basics.sql	08_Aggregation_Analytical_Functions.pdf
19	Window Aggregate	9:47:00	15_Window_Aggregations.sql	08_Aggregation_Analytical_Functions.pdf
20	Window Ranking	10:53:09	16_Window_Ranking.sql	08_Aggregation_Analytical_Functions.pdf
21	Window Value	11:56:05	17_Window_Value_Functions.sql	08_Aggregation_Analytical_Functions.pdf
22	Advanced SQL Techniques	12:40:34		09_Advanced_SQL_Techniques.pdf
23	Subqueries	12:58:04	18_Subqueries.sql	09_Advanced_SQL_Techniques.pdf
24	Common Table Expressions (CTE)	14:18:08	19_Common_Table_Expressions_CTE.sql	09_Advanced_SQL_Techniques.pdf
25	Views	15:35:02	20_Views.sql	09_Advanced_SQL_Techniques.pdf
26	CTAS and Temp Tables	16:36:40	21_Temporary_Tables.sql	09_Advanced_SQL_Techniques.pdf
27	Compare Advanced Techniques	17:17:31		09_Advanced_SQL_Techniques.pdf
28	Stored Procedures	17:27:04	22_Stored_Procedures.sql	09_Advanced_SQL_Techniques.pdf
29	Triggers	18:12:58	23_Triggers.sql	09_Advanced_SQL_Techniques.pdf
30	Indexes	18:23:42	24_Indexes.sql	10_Performance_Optimization.pdf
31	Execution Plan	20:20:31		10_Performance_Optimization.pdf
32	Partitions	21:11:03	25_Partitions.sql	10_Performance_Optimization.pdf
33	30x Performance Tips	21:43:39	26_Performance_Optimization.sql	10_SQL_30_Performance_Tips.pdf
34	AI and SQL	22:24:25	27_AI_and_SQL.sql	11_AI_and_SQL.pdf
35	Project: SQL Data Warehouse	23:21:04	the warehouse repository	12_SQL_Projects.pdf
36	Project DWH | Bronze	24:32:54	bronze	12_SQL_Projects_ETL.pdf
37	Project DWH | Silver	25:10:09	silver	12_SQL_Projects_ETL.pdf
38	Project DWH | Gold	26:47:46	gold	12_SQL_Projects_ETL.pdf
39	Project: Exploratory Data Analysis (EDA)	27:41:51	the analytics repository	12_SQL_Projects_Data_Analytics.pdf
40	Project: Advanced Data Analytics	28:30:38	the analytics repository	12_SQL_Projects_Data_Analytics.pdf
41	Thank You	29:47:24

The cheat sheet of the whole course: SQL_Cheat_Sheet.sql.

---

🎓 Learn with me

Watch on YouTube, or take the guided version with a certificate on my Academy or Udemy.

Course	YouTube	My Academy	Udemy
SQL	Full course · Playlist	Full Package · Handbook	SQL Bootcamp · SQL for Analytics
Python	Full course · Playlist	Full Package · Handbook	Python Bootcamp
Tableau	Full course · Playlist	Full Package	Tableau Course · Chart Masterclass
Power BI	Full course
Databricks	Full course

Materials on my website: SQL · Python · Tableau · Power BI

The SQL projects

Project	YouTube	Materials	Udemy
Data Warehouse	Watch	Repository	Building a Modern Data Warehouse
Exploratory Data Analysis	Watch	Repository	SQL for Exploratory Data Analysis
Advanced Data Analytics	Watch	same repository

More on YouTube: Data projects · Data careers

🤝 Connect

🛡️ License

MIT. Use it, change it, share it, with attribution.

🌟 About me

Hi, I'm Baraa Khatib Salkini. I spent years in enterprise data engineering and built one of the largest lakehouses at Mercedes-Benz. Today I teach data full-time at Data With Baraa: visually, step by step, from zero to hero.