MySQL Training: Introduction to MySQL Databases Training

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

Amsterdam, The Netherlands / Brussels, Belgium

Oakland / San Jose / San Francisco, California

Sacramento, 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

Boise, Idaho

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

St. Louis, Missouri

Whiteman Air Force Base / Kansas City, Missouri

Lincoln / Omaha, Nebraska

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

Canton / Akron, Ohio

Cincinnati, Ohio

Cleveland & Columbus, Ohio

Dayton, Ohio

Tulsa / Oklahoma City, Oklahoma

Toronto, Ontario

Portland, Oregon

Pittsburgh, Pennsylvania

Providence, Rhode Island

Edinburgh / Glasgow, Scotland

Columbia & Charleston, South Carolina

Stockholm, Sweden

Chattanooga / Knoxville, Tennessee

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: 640
Duration: 3 days
view class outline

MySQL Database Training Overview

Accelebrate’s Introduction to SQL using MySQL training teaches first time query writers how to write SQL queries for retrieving, inserting, updating, and deleting data in MySQL.

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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor’s or students’ travel expenses. To receive a customized proposal and price quote private training at your site or online, 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 Database Training Prerequisites

All attendees should have a high level of comfort using computers. Prior relational database experience is helpful but not required.

Hands-on/Lecture Ratio

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

MySQL Database Training Materials

All attendees receive comprehensive courseware and a copy of Sams Publishing’s MySQL Crash Course.

Software Needed on Each Student PC

MySQL 5.0 or later (class can be adapted for earlier versions upon request)
If you have purchased this course, please contact us for additional setup instructions

MySQL Database Training Objectives

Master relational database fundamentals, as implemented in MySQL.
Discover how to write progressively more advanced SELECT queries for retrieving exactly the data you need from MySQL.
Add, modify, or remove data using INSERT, UPDATE, and DELETE statements.
Learn how to create and use MySQL views and stored procedures

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider our PHP Training: Introduction to PHP and MySQL.

MySQL Database Training Outline

Installing MySQL

Installing MySQL
Operating System Selection
Downloading and Installing MySQL On Windows

Running the MySQL Configuration Wizard

Installing MySQL On Linux and Unix
Installing MySQL On Mac
Verifying a Downloaded File
Verifying a MySQL Installation
Launching the MySQL Server
Installing From Source Files

Setting up MySQL

Versions of the MySQL Server
Mysql Directory Structure
Securing the MySQL Server: Set root Password
Delete Anonymous Accounts
Creating an Account for Basic Use
General Information using MySQL Monitor
Configuring MySQL

MySQL Programs and Executables

MySQL Programs and Executables
Common Options to Various Commands
Specifying Options
Options on the Command Line
: Display options from files
: Explain Error Codes

User Interfaces MySQL

Overview of User Interfaces

MySQL Help - Information Browser

Establishing a Connection

Object Browser

MySQL Query Browser

The Script Editor

MySQL Administrator
MySQL Migration Toolkit
phpMyAdmin

MySQL Monitor

Using MySQL Monitor (SQL Command Interpreter)
Some Useful Options
Formatting and Output Options
Commands for Interactive Mode
Executing a Script from the Monitor
Using the mysql Command to run a Script
See Database Status

Designing Databases

Relational Database Concepts

Physical Model: Mapping The ER Model To A Relational Database

Database Design Principles

First Normal Form

Film Rentals - sakila

Warning: Abnormal Normal Form!

Basic Modeling Process: Creating a Data Model

Second Normal Form

Database Normalization

Third Normal From

Creating Databases and Components

Creating Databases

Deferred Checking

Creating Tables

Defining Default Values

Confirm a Table is temporary
Creating Column Definitions

Defining Indexes when Creating Tables

Data Types in MySQL

Statement

Timestamp Data Type
Constraints

Full-Text Indexes

Creating Tables
Altering Tables
Managing Indexes

Deleting Indexes

Creating and Indexing Tables

Identifiers in MySQL

Identifiers in MySQL

Identifier Names

Schema Object Names

Using Double Quotes

Some Restrictions
Identifier Qualifiers
Mapping of Identifiers to Filenames

Setting

Identifier Case Sensitivity

Avoiding Data Transfer Problems

Show Database Information

SHOW and DESCRIBE Statements

Using DESCRIBE Statement

INFORMATION_SCHEMA Tables

Showing Databases

Basic Select Statements

Basic SQL Syntax Rules
SELECT Basics
Introduction to the sakila Database
Basic Select Examples
SELECTing Specific Columns
The WHERE Clause and Basic Operator Symbols
Exercise: Using the WHERE clause to check for equality or inequality
Exercise: Checking for NULL
WHERE and ORDER BY
Exercise: Using WHERE and ORDER BY Together
Using Aliases
Selecting Distinct Records
Sorting Records
Exercise: Sorting Results
The LIMIT Clause

Processing the First N or Last N Records

Using Expressions in MySQL Statements

MySQL Expressions

The IN Operator

Operators in MySQL

The LIKE Operator

Concatenation

The REGEXP Operator

Arithmetic Operators

Use of BINARY with Strings

Operator Precedence

The NOT Operator

Comparison Operators

Order of Evaluation

The WHERE Clause and Operator Words

Summary

Exercise: More SELECTs with WHERE
Using CASE

Exercise :Using Control Flow Functions in a SELECT Statement

Exercise: Working with CASE
Logical Operators

Data Conversion Functions

Exercise: Writing SELECTs with Multiple Conditions
Using MySQL Functions

Numeric Functions

Functions to Compare Data

Current Date/Time

Control Flow Functions

Date Addition/Subtraction Functions

String Functions

Date Extraction Methods

Exercise: Using String functions to find first word.
Date/Time Functions

Date Formatting Methods

Exercise: Working with Dates and Strings
Exercise: Working with Case and Dates

Inserting, Updating and Deleting Records in MySQL

Inserting Data in a MySQL Database

<set option> Alternative of INSERT

Exercise: Inserting Records
Using REPLACE Statement to Add Data

ORDER BY and LIMIT Clauses in UPDATE

Exercise: Replacing Records in sakila
INSERT with ON DUPLICATE KEY UPDATE Syntax

Some Advanced MySQL modifiers to DELETE statement

Exercise: Replacing Records in sakila
Updating Data in MySQL

ORDER BY and LIMIT in DELETE Statement

Using DELETE Statement in MySQL

Updating Multiple Tables using Joins

Exercise: Delete reservations
Exercise: Delete reservations
Using TRUNCATE Statement to Delete Data

<FROM JOIN DELETE> Alternative

Joining Tables in an UPDATE Statement

<using join delete> Clause

Exercise: using UPDATE Statements to Modify Data in multiple Joined Tables
Joining Tables in a DELETE Statement

Deleting from multiple tables

Exporting and Importing Data in MySQL

EXPORTING: Data Out of a Table
Use Field and Line Separators
Dump a Row to a File
: Creating a New Table Using a ResultSet
Copying Data into an Existing Table

General Loading Rules

Using the LOAD DATA to Import Data

More Loading Examples

Exporting and Importing Data
Using the mysqlimport Utility to Import Data

Using Separators with mysqlimport Utility

Importing Data via mysqlimport

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