Learn SQL

Module 1: SQL Basics & Setup

⏳ 1 week

• Topics: Installing and connecting to a database (PostgreSQL/MySQL), basic SELECT queries, filtering with WHERE

• Hands-on: Query a sample employees table to retrieve specific records

Module 2: Data Retrieval & Filtering

⏳ 1 week

• Topics: ORDER BY, LIMIT, pattern matching with LIKE, logical operators

• Hands-on: Find top-selling products and filter customers by region and purchase history

Module 3: Joining Tables

⏳ 1 week

• Topics: Inner, left, right, and full outer joins; self-joins; cross joins

• Hands-on: Combine orders and customer tables to produce consolidated sales reports

Module 4: Aggregation & Grouping

⏳ 1 week

• Topics: GROUP BY, HAVING, aggregate functions (SUM, COUNT, AVG, MIN, MAX)

• Hands-on: Calculate monthly revenue, average order value, and identify top 10% of customers

Module 5: Subqueries & Common Table Expressions

⏳ 1 week

• Topics: Inline subqueries, correlated subqueries, WITH clauses for modular queries

• Hands-on: Use CTEs to break down a complex nested query into readable steps

Module 6: Window Functions & Advanced Analytics

⏳ 1 week

• Topics: ROW_NUMBER, RANK, LEAD, LAG, running totals, moving averages

• Hands-on: Generate sales trends with rolling averages and rank products by performance

Module 7: Data Modification & Transaction Control

⏳ 1 week

• Topics: INSERT, UPDATE, DELETE, TRUNCATE; transaction statements (BEGIN, COMMIT, ROLLBACK)

• Hands-on: Safely update inventory quantities and rollback on constraint violations

Module 8: Schema Design & Performance Tuning

⏳ 1 week

• Topics: Normalization (1NF–3NF), indexing strategies, analyzing execution plans

• Hands-on: Design a normalized schema for an e-commerce app and optimize slow-running queries

Get certificate