MySQL InfoCentre
![[Product Image]](http://www.myrnham.co.uk/p4a/applications/myrnham/uploads/mysql.jpg)
Contains BONUS full MySQL Reference Guide.
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 Creating Data Editing Data Deleting Data Using Data Managing Data Column Types Advanced Data Manipulation Exercise Answers Included on this CD is the full official MySQL Reference Guide Documentation Table of Contents
Installation and Configuration of MySQL
MySQL Overview
Creating a Database
Creating a Table
Updating Records
Deleting entries from tables
Dropping Tables
Using a Database
Querying Data
More Queries
Pattern Matching with text data
Logical Operators
IN and BETWEEN
Ordering Data
Limiting Data Retrieval
The DISTINCT Keyword
Finding the minimum and maximum values
Finding the Average and Sum
Naming Columns
Counting
HAVING clause
A little more on the MySQL SELECT statement
MySQL database Column Types
Focusing on the Date column type
Null column type
Mathematical Functions
Table Joins
Preface
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Backup and Recovery
Optimization
Language Structure
Internationalization and Localization
Data Types
Functions and Operators
SQL Statement Syntax
Storage Engines
High Availability and Scalability
MySQL and Virtualization
MySQL Load Balancer
Replication
MySQL Cluster
Partitioning
Spatial Extensions
Stored Procedures and Functions
Triggers
Event Scheduler
Views
INFORMATION_SCHEMA Tables
Precision Math
APIs and Libraries
Connectors
MySQL Proxy
Extending MySQL