Data & SQL
Learn data fundamentals: Python for analysis, SQL for querying, and the math and algorithms that turn raw tables into insight.
What you'll be able to do
- Write SELECT queries with filters and aggregates
- Join data across multiple tables
- Analyze datasets in Python
- Apply math and algorithms to real data
The roadmap โ complete each quest in order
- ๐
1. ๐ Python Basics ๐
0/14Learn Python from scratch โ read code, return values, do a little math, make choices, loop, and work with text. Real Python runs right in your browser, no install needed. One tiny, friendly step at a time.
2. Python Lists & Dicts
6 lessonsFinish the previous course to unlock
3. Statistics with Python's stdlib
8 lessonsFinish the previous course to unlock
4. SQL Basics
6 lessonsFinish the previous course to unlock
5. SQL Joins & Aggregation
6 lessonsFinish the previous course to unlock
6. SQL Window Functions
6 lessonsFinish the previous course to unlock
7. CASE Expressions & Conditional Aggregation
9 lessonsFinish the previous course to unlock
8. Recursive CTEs & Hierarchical Queries
8 lessonsFinish the previous course to unlock
9. Database Normalization: 1NF, 2NF & 3NF
9 lessonsFinish the previous course to unlock
10. Transactions, ACID & Isolation Levels
9 lessonsFinish the previous course to unlock
11. Math for Programmers
6 lessonsFinish the previous course to unlock
12. Algorithms & Problem Solving
12 lessonsFinish the previous course to unlock