Quickstart to MySQL

Understanding MySQL Basics
Connecting to the MySQL server
Creating and Using Your First Database

Data Types and Table Types

Exploring the Various Column types
MySQL Options
Exploring the Various Table Types

Advanced SQL

OperatorsAdvances Joins
Adding Records to a Table from other    Tables with INSERT SELECT
More About Adding Records
More About Removing Records
User Variables
Running SQL Statements Stored in    Files
Transactions and Locking

Indexes and Query Optimisation

Understanding Indexes
Creating an Index
Using an Auto Increment Field
Dropping or Changing and Index
Understanding Table Types and    Indexes
Using Indexes Effectively
Analysing How MySQL Uses Indexes    with Explain
Optimising Selects
Optimising Updates, Deletes, and    Inserts

Programming with MsSQL

Using Good Database Programming    Techniques
The Stages of Application    Development

Database Design

The Database Lifecycle
Real-World Example: Creating and    Publishing Tracking System
Concurrency Control

Understanding Relational Databases

Exploring Early Database Models
Understanding the Relational Database    Model

Database Normalization

Understanding Normalization
Understanding Demoralization

Extending MsSQL

User-Defined Functions
Troubleshooting

Basic Administration

Meeting MySQL as an Administrator
Starting and Shutting Down MySQL
Configuring MySQL
Logging
Optimizing, Analysing, Checking and
   Repairing Tables

Database Backups

Backing Up MyISLAM Tables with    BACKUP
Restoring MyISLAM with Tables with    RESTORE
Backing Up MyISLAM Tables
Backing Up with mysqldump
Backing Up wihth SELECT INTO
Using mysqlhotcopy to Back Up
Using the Binary Update Log to Restore    a Database to the most Recent    Position
Replication as a Means of Backup

Database Replication

Understanding Replication
Setting up Replication
Replicating One Database
Replicating with and Active Binary Log    on the Master
Removing Old Binary Logs from the Master and Then Starting
Avoiding Too Many Updates
Avoiding Key Errors

Configuring and Optimizing MySQL

Optimizing the mysqld Variables
Changing Variable Values with the    Server Running
Imporving Hardware to Speed Up Server
Using Benchmarks
Running MySQL in ANSI Mode
Using Different Languages in MySQL

Database Security

Security When Connecting
Managing Users and Connnections
SSL Connections
Application Security
System Security
Security Issues with LOAD DATA              LOCAL

Installing MySQL

Deciding Whether to Install a Source or Binary Distribution
Installing MySQL on Windows
Installin MySQL on Unix
Installing Multiple MySQL Servers on    the Same Machine
Avoiding Common Installation Problems
Upgrading from MySQL3x to MySQL 4

Multiple Driver

Understanding RAID
Using Symbolic Links