| Getting started |
| |
Overview of MySQL
Installation
Directories and files installed
The relational model
Normalisation
SQL overview |
|
| MySQL and SQL essentials |
| |
Column type
overview
Numeric column type
String column type
Date and time
The MySQL Client program
Creating tables
Retrieving Data from tables
SQL SELECT FROM
SQL WHERE
SQL LIKE, AND and OR
Numerical operators
String operators
Wildcards
Introduction to MySQL Functions
|
|
| Database manipulation |
| |
Creating advanced
queries
SQL HAVING
SQL GROUP BY
Working with multiple tables
Types of join
SQL INSERT
SQL REPLACE
SQL UPDATE
SQL DELETE
Importing data
Working with indexes
|
|
| Using functions |
| |
Overview of functions
Overview of operators
Conditional functions
String functions
Date and time functions
|
|
| Administration |
| |
Overview of admin
tasks
The mysqladmin utility
Repairing databases
The myisamchk utility
The myisampack utility
The mysqlhotcopy utility
The mysqlshow utility
Optimisation
Backup and Restore
Setting variables
Using MySQL with PHP |
|
| Security |
| |
Securing the database server
User privilege overview
Granting privileges
Revoking privileges
Making secure connections
|
|