The materials of the SQL course: the databases, every query from the lessons, and the slides.
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.
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
| 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
MIT. Use it, change it, share it, with attribution.
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.