This repository contains all SQL scripts used in the SQL Basics YouTube tutorial series.
-
Download and install MySQL Community Server:
https://dev.mysql.com/downloads/mysql/ -
Download and install MySQL Workbench:
https://dev.mysql.com/downloads/workbench/
Use default port 3306. If it is already in use, set it to 3307.
Use password:adminfor practice purposes.
Each part in the series corresponds to a script file in this repo:
| Part | Topic |
|---|---|
| 1 | Environment Setup |
| 2 | SELECT Basics |
| 3 | WHERE Clause |
| 4 | Sorting and Limiting |
| 5 | Aggregate Functions |
| 6 | GROUP BY |
| 7 | JOINS |
| 8 | Practice Project + Wrapup |
You can explore more datasets for practice using BigQuery Public Datasets:
https://console.cloud.google.com/marketplace/browse?filter=solution-type:dataset&pli=1
Watch the full tutorial series on YouTube:
Coming soon...
MIT License.