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 *Dojo Training *Ruby on Rails Training * Groovy Training * Grails Training
HTML, XHTML, & JavaScript Training * Authorware Training * Articulate Training * Live Online Training


 * MySQL Training: Introduction to MySQL Databases
 * MySQL Training: MySQL Development
 * MySQL Training: MySQL Administration
 * MySQL Training: Introduction to MySQL Development and Administration
 * MySQL Training: MySQL Database Design
 * MySQL Training: MySQL Optimization
 * MySQL Training: Introduction to SQL Using MySQL

 * PHP Training: Introduction to PHP and MySQL
 * PHP Training: Advanced PHP
 * Building Data-Driven PHP/MySQL Web Sites with Dreamweaver



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
  • 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
  • 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

 

MySQL Training: MySQL Database Design Training

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 645
Duration: 2 days
view class outline

MySQL Database Design Training Overview

Accelebrate's MySQL Database Design training targets new and existing users of MySQL who have some experience with relational database management systems. This MySQL training covers database design theory and several essential elements of the MySQL database in general.

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 Database Design Training Prerequisites

All attendees should have prior relational database experience and comfort working at a command line.

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 Design Training Materials

All attendees receive comprehensive, illustrated courseware and a related textbook.

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 Design Training Objectives

  • Install and configure MySQL.
  • Learn database design fundamentals.
  • Understand efficient database design.
  • Learn application analysis and E-R modeling.
  • Learn normalization principles.
  • Use the INFORMATION_SCHEMA database to access metadata.
  • Understand table types and storage engines.

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 Design Training Outline

  • Installing MySQL
    • Installing MySQL
    • Operating System Selection
    • Downloading and Installing MySQL On Windows
      • Running the MySQL Configuration Wizard
      • Starting and stopping the MySQL server
    • Installing MySQL On Linux and Unix
      • Using RPM (Linux only)
      • MySQL Packaged RPMs
      • Using a Tar File to Install MySQL
      • Starting the Server Automatically
    • Installing MySQL On Mac
    • Verifying a Downloaded File
    • Verifying a MySQL Installation
      • mysqladmin: Obtain Server Status
    • Launching the MySQL Server
    • Installing From Source Files
  • Setting up MySQL
    • Versions of the MySQL Server
      • The mysqld_safe Wrapper
    • 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
  • Designing Databases
    • Relational Database Concepts
      • Brief History of SQL
      • Relational Database Management System
      • Popular Databases
      • Tables
      • Rows
      • Columns
      • Relationships
      • Datatypes
      • Primary Keys
      • Foreign Keys
      • Valid Object References
      • SQL Statements
    • Database Design Principles
    • Film Rentals - sakila
    • Basic Modeling Process: Creating a Data Model
      • Logical versus Physical Model
      • The Entity-Relationship Model
      • Entities And Entity Sets
      • Attributes
      • Relationships
      • Relationship Types
      • Graphical Representation of a Model
      • Physical Model: Mapping The ER Model To A Relational Database
    • Database Normalization
      • First Normal Form
      • Warning: Abnormal Normal Form!
      • Second Normal Form
      • Third Normal From
  • Creating Databases and Components
    • Creating Databases
      • Deleting Databases
    • Creating Tables
      • Dropping Tables
      • Defining Table Types
      • Altering Existing Table Structures
      • Add a column
      • Renaming Tables
      • Temporary Tables
    • Creating Column Definitions
    • Data Types in MySQL
      • Numeric Data Types
      • String Data Types
      • Character Set Fundamentals
      • Set Types
      • Date/Time Data Types
      • Options and Attributes
    • Constraints
      • NOT NULL Constraint: Defining a Column's Nullability
      • UNIQUE Constraint
      • PRIMARY KEY Constraint: Defining a Master Key
      • Defining Auto-Increment Columns
      • Referential Integrity Constraints: Defining Foreign Keys
      • Constraint Checking on a Transaction
      • Deferred Checking
      • Defining Default Values
    • Managing Indexes
      • Defining Indexes when Creating Tables
      • CREATE INDEX Statement
      • Full-Text Indexes
      • Deleting Indexes
  • Identifiers in MySQL
    • Identifiers in MySQL
      • Identifier Names
    • Schema Object Names
      • Using Double Quotes
      • Using Quote Within Names
      • Using Digits
    • Some Restrictions
    • Identifier Qualifiers
    • Mapping of Identifiers to Filenames
    • Identifier Case Sensitivity
      • lower_case_table_names Setting
      • Avoiding Data Transfer Problems
  • Show Database Information
    • SHOW and DESCRIBE Statements
      • Using Table-Related SHOW Statements
      • Using DESCRIBE Statement
    • INFORMATION_SCHEMA Tables
      • Showing Databases
  • MySQL Table Types
    • MySQL Table Types (Storage Engines)
    • Setting/Changing Engine
    • MyISAM Tables
      • Full-Text Search on MyISAM Tables
      • Creating a Full-Text Index
      • Using Full-Text Search
    • InnoDB Tables
      • InnoDB - Limitations and Drawbacks
      • InnoDB Disk Management
      • Preventing Problems
      • Moving Files
    • FOREIGN KEY Constraints in InnoDB
      • Checking Foreign Keys
    • Choosing - MyISAM or InnoDB?
    • HEAP or MEMORY Tables
    • Temporary Tables
    • MERGE Tables
    • Other Table Types
      • ARCHIVE or Compressed Tables (since MySQL 4.1)
      • CSV Type Tables(since MySQL 4.1)
      • NDB or Cluster Tables (since MySQL 4.1)
      • FEDERATED or External Tables (since MySQL 5.0)
      • BDB Tables
    • Table Files Storage
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

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- 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 | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | 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 | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, 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 Database and Reporting Training