MySQL

1

Connecting to MySQL Connect from the command line and from PHP, and understand hosts, ports and users.

Tutorial

Start → →

2

Creating Databases and Tables Create a database with the right charset and build tables with sensible types and constraints.

Tutorial

Start → →

3

Data Types and Constraints Pick types that fit the data and let MySQL enforce correctness.

Tutorial

Start → →

4

Reading and Writing Data Use SELECT, INSERT, UPDATE and DELETE from applications and the command line.

Tutorial

Start → →

5

Joins and Relationships in MySQL Query related tables and keep relationships consistent with foreign keys.

Tutorial

Start → →

6

Functions, Dates and Text Use built-in functions for formatting, dates and text so reports read well.

Tutorial

Start → →

7

Views and Stored Procedures Save reusable queries as views and wrap multi-step work in stored procedures.

Tutorial

Start → →

8

Users, Permissions and Backups Create least-privilege users and take backups you can actually restore.

Tutorial

Start → →

9

Project: A Small School Database Design, build and query a small school database from scratch.

Project

Start → →