The Computer Spares Emporium

MySQL Self-Study Training InfoCentre



With BONUS full MySQL Reference Guide.

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL is a registered trademark of MySQL AB.

This product is the complete training program for working with MySQL on both Windows and Linux computers! It teaches you novice to advanced techniques covering the essential techniques for creating and managing data. The course has been designed to build essential skills quickly and effectively using examples and exercises. The lessons have been divided into small, manageable and practical chunks. The software features a strong Search system and allows you to Bookmark your favourite topics for future reference. With the additional official MySQL Reference Documentation, this CD has everything you need as a MySQL database administrator whether you're a beginner or an expert.

What you get (Course Outline)

Getting Started

Installation and Configuration of MySQL
MySQL Overview

Creating Data

Creating a Database
Creating a Table

Editing Data

Updating Records

Deleting Data

Deleting entries from tables
Dropping Tables

Using Data

Using a Database
Querying Data
More Queries
Pattern Matching with text data
Logical Operators

Managing Data

Ordering Data
Limiting Data Retrieval
The DISTINCT Keyword
Finding the minimum and maximum values
Finding the Average and Sum
Naming Columns
HAVING clause
A little more on the MySQL SELECT statement

Column Types

MySQL database Column Types
Focusing on the Date column type
Null column type

Advanced Data Manipulation
Mathematical Functions
Table Joins

Included on this CD is the full official MySQL Reference Guide Documentation