Day 1: Introduction to DBMS

1. Introduction to Databases
   • What is a Database?
   • Purpose and importance of databases
2. Database Management Systems (DBMS)
   • What is DBMS? Why is it needed?
   • Advantages and limitations of DBMS
3. Types of DBMS
   • Hierarchical
   • Network
   • Relational
   • Object-oriented
4. Introduction to Relational Databases
   • Concept of tables, records, and fields
   • Importance of Primary Key
5. Normalization
   • Introduction to normalization
   • 1NF, 2NF, 3NF, BCNF
6. SQL Basics
   • What is SQL?
   • Role of SQL in DBMS

Day 2: Dive into MySQL & Basic Queries

1. Introduction to MySQL
   • History and importance of MySQL
   • Installation and setting up MySQL
2. Basic SQL Commands
   • DDL (Data Definition Language) Commands: CREATE, ALTER, DROP
   • DML (Data Manipulation Language) Commands: SELECT, INSERT, UPDATE, DELETE
3. Working with Data
   • The SELECT statement: fetching data
   • Filtering data with WHERE
   • Sorting results using ORDER BY
4. Functions and Aggregation
   • Common functions: COUNT, SUM, AVG, MIN, MAX
   • Grouping results using GROUP BY

Day 3: Advanced SQL & Complex Queries

1. Joins in SQL
   • Understanding the need for joins
   • INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
2. Subqueries
   • Concept and utility of subqueries
   • Types of subqueries: IN, EXISTS, FROM
3. Advanced SQL Functions
   • String functions: UPPER, LOWER, CONCAT, TRIM, LENGTH
   • Date functions: NOW, DATE_FORMAT, DATEDIFF
4. Indexes & Views
   • Importance of indexing
   • Creating and managing views