3 Months

📚 Complete SQL Syllabus – From Basics to Business Intelligence

🔍 MODULE 1: SQL FOUNDATIONS

Objective: Understand databases and get comfortable with SQL syntax.

• What is SQL? Why it matters in every data job

• Relational Databases: Tables, Rows, Columns

• Primary Keys vs Foreign Keys

• Data Types in SQL (INT, VARCHAR, DATE, etc.)

• SQL IDEs & Environments: MySQL Workbench, PostgreSQL, SQL Server, BigQuery, etc.

• Installing sample databases (e.g., Sakila, AdventureWorks)

🧱 MODULE 2: SELECT STATEMENTS & FILTERING

Objective: Query data like a pro.

• SELECT, FROM, WHERE

• Filtering with comparison and logical operators

• BETWEEN, IN, LIKE, IS NULL

• Sorting with ORDER BY

• Aliases (AS) for readability

🧮 MODULE 3: AGGREGATIONS & GROUPING

Objective: Summarize and analyze data.

• COUNT(), SUM(), AVG(), MIN(), MAX()

• GROUP BY clause

• Filtering groups with HAVING

• Combining GROUP BY with ORDER BY

🔗 MODULE 4: JOINS & RELATIONSHIPS

Objective: Work across multiple tables.

• Understanding relationships between tables

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

• CROSS JOIN & SELF JOIN

• Join performance tips

🎯 MODULE 5: SUBQUERIES & NESTED QUERIES

Objective: Query inside a query.

• Inline subqueries (in SELECT)

• Subqueries in WHERE and FROM

• EXISTS, NOT EXISTS

• Correlated subqueries

• Performance considerations with subqueries

🛠 MODULE 6: DATA MANIPULATION (DML)

Objective: Insert, update, and delete data safely.

• INSERT INTO

• UPDATE with WHERE

• DELETE with WHERE

• Transactions: BEGIN, COMMIT, ROLLBACK

• Error handling with transactions

📐 MODULE 7: DATA DEFINITION (DDL)

Objective: Design and structure databases.

• CREATE TABLE, ALTER TABLE, DROP TABLE

• Constraints: NOT NULL, UNIQUE, CHECK, DEFAULT

• Defining Primary and Foreign Keys

• Indexes: What they are and how they work

🧠 MODULE 8: ADVANCED SQL CONCEPTS

Objective: Write powerful, optimized queries.

• Common Table Expressions (CTEs)

• Window Functions: ROW_NUMBER(), RANK(), LEAD(), LAG(), PARTITION BY

• Case Statements

• Views: CREATE VIEW, DROP VIEW, use cases

• Stored Procedures & Functions (Intro)

🚀 MODULE 9: PERFORMANCE & OPTIMIZATION

Objective: Make your queries fast and scalable.

• Query Execution Plan Basics

• Index strategies

• Analyzing slow queries

• Optimizing JOINs and WHERE clauses

• Avoiding costly operations (e.g., nested SELECTs)

📊 MODULE 10: BUSINESS INTELLIGENCE & REPORTING

Objective: Build insights, not just queries.

• Connecting SQL to Tableau, Power BI

• Writing SQL for dashboards

• KPI calculations (NRR, Churn, CAC, etc.)

• Temporal data analysis (MoM, YoY, Cohorts)

• Creating reusable SQL scripts for automation

💻 MODULE 11: REAL-WORLD PROJECTS & CASE STUDIES

Objective: Apply everything with real-world datasets.

• E-commerce sales analysis

• Customer churn prediction (data extraction)

• Employee attrition modeling

• Finance dashboards: revenue, expenses, trends

• Marketing analytics: campaign performance, funnel analysis

🔒 BONUS: DATA SECURITY & BEST PRACTICES

• User permissions & role-based access

• SQL Injection basics and prevention

• Clean coding practices

• Commenting, formatting, and documentation