Week 1: Introduction to Databases & SQL Basics
- Understanding databases & relational models
- Tables, rows, and columns explained
- Introduction to SQL syntax
- Basic queries: SELECT, FROM, WHERE
Hands-on: Querying a sample database
Week 2: Data Retrieval & Filtering
- Sorting results with ORDER BY
- Filtering with AND, OR, NOT, IN, BETWEEN, LIKE
- Working with NULL values
- Using DISTINCT to handle duplicates
Hands-on: Extract customer insights from a dataset
Week 3: Aggregation & Joins
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- Grouping data with GROUP BY and HAVING
- Table joins: INNER, LEFT, RIGHT, FULL
Hands-on: Build sales performance reports using joins
Week 4: Advanced SQL & Database Management
- Subqueries & nested queries
- Data modification: INSERT, UPDATE, DELETE
- Database design concepts (keys, indexes, normalization)
- Introduction to views & stored procedures
Mini Project: Design and query a small relational database
