SQL Course Curriculum

Topic 3.1: Relational Databases & SQL

Theory:

• Introduction to RDBMS (e.g., PostgreSQL, MySQL)

• DDL & DML commands (CREATE, INSERT, SELECT, etc.)

• Joins, subqueries, aggregations

• Indexing and performance tuning

• Transactions and ACID properties

  Lab:

• Create a customer and transactions table for a bank

• Write queries for average balance, top N spenders, etc.

• Implement foreign key relationships between tables

  Scenarios:

• Generate monthly transaction reports

• Link customer IDs with account history for fraud detection

  Tasks:

• Write a SQL query to find dormant accounts

• Aggregate total transactions by city and branch

  Challenges:

• Optimizing slow queries with multiple joins

• Handling NULLs and data integrity issues