MySQL

Introduction to MySQL

1. Introduction to MySQL
2. Introduction to Database
3. Relational and non-relational databases
4. Installing MySQL
5. MySQL Workbench

Mysql Architecture

1. Database Structure
2. MySQL Storage Engines
3. MySQL Server

SQL Basic

1. Introduction to SQL
2. SQL syntax for creating database and table
3. Datatypes in MySQL
4. SQL commands for DML
5. Constraints

Retrieving Data

1. Basic Select Queries
2. WHERE Clause
3. Sorting and Limiting results
4. Joins
5. Group By and Having Clause
6. Alias Name
7. Nested Queries (Subquery)

Advanced SQL

1. Using Subqueries in Statements
2. Aggregate functions
3. Indexing

Mysql Function

1. String Function
2. Numeric Function
3. Date and Time Functions
4. Control Flow Functions

Mysql Database Administration

1. User Management in MySQL
2. Backup and Restore in MySQL
3. Security Best Practices for MySQL

Performance Optimization

1. Indexing Optimization
2. Query Optimization
3. Database Design Optimization

Advanced MySQL Features

1. Stored Procedures and Functions
2. Triggers in MySQL
3. Views in MySQL

MySQL Replication and Clustring

1. MySQL replication
2. MySQL Clustering
3. High Availability and Load Balancing in MySQL