Introduction To MySQL

This course is aimed at delegates who wish to get started with MySQL. It covers the installation and basic administration tasks such as backing up as well as an introduction to SQL for MySQL.

3 Days

Printable Version

Syllabus

MySQL

Relational Databases

The History of MySQL

MySQL Design

MySQL Features

MySQL Applications

What You Get

Installation

Preparation

Unix Installation or Windows Installation

SQL According to MySQL

SQL Basics

Database Creation

Table Management

MySQL Data Types

Indexing

Managing Data

Queries

SQL Operators

Advanced Features

Database Administration

Configuration

Server Startup and Shutdown

Logging

Backup

Recovery

Table Maintenance and Crash Recovery

How to Use What You’ve Learnt

If you would like to have a course customised for your organisation, please contact us.