01

Introduction to SQL

Understanding databases and SQL from the ground up

• What is SQL?
• How databases work
• Your first query

02

SELECT & WHERE Clauses

Retrieve and filter data from your database

• SELECT statement basics
• WHERE clause filtering
• Comparison & logical operators

03

JOINs & Relationships

Combine data from multiple tables

• INNER JOIN
• LEFT and RIGHT JOINs
• Table relationships

04

Aggregate Functions

Summarize and analyze your data

• COUNT, SUM, AVG
• MIN, MAX functions
• GROUP BY and HAVING

05

Subqueries & Nested SELECT

Write queries within queries

• Subquery basics
• Correlated subqueries
• IN, EXISTS operators

06

INSERT, UPDATE, DELETE

Modify data in your database

• Adding new records (INSERT)
• Updating existing data
• Deleting records safely

07

CREATE & ALTER Tables

Design and modify database schemas

• Creating tables
• Data types and constraints
• Altering table structure

08

Indexes & Performance

Optimize queries for speed

• How indexes work
• Creating and using indexes
• Query optimization

09

Transactions & ACID

Ensure data integrity and consistency

• Transaction basics
• COMMIT and ROLLBACK
• ACID properties

10

Advanced SQL Techniques

Master complex queries and patterns

• Window functions
• Common Table Expressions (CTEs)
• Advanced patterns