MySQL

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

1. 1

   Introduction to MySQL

   What makes MySQL distinct, and connecting to a server.

   preview
2. 2

   Data Types

   INT, VARCHAR, DATETIME, and choosing the right one.

3. 3

   Creating Tables

   CREATE TABLE, primary keys, and constraints.

4. 4

   Joins

   INNER, LEFT, and combining tables.

5. 5

   Indexes

   Speeding up common lookups.

6. 6

   Stored Procedures

   Reusable server-side logic.

7. 7

   Transactions

   COMMIT, ROLLBACK, and isolation levels.

8. 8

   User Management

   Creating users and granting privileges.