Module 1: Introduction to MySQL

• What is MySQL?
• Features of MySQL
• Difference between MySQL and other RDBMS
• Installing MySQL and MySQL Workbench
• MySQL architecture overview
• Databases, tables, rows, and columns

Module 2: Database Basics

• Creating, altering, and dropping databases
• Using databases (USE command)
• Data types in MySQL (INT, VARCHAR, TEXT, DATE, etc.)
• Primary key, foreign key, and unique key
• NULL and default values

Module 3: Basic SQL Commands in MySQL

DDL (Data Definition Language)

• CREATE TABLE
• ALTER TABLE
• DROP TABLE
• TRUNCATE TABLE

DML (Data Manipulation Language)

• INSERT INTO
• UPDATE
• DELETE
• SELECT (basic queries)

Module 4: Data Retrieval Techniques

• WHERE clause with operators (=, <>, >, <, >=, <=)
• Logical operators: AND, OR, NOT
• LIKE, IN, BETWEEN
• ORDER BY (ASC, DESC)
• DISTINCT keyword

Module 5: Advanced SELECT Queries

• Aggregate functions: COUNT, SUM, AVG, MAX, MIN
• GROUP BY clause
• HAVING clause
• Aliases (AS)
• Subqueries / Nested queries
• EXISTS and NOT EXISTS

Module 6: Joins in MySQL

• Introduction to joins
• INNER JOIN
• LEFT JOIN / LEFT OUTER JOIN
• RIGHT JOIN / RIGHT OUTER JOIN
• FULL OUTER JOIN (via UNION)
• CROSS JOIN
• SELF JOIN

Module 7: Set Operations & Other SQL Concepts

• UNION and UNION ALL
• INTERSECT (via workaround in MySQL)
• EXCEPT / MINUS (via workaround)
• Views: creation, alteration, deletion
• Indexing for faster queries
• Sequences / Auto Increment fields

Module 8: Constraints & Keys

• Primary Key
• Foreign Key
• Unique Key
• NOT NULL constraint
• CHECK constraint (MySQL 8.0+)
• Default values

Module 9: Functions in MySQL

• String functions: CONCAT, LENGTH, SUBSTRING, UPPER, LOWER, TRIM
• Numeric functions: ROUND, CEIL, FLOOR, MOD
• Date & time functions: NOW(), CURDATE(), DATE_ADD(), DATE_SUB(), DATEDIFF()
• Conversion functions: CAST(), CONVERT()

Module 10: Transactions & ACID Properties

• Introduction to transactions
• COMMIT, ROLLBACK, SAVEPOINT
• ACID properties explained
• Transaction control commands (TCL)

Module 11: Stored Procedures & Triggers

• Creating stored procedures
• Parameters in procedures
• Calling procedures
• Creating triggers for INSERT, UPDATE, DELETE
• Trigger timing: BEFORE / AFTER

Module 12: Cursors & Error Handling

• Cursor basics
• DECLARE, OPEN, FETCH, CLOSE
• Cursor types: FORWARD_ONLY, SCROLL
• Exception handling using DECLARE … HANDLER

Module 13: MySQL Performance & Optimization

• Indexing for query optimization
• Optimizing SELECT queries
• Analyzing execution plans using EXPLAIN
• Using LIMIT for faster queries
• Normalization vs Denormalization

Module 14: MySQL Workbench & GUI Tools

• Overview of MySQL Workbench
• Creating databases and tables using GUI
• Query editor
• ER Diagram design
• Importing and exporting data

Module 15: Practical Exercises

• Create databases for School, Company, or Library
• Write queries for data retrieval & reporting
• Join multiple tables and generate reports
• Use aggregate functions for analytics
• Implement constraints, indexes, and triggers
• Create stored procedures for recurring tasks

Module 16: Projects

• Employee Management System
• Inventory Management System
• Student Information System
• Banking System Database
• Sales & Purchase Analysis Database
• E-commerce product database