SQL for Data Analysis - Complete Course Guide
==================================================
Session 1: Introduction to SQL & SELECT Queries
--------------------------------------------------
- What is SQL?
- Relational Database Concepts (Tables, Keys)
- SELECT Basics
- Column selection, Aliases, WHERE clause
- Exercises: Basic queries, filtering, aliases
- Assignment: Simple data retrieval tasks
- Quiz Questions
- Files: SQL script, mock CSVs
Session 2: Filtering, Sorting & Aliasing
--------------------------------------------------
- WHERE with comparison and logical operators
- ORDER BY: ASC, DESC
- Aliasing with AS for readability
- DISTINCT to remove duplicates
- BETWEEN, IN, LIKE, IS NULL
- Exercises: Use WHERE, ORDER BY, filters
- Assignment: Filter datasets, search patterns
Session 3: Aggregation & Grouping
--------------------------------------------------
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
- HAVING vs WHERE
- Combining aggregate functions with filters
- Exercises: Find totals, averages by group
- Assignment: Category analysis, customer spending
Session 4: Table Joins
--------------------------------------------------
- Understanding relationships between tables
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
- JOIN syntax and ON clause logic
- Combining multiple joins
- Exercises: Join customers, orders, and products
- Assignment: Revenue by product/category/customer
Session 5: Subqueries & Nested SELECTs
--------------------------------------------------
- Subqueries in SELECT, FROM, WHERE clauses
- Scalar, correlated subqueries
- Using subqueries to replace complex joins
- Exercises: Filter using subqueries
- Assignment: Top customers, last order info
Session 6: Window Functions & Advanced Analytics
--------------------------------------------------
- OVER(), PARTITION BY, ORDER BY in window functions
- ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE()
- LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE()
- Cumulative totals and running averages
- Exercises: Rankings, trends over time
- Assignment: Customer churn trend, sales trends
Session 7: Views, Indexes, and Performance
--------------------------------------------------
- Creating and using Views
- Temporary vs permanent Views
- Index basics and optimization tips
- Query optimization overview
- Assignment: Create view for top products
- Quiz: Index, view behavior
Session 8: Real-World SQL Case Study
--------------------------------------------------
- End-to-end project: E-commerce or Sales Dashboard
- Use joins, filters, aggregation, window functions
- Deliver insights from raw tables
- Present via dashboard or narrative SQL script
- Assignment: Deliver executive-level report
Session 9: SQL Tools & Practice Platforms
--------------------------------------------------
- Tools: DBeaver, pgAdmin, MySQL Workbench, SQLite, DuckDB
- Cloud: BigQuery, Snowflake, Redshift basics
- Online platforms: Mode, LeetCode SQL, StrataScratch, Hackerrank, DataLemur
- GitHub for SQL versioning and collaboration
Session 10: Interview & Certification Prep
--------------------------------------------------
- Common SQL interview questions & answers
- Case-based query problems
- Optimization techniques and pitfalls
- Resources: Mode tutorials, DataLemur, Khan Academy
- Certification tips: Google, IBM, Meta SQL certificates
