LetCodes

Learn MySQL

This is a starter landing page for MySQL. Replace this paragraph with a short, friendly description of the topic and what readers will learn from the tutorial series.

Tutorial contents

MySQL Introduction
What is MySQL?
Installing MySQL
MySQL Workbench
The MySQL CLI
Connecting to a Server
Setting Up a Sample Database
Creating Databases
Data Types
Numeric Types
String Types
Date & Time Types
ENUM & SET Types
The JSON Type
Creating Tables
Altering Tables
Dropping & Truncating
AUTO_INCREMENT
INSERT
SELECT
UPDATE
DELETE
REPLACE & INSERT ... ON DUPLICATE KEY
WHERE Clause
Operators
ORDER BY
LIMIT & OFFSET
DISTINCT
LIKE & Wildcards
IN & BETWEEN
Aliases
Joins Overview
INNER JOIN
LEFT & RIGHT JOIN
CROSS JOIN
SELF JOIN
UNION
Aggregate Functions
GROUP BY
HAVING
Subqueries
Common Table Expressions (CTE)
Window Functions
String Functions
Numeric Functions
Date & Time Functions
Control Flow Functions
JSON Functions
Primary Keys
Foreign Keys
Constraints
Indexes
Full-Text Indexes
Composite Indexes
Normalization
Relationships
ER Modeling
Views
Stored Procedures
Stored Functions
Triggers
Events (Scheduler)
Cursors
Transactions
ACID Properties
Isolation Levels
Locking
Storage Engines (InnoDB vs MyISAM)
User Management
Privileges (GRANT/REVOKE)
Backup & Restore (mysqldump)
Replication
Partitioning
Character Sets & Collations
Server Configuration (my.cnf)
Query Optimization (EXPLAIN)
The Slow Query Log
Performance Tuning
Preventing SQL Injection
Security Best Practices
Best Practices
MySQL Cheat Sheet
Interview Questions