MySQL: Basic to Advanced

A complete bilingual MySQL course, from what a database is all the way to indexing, transactions, window functions, replication and security. Every page is written in both English and Bengali, with runnable SQL examples.

Introduction to Databases & MySQL

What is a Database & RDBMS?What is MySQL? Features & Architecture Installing MySQL & Connecting

Databases, Tables & Data Types

MySQL Data Types Creating Databases & Tables ALTER, DROP, TRUNCATE & RENAME

CRUD: Insert, Select, Update, Delete

INSERT: Adding Data SELECT Basics WHERE Clause & Operators UPDATE & DELETE

Sorting, Limiting & NULL Handling

ORDER BY, LIMIT & Pagination NULL, DISTINCT & CASE

Built-in Functions

String Functions Numeric & Math Functions Date & Time Functions

Aggregation & Grouping

Aggregate Functions GROUP BY, HAVING & ROLLUP

Joins & Set Operations

INNER JOIN LEFT, RIGHT & FULL Joins SELF JOIN, CROSS JOIN & UNION

Subqueries & Common Table Expressions

Subqueries CTEs & Recursive Queries

Keys, Constraints & Database Design

Constraints in MySQL Primary Keys & Foreign Keys Normalization & Schema Design

Views, Stored Procedures & Triggers

Views Stored Procedures & Functions Triggers, Cursors & Events

Transactions, ACID & Locking

Transactions & ACID Isolation Levels, Locking & Deadlocks

Indexing & Query Performance

Indexes in MySQL EXPLAIN & Query Optimization

Advanced MySQL Features

Window Functions JSON, Full-Text Search & Generated Columns Partitioning & Scaling

Administration, Backup & Security

Users, Roles & Privileges Backup, Restore & Security Practice Exercises & Next Steps

MySQL Tutorial — Basic to Advanced (English & Bengali) | DevNotes