MySQL

MySQL

SQL from the ground up. Schema design, queries, joins, indexing, transactions, stored procedures, replication, and performance tuning.

BeginnerTopics 1–10
  • ·What Is MySQL?
  • ·Install & First Database
  • ·CREATE TABLE
  • ·Data Types
  • ·INSERT: Adding Data
  • ·SELECT: Querying Data
  • ·UPDATE & DELETE
  • ·WHERE & Filtering
  • ·JOINs (INNER & LEFT)
  • ·ORDER BY & LIMIT
Start Beginner →
IntermediateTopics 1–10
  • ·Composite Indexes
  • ·EXPLAIN: Query Profiling
  • ·Transactions & ACID
  • ·Stored Procedures
  • ·Triggers
  • ·Views
  • ·Full-Text Search
  • ·JSON Column Type
  • ·User Permissions & Grants
  • ·Replication Basics
Start Intermediate →
AdvancedTopics 1–10
  • ·Query Optimisation Deep-Dive
  • ·Partitioning
  • ·InnoDB Internals
  • ·Window Functions
  • ·CTEs & Recursive Queries
  • ·Event Scheduler
  • ·Spatial Data
  • ·MySQL 8.0 New Features
  • ·Point-in-Time Recovery
  • ·Binary Log Mastering
Start Advanced →
ProductionTopics 1–10
  • ·High Availability (Group Replication)
  • ·ProxySQL: Query Routing
  • ·Backup Strategies
  • ·Monitoring & Performance Schema
  • ·Connection Pooling
  • ·Charset & Collation Pitfalls
  • ·Zero-Downtime Migrations
  • ·Security Hardening
  • ·MySQL in the Cloud
  • ·Buffer Pool Tuning
Start Production →