SQL Training Course

What is a Database?
Relational vs Non-Relational Databases
What is SQL and Why MySQL?
Overview of MySQL Architecture (Client, Server, Storage Engine)
Installing and Setting Up MySQL (Workbench & CLI)
MySQL Command-Line Basics (mysql -u root -p)
Creating and Dropping Databases (CREATE DATABASE, DROP DATABASE)
Understanding Tables, Rows, Columns, and Data Types
Using MySQL Workbench for Query Execution
MySQL vs Other RDBMS (SQL Server, PostgreSQL, Oracle)

CREATE TABLE, ALTER TABLE, DROP TABLE
MySQL Data Types — Numeric, String, Date/Time, JSON
Keys and Constraints (Primary Key, Foreign Key, Unique, Default, Check, Not Null)
AUTO_INCREMENT Columns
MySQL Storage Engines (InnoDB vs MyISAM)
Renaming Tables and Columns
Database Normalization (1NF, 2NF, 3NF, BCNF)
Designing Relationships: One-to-One, One-to-Many, Many-to-Many
Referential Integrity in MySQL
Schema Design Best Practices

INSERT INTO, UPDATE, DELETE
Truncate vs Delete in MySQL
Inserting Multiple Rows
Conditional Updates using WHERE
Using Transactions in MySQL (START TRANSACTION, COMMIT, ROLLBACK)
MySQL Savepoints
Using DEFAULT Values
Handling Foreign Key Constraints on Deletion
Common Data Errors & Troubleshooting
Practical Data Editing in MySQL Workbench

SELECT Statement Fundamentals
Filtering with WHERE, AND, OR, NOT
Using Operators: BETWEEN, IN, LIKE, IS NULL
Sorting Data with ORDER BY
Limiting Results with LIMIT
Aliases (AS) for Columns and Tables
String Functions (CONCAT, LENGTH, UPPER, SUBSTRING)
Date & Time Functions (NOW, DATEDIFF, DATE_FORMAT)
Conditional Expressions (CASE WHEN THEN END)
MySQL Query Optimization Basics

INNER JOIN
LEFT JOIN / RIGHT JOIN
FULL OUTER JOIN (via UNION workaround in MySQL)
CROSS JOIN
SELF JOIN
Subqueries (in WHERE, SELECT, and FROM)
Using EXISTS and NOT EXISTS
Nested and Correlated Subqueries
Common Table Expressions (CTEs) with WITH
Join Optimization Techniques

Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING Clauses
ROLLUP and Grouping Extensions
Handling NULLs in Aggregations
MySQL Window Functions (OVER, PARTITION BY)
Ranking Functions: RANK(), DENSE_RANK(), ROW_NUMBER()
Running Totals and Moving Averages
LAG() and LEAD() in Analytics
Analytical Query Design Patterns
Real-world Aggregation Scenarios (Sales, HR, Finance)

Creating Users (CREATE USER)
Assigning Privileges (GRANT, REVOKE)
Role Management in MySQL 8+
Password Management and Authentication Plugins
Restricting Database Access
Security Best Practices for MySQL
MySQL Views: CREATE VIEW, ALTER VIEW, DROP VIEW
Materialized Views (Simulation in MySQL)
Auditing and Logging in MySQL
Database Backup and Restore (mysqldump, mysqlimport)

Stored Procedures and Functions (CREATE PROCEDURE, CALL)
Triggers and Events (AFTER INSERT, BEFORE UPDATE)
Transactions and ACID Properties
Indexes: Clustered, Non-Clustered, Composite
Query Execution Plans (EXPLAIN, EXPLAIN ANALYZE)
Temporary Tables and Derived Tables
Recursive CTEs
Dynamic SQL in MySQL (PREPARE, EXECUTE)
Handling Large Datasets (Pagination with LIMIT OFFSET)
Query Optimization and Performance Tuning

MySQL Architecture Overview
Configuration Files (my.cnf)
Storage Engines: InnoDB, MyISAM, MEMORY, CSV
Backup and Recovery (Logical vs Physical)
Replication and Failover Concepts
Partitioning and Sharding
Performance Schema and Monitoring
Slow Query Log Analysis
Server Variables and Optimization
Upgrading and Maintaining MySQL Versions

SQL + Python Integration (mysql.connector, SQLAlchemy, pandas.read_sql)
SQL + Power BI Integration
MySQL in Web Development (Flask, Django)
MySQL for ETL Pipelines
Building Analytical Dashboards
Data Cleaning & Transformation in SQL
Stored Procedures for Reporting Automation
Query Optimization for BI Tools
Using MySQL with Cloud Platforms (AWS RDS, GCP Cloud SQL, Azure Database for MySQL)
MySQL in MLOps Pipelines