UNIX My SQL DBA

MySQL Course Contents

Introduction to MySQL
Relational Databases
MySQL Design
MySQL Features
MySQL Applications
MySQL Datatype

MySQL Server Installation
Windows Installation
Unix Installation
Starting and Stopping Services

SQL Languages
Create Statement
Insert Statement
Select Statement
Update Statement
Alter Statement
Delete Statement
Show Statement
Joins
Views, and user-defined functions

Creating and Managing Database
Creating Database
Managing Database
Server Startup and Shutdown
Creating Database Users
Managing Database Users

Backup, Recovery and Maintenance
Backup
Database dump
Recovery
Dump Recovery
Hotcopy Recovery
Table Maintenance
Repairing Table
Tuning