MYSQL & PHP training classes     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
XML training * MySQL & PHP Training * Tomcat Training * Perl Training * Ajax Training
Ruby on Rails Training * Groovy Training * Grails Training * HTML, XHTML, & JavaScript Training
Web Architecture Training * Authorware Training * Live Online Training


 * PHP Training: Introduction to PHP and MySQL
 * Building Data-Driven PHP/MySQL Web Sites with Dreamweaver training
 * MySQL Training: Fundamentals of Querying and Administering MySQL



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary MySQL or PHP Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour MySQL or PHP training seminar delivered for their developers. Contact us today for more information.



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

 

MySQL Training: Fundamentals of Querying and Administering MySQL

Print This Outline
E-mail This Outline
Get A Quote
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
 

Print This OutlineE-mail This OutlineGet A Quote

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



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.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | San Diego, CA | San Francisco, CA | Denver, CO | Washington, DC | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Oklahoma City, OK | Toronto, ON | Philadelphia, PA | Pittsburgh, PA | Portland, OR | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Open Source & Apache Training