MySQL - Basic to Advanced

SQL Syllabus with Time Duration

Week 1: Introduction to SQL & Database Basics

• What is SQL? (1 hour)

• Importance of SQL in Databases (1 hour)

• SQL vs. NoSQL (1 hour)

• Installing MySQL/PostgreSQL/SQL Server (2 hours)

• Understanding Databases, Tables, Rows, and Columns (2 hours)

• Primary Key vs. Foreign Key (1 hour)

Week 2: SQL Basics – DDL (Data Definition Language)

• CREATE (Creating Tables) (2 hours)

• ALTER (Modifying Tables) (1 hour)

• DROP & TRUNCATE (Deleting Tables/Data) (1 hour)

• Constraints (NOT NULL, UNIQUE, CHECK, DEFAULT) (2 hours)

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

Week 3: SQL Basics – DML (Data Manipulation Language)

• INSERT (Adding Data) (2 hours)

• UPDATE (Modifying Data) (2 hours)

• DELETE (Removing Data) (2 hours)

• Bulk Insert and Transactions (2 hours)

Week 4: SQL Basics – DQL (Data Query Language) & Filtering Data

• SELECT (Retrieving Data) (2 hours)

• Filtering Data using WHERE Clause (2 hours)

• Sorting Data using ORDER BY (1 hour)

• Using LIMIT and OFFSET (1 hour)

• Pattern Matching with LIKE and Wildcards (2 hours)

• Working with NULL Values (1 hour)

Week 5: Joins, Aggregations & Subqueries

• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN (4 hours)

• GROUP BY and HAVING (2 hours)

• Aggregate Functions (SUM, AVG, COUNT, MIN, MAX) (2 hours)

• Subqueries (2 hours)

• Using EXISTS, ANY, ALL (1 hour)

Week 6: Advanced SQL & Performance Optimization

• Indexing for Performance (2 hours)

• Views in SQL (2 hours)

• Stored Procedures & Functions (3 hours)

• Triggers (2 hours)

• Common Table Expressions (CTEs) (2 hours)

• Window Functions (ROW_NUMBER, RANK, LEAD, LAG) (2 hours)

Final Week (Optional - Real-World Projects & Optimization Techniques)

• Writing Efficient SQL Queries (2 hours)

• Query Optimization Techniques (2 hours)

• Real-world Case Studies & Project Work (6 hours)