iwantcoding.com
🔥 Daily 👥 Rooms 🏆 Top Log in Sign up
« Previous

MySQL HOME

By · Reviewed & last updated · Part of MySQL Tutorial

Welcome to the iwantcoding.com MySQL Tutorial. MySQL is the most-deployed open-source database. Fast, predictable, and battle-tested — from WordPress sites to massive sharded Vitess clusters.

What this tutorial covers

ChapterYou will learn
MySQL BasicsInstall, mysql CLI, data types, CREATE DATABASE / TABLE, full CRUD, JOINs, GROUP BY, ORDER / LIMIT.
MySQL FeaturesAUTO_INCREMENT, JSON functions, CTEs, window functions, FULLTEXT, generated columns, partitioning.
Performance & OpsIndexes, EXPLAIN, transactions, InnoDB internals, users / privileges, backups, replication.
Server-side CodeFunctions, stored procedures, triggers, views, the events scheduler.
ExamplesCheatsheet, runnable snippets, quiz, exercises, bootcamp, certificate.

Who this is for

  • PHP / Rails / Node devs deploying classic LAMP-style apps.
  • Anyone managing legacy SQL.
  • Devs interviewing — MySQL questions show up everywhere.
How to use this tutorial: read the chapter, run the example with Try it Yourself », do the exercise, then take the quiz at the bottom. Hit Mark complete when you're done — the sidebar will track your progress.

Example

Example
SELECT 'Hello, MySQL' AS greeting;
Try it Yourself »

Discussion

Loading…

« Previous