MySQL Introduction (2 days)

This course is designed for experienced web developers looking to use MySQL in conjunction with server application software such as PHP.

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