📍 Module 1: Introduction to Databases & MySQL

• What is a Database & RDBMS?

• Introduction to MySQL and SQL

• Installing MySQL Server & Workbench

• Connecting to MySQL Server

• Understanding Databases, Tables, and Relationships

📍 Module 2: SQL Basics

• Creating and Dropping Databases

• Data Types in MySQL

• Creating Tables and Defining Constraints

• Inserting, Updating, and Deleting Data

• SELECT Statements & Filtering with WHERE

• ORDER BY, LIMIT, and DISTINCT

📍 Module 3: Advanced Querying

• Aggregate Functions: COUNT, SUM, AVG, MAX, MIN

• GROUP BY and HAVING Clauses

• Working with Joins: INNER, LEFT, RIGHT, FULL

• Aliases and Nested Queries (Subqueries)

• UNION and UNION ALL

• CASE Statements and Conditional Logic

📍 Module 4: Data Modeling & Relationships

• Primary Keys, Foreign Keys

• One-to-One, One-to-Many, and Many-to-Many Relationships

• Normalization (1NF, 2NF, 3NF)

• Designing a Relational Schema

📍 Module 5: Views, Indexes, and Transactions

• Creating and Using Views

• Creating Indexes for Performance

• Transactions and ACID Properties

• COMMIT, ROLLBACK, and SAVEPOINT

• Error Handling

📍 Module 6: Functions, Stored Procedures & Triggers

• Built-in SQL Functions (String, Date, Numeric)

• Creating & Using User-defined Functions

• Creating and Executing Stored Procedures

• Using Triggers for Automation

• Cursors and Loops in Stored Procedures

📍 Module 7: MySQL Administration Basics

• User Management and Permissions

• Backup and Restore Techniques

• Exporting and Importing Databases

• MySQL Configuration and Performance Tuning Basics

📍 Module 8: Real-Time Projects

• Student Management System Database

• E-Commerce Database Design & Reporting

• Sales Data Analytics with SQL Queries

• Building a Reporting Dashboard with SQL