SQL 30 Hours Crash Course 🚀

November

This repository documents personal SQL learning progress from basic SELECT statements to advanced analytical queries. Each folder represents a specific topic with example .sql scripts and short notes.

Structure

Folder	Topic	Notes
1_querying_data	SELECT, WHERE, ORDER BY	View Notes
2_data_definition	CREATE, ALTER, DROP (DDL)	View Notes
3_data_manipulation	INSERT, UPDATE, DELETE (DML)	View Notes
4_filtering_data	Filtering with WHERE, LIKE, IN	View Notes
5_combining_data	Joins, subqueries, unions	View Notes
6_row_level_functions	String, date, numeric functions	View Notes
7_aggregation_analytics	GROUP BY, HAVING, window functions	View Notes
8_advanced_sql	CTEs, views, indexes, transactions	View Notes

🧩 Sample Data

All example queries use mock data defined in sample_data/.

🙏 Credits

Learning from various YouTube tutorials, including:

• Data with Bara SQL Full Course for Beginners (30 Hours)
• FreeCodeCamp SQL Course
• Alex The Analyst SQL for Beginners