Free course

MySQL Course

Learn MySQL fundamentals: install and navigate the server, manage users and privileges, design tables, inspect queries, connect applications, and protect your data.

4 modules · 27 lessons · No signup

Prerequisites: SQL and Shell Commands

Download this course as PDF or EPUB

Read it offline, on your Kindle, or print it. Join my free newsletter and you get this course plus every other book and course I published.

Download PDFDownload EPUB
~~~

Your progress

of lessons completed.

Course completed.

What you'll learn

Run a MySQL database for a small application with a restricted user, safe queries, useful indexes, migrations, and a tested backup.

Course contents

  1. Start using MySQL

    Install the server, connect with the client, and navigate databases and tables.

    1. ✓ What MySQL is
    2. ✓ Install MySQL 8.4 on macOS
    3. ✓ Start and stop the MySQL server
    4. ✓ Connect with the mysql client
    5. ✓ Navigate databases and tables
    6. ✓ Check your understanding: MySQL server basics

  2. Users and privileges

    Keep root for administration and give applications only the access they need.

    1. ✓ Keep root for administration
    2. ✓ Create MySQL application accounts
    3. ✓ A MySQL account includes its host
    4. ✓ Grant MySQL privileges
    5. ✓ Inspect and revoke privileges
    6. ✓ Check your understanding: users and privileges

  3. Schema and performance

    Choose types, keys, character sets, indexes, and transaction behavior.

    1. ✓ Choose MySQL column types
    2. ✓ Primary keys and AUTO_INCREMENT
    3. ✓ Use utf8mb4 for text
    4. ✓ Inspect queries with EXPLAIN
    5. ✓ Use InnoDB transactions
    6. ✓ Check your understanding: schema and performance

  4. Applications and operations

    Connect through a pool, parameterize queries, migrate, back up, and troubleshoot.

    1. ✓ Connect to MySQL from Node.js
    2. ✓ Use a bounded connection pool
    3. ✓ Parameterize MySQL queries
    4. ✓ Keep connection configuration out of code
    5. ✓ Run MySQL migrations safely
    6. ✓ Back up and restore MySQL
    7. ✓ Troubleshoot a MySQL connection
    8. ✓ Build a MySQL notes application
    9. ✓ Check your understanding: applications and operations