SQL for Data Analysis & Reporting

Week 1: SQL Foundations & Query Basics

• Introduction to databases and the role of SQL

• Setting up your environment (MySQL, PostgreSQL, or SQL Server)

• Understanding tables, rows, and columns

• Writing basic queries with SELECT, FROM, and WHERE

• Filtering data with logical operators

• Sorting results using ORDER BY and LIMIT

• Hands-on Exercise: Query a sample employee or sales database

Week 2: Working with Multiple Tables & Aggregations

• Understanding relationships between tables (primary & foreign keys)

• Joining tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN

• Using GROUP BY and HAVING for aggregation

• Common aggregate functions: COUNT, SUM, AVG, MIN, MAX

• Nested queries and subqueries

• Project: Build a report combining customer and order data

Week 3: Advanced SQL Techniques & Reporting

• Creating views and reusable queries

• Case statements and conditional logic

• Window functions: RANK, ROW_NUMBER, LEAD, LAG

• Working with dates and times

• Exporting query results for reports

• Project: Create a performance dashboard report using advanced SQL

Week 4: Final Project & Career Preparation

• Final Capstone Project: Analyse business data and present findings

• Code review and data storytelling with SQL

• Introduction to real-world databases (e.g. finance, e-commerce)

• CV and LinkedIn optimization for SQL/data roles

• Interview preparation and mock interview questions

• One-month placement briefing and job referral guidance

Additional Support Throughout the Course

• Weekly live SQL clinics and feedback sessions

• Real-world datasets and practical business case studies

• Access to mentors and peer community

• Lifetime access to materials and course updates