MySQL Training: Fundamentals of Querying and Administering MySQL

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama

Montgomery / Birmingham, Alabama

Anchorage, Alaska

Calgary, Alberta

Phoenix, Arizona

Fayetteville / Little Rock, Arkansas

Oakland / San Jose / San Francisco, California

Oceanside / San Diego, California

Pasadena / Orange County / Los Angeles, California

San Bernardino / Riverside, California

Boulder / Colorado Springs / Denver, Colorado

Washington, DC

Wilmington, Delaware

Manchester / London, England

DeLand / Orlando, Florida

Fort Lauderdale / Miami, Florida

Gainesville / Jacksonville, Florida

Saint Petersburg / Tampa, Florida

Titusville & Melbourne, Florida

Alpharetta & Atlanta, Georgia

Augusta & Savannah, Georgia

Macon & Columbus, Georgia

Bloomington, Illinois

Chicago, Illinois

Indianapolis, Indiana

Cedar Rapids / Des Moines, Iowa

Dublin, Ireland

Kingston, Jamaica

Wichita, Kansas

Paducah / Lexington / Louisville, Kentucky

Baton Rouge, Louisiana

Valletta, Malta

Hagerstown & Frederick, Maryland

Greenbelt / Silver Spring / Baltimore, Maryland

Boston / Cambridge, Massachusetts

Hartford, Connecticut / Springfield, Massachusetts

Taunton, Massachusetts / Providence, Rhode Island

Ann Arbor / Farmington Hills / Detroit, Michigan

Grand Rapids, Michigan

Lansing, Michigan

Saginaw / Flint / Bay City / Midland, Michigan

Saint Paul / Minneapolis, Minnesota

Jackson, Mississippi

Gulfport / Biloxi, Mississippi

Whiteman Air Force Base / Kansas City, Missouri

Reno and Las Vegas, Nevada

Santa Fe / Albuquerque, New Mexico

Newark, New Jersey

Princeton, New Jersey & Philadelphia, Pennsylvania

White Plains / New York City, New York

Charlotte, North Carolina

Durham / Raleigh, North Carolina

Bowling Green / Toledo, Ohio

Cincinnati, Ohio

Cleveland & Columbus, Ohio

Tulsa / Oklahoma City, Oklahoma

Toronto, Ontario

Portland, Oregon

Pittsburgh, Pennsylvania

Providence, Rhode Island

Edinburgh / Glasgow, Scotland

Columbia & Charleston, South Carolina

Memphis / Jackson / Nashville, Tennessee

College Station and Houston, Texas

El Paso, Texas / Ciudad Juarez, Mexico

San Antonio / Austin, Texas

Wichita Falls & Dallas, Texas

Ogden / Salt Lake City, Utah

Burlington, Vermont

Fairfax / Dulles / McLean / Herndon / Reston, Virginia

Richmond / Alexandria / Arlington, Virginia

Virginia Beach / Norfolk, Virginia

Tacoma / Seattle, Washington

Madison / Milwaukee, Wisconsin

Course Number: 620
Duration: 3 days
view class outline

MySQL Training Overview

MySQL is the world's most popular open source client-server database. In this three-day, hands-on course, attendees learn the fundamentals of writing MySQL queries and of administering the MySQL database.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/xml_html_js.htm.

MySQL Training Prerequisites

This course can be customized to any level of experience. The last section, Integrating Applications with MySQL, presumes that attendees already know the language in question and merely need to learn how to use the language to automate MySQL.

Hands-on/Lecture Ratio

This MySQL training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

MySQL Training Materials

All MySQL training students receive:

Comprehensive courseware
MySQL Press's MySQL Tutorial
O'Reilly & Associates' MySQL Cookbook

Software Needed on Each Student PC

MySQL 4.1 or any later production release—this can either be running on all PCs, or on one server within a networked classroom. MySQL 5.0 or later is strongly recommended
MySQL Control Center (a graphical interface for administering MySQL and data) or another front-end, if desired.
Any operating system supported by MySQL. A complete list of operating systems supported by the MySQL version you're interested in can be obtained by going to http://www.mysql.com/downloads/.

MySQL Training Objectives

To learn how to properly set up and configure MySQL
To master creating and querying databases in MySQL
To learn how to administer and secure a MySQL database
To discover how to write applications that integrate with MySQL databases

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider Building Data-Driven Web Sites with PHP & MySQL.

MySQL Training Outline

MySQL Basics

Installing MySQL

Installing on Linux
Configuring Your System
Checking Your System Works
Setting the Root Password
Deleting Anonymous Accounts
Creating an Account for Basic Use
Quick Tour

MySQL Directory Structure
Overview of Executables
Overview of User Interfaces
Quick Introduction to the MySQL Monitor

Designing and Creating Databases with MySQL

Database Design Crash Course

Database Concepts and Terminology
Database Design Principles
Normalization

Creating Databases, Tables, and Indexes

Case Sensitivity
Identifiers in MySQL
Creating a Database
Selecting a Database
Creating Tables
Column and Data Types in MySQL
Creating Indexes
Deleting Databases, Tables, and Indexes
Altering Existing Table Structures

Writing SQL Queries

Simple SELECTs

Introduction to the Northwind Database
Some Basics
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records
The WHERE Clause and Operator Symbols
The WHERE Clause and Operator Words
Checking Multiple Conditions

Advanced SELECTs

Calculated Fields
Aggregate Functions and Grouping
Built-in Data Manipulation Functions

Subqueries, Joins, and Unions

Subqueries
Joins
Unions

Inserting, Updating and Deleting Records

Using INSERT
Using UPDATE
Using DELETE

Using MySQL Built-In Functions with SELECT

Operators
Control Flow Functions
String Functions
Numeric Functions
Date and Time Functions
Cast Functions
Other Functions
Functions for Use with GROUP BY Clauses

MySQL Table Types and Transactions

Understanding MySQL's Table Types

ISAM Tables
MyISAM Tables
InnoDB Tables
BerkeleyDB (BDB) Tables
MERGE Tables
HEAP Tables

Using Transactions with InnoDB Tables

What Are Transactions? Using Transactions in MySQL
The InnoDB Transaction Model

Administering MySQL

Managing User Privileges

Creating User Accounts with GRANT and REVOKE
Privilege Levels
Evaluating Privileges
Using the REVOKE Statement
Understanding the Privilege Tables

Configuring MySQL

Setting MySQL Configuration Options
Setting InnoDB Configuration Options
Multi-Install Configuration Options
Configuring for Internationalization

Administering Your Database

Starting Up and Shutting Down the MySQL Server
Getting Information about the Server and Databases
Setting Variables
Killing Threads
Clearing Caches
Understanding the Log Files
mysqladmin Option

Backup and Disaster Recovery

Backing Up and Restoring Your Database
Testing Your Backup
Checking and Repairing Tables

Securing Your MySQL Installation

How the Privilege System Works in Practice
Securing Accounts
Securing Your Installation Files
Filtering User Data
Other Tips

Replicating Your Database

Replication Principles
Setting Up and Configuring for Replication
Advanced Topologies
The Future of MySQL Replication

Optimizing MySQL

Optimizing Your MySQL Server Configuration

Compiling and Linking for Speed
Tuning Server Parameters
Tuning Other Factors

Optimizing Your Database

What's Slow in MySQL Databases? Making the Right Design Choices
Indexing for Optimization
ANALYZE TABLE
Using OPTIMIZE TABLE

Optimizing Your Queries

Finding Slow Queries
Benchmarking Your Queries
Using the Slow Query Log
Using EXPLAIN to See How Queries Are Executed
Understanding MySQL's Built-In Query Optimization
Optimization Tips

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
Adobe Training

PHP Training

XML Training

Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003-2006 by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Complimentary MySQL or PHP Training Seminar