MySQL Bootcamp By CertifiKation.

Module 1: Introduction to Databases & MySQL

• What is a Database?
• Introduction to RDBMS
• Overview of MySQL
• Installing MySQL & Workbench
• Basic SQL Syntax

Module 2: Database & Table Operations

• Creating a Database
• Creating Tables
• Viewing Databases and Tables
• Dropping Databases and Tables
• Modifying Table Structures (ALTER)

Module 3: Data Types & Constraints

• MySQL Data Types (INT, VARCHAR, DATE, etc.)
• NULL vs NOT NULL
• Primary Key, Foreign Key
• Unique, Default, Auto Increment Constraints

Module 4: CRUD Operations

• INSERT – Adding Data
• SELECT – Retrieving Data
• UPDATE – Modifying Data
• DELETE – Removing Data

Module 5: Filtering & Sorting Data

• WHERE Clause
• BETWEEN, IN, LIKE, IS NULL
• ORDER BY, LIMIT

Module 6: Functions & Expressions

• String Functions
• Date & Time Functions
• Numeric Functions
• Aggregate Functions (SUM, AVG, COUNT, etc.)

Module 7: Joins and Subqueries

• INNER JOIN
• LEFT JOIN, RIGHT JOIN
• FULL OUTER JOIN (simulated)
• Subqueries (Single & Multi-row)

Module 8: Grouping and Aggregation

• GROUP BY & HAVING
• Advanced Grouping
• Rollup (if supported)

Module 9: Views, Indexes & Transactions

• Creating and Using Views
• Indexes – Creating & Benefits
• Transactions – BEGIN, COMMIT, ROLLBACK

Module 10: User Management & Security

• Creating and Managing Users
• Granting & Revoking Permissions
• Backing up and Restoring Data

Module 11: Advanced Topics (Optional)

• Stored Procedures & Functions
• Triggers
• Events
• Performance Tuning Basics

Module 12: Project / Case Study

• Real-world mini project using MySQL
• Designing a normalized database
• Writing optimized queries