About this project
A complete 19-chapter SQL learning journey based on 'Practical SQL: A Beginner's Guide to Storytelling with Data'. Each chapter builds progressively from basic queries to advanced data analysis techniques using real-world datasets.
The project works with substantial real data including U.S. Census population records, earthquake JSON datasets (9MB+), geographic shapefiles for roads, water bodies, and county boundaries. This grounding in real data makes the SQL skills immediately transferable to professional work.
Advanced topics include statistical analysis and aggregation, multi-table joins, data cleaning and validation, text mining with pattern matching, spatial/GIS data analysis, JSON data handling, views, functions, triggers, and command-line database management.
Key Features
- 19 progressive chapters
- Real-world datasets (Census, earthquake, GIS)
- Basic to advanced SQL queries
- Multi-table joins and aggregation
- Text mining and pattern matching
- Spatial/GIS data analysis
- JSON data handling
- Views, functions, and triggers