MySQL Training

All students will receive a copy of MySQL Tutorial by Luke Welling & Laura Thomson

Course Outline

• I. Introduction / MySQL Basics
  • Installing MySQL
  • Quick Tour
• II. Designing and Creating Databases with MySQL
  • Database Design Crash Course.
  • Creating Databases, Tables and Indexes.
• III. Using MySQL.
  • Inserting, Deleting, and Updating Data.
  • Querying MySQL.
  • Advanced Queries.
  • Using MySQL Built-in Functions with SELECT.
• IV. MySQL Table Types and Transactions.
  • Understanding MySQL's Table Types.
  • Using Transactions with InnoDB Tables.
• V. Administering MySQL.
  • Managing User Privileges.
  • Configuring MySQL.
  • Administering Your Database.
  • Backup and Disaster Recovery.
  • Securing Your MySQL Installation.
  • Replicating Your Database.
• VI. Optimizing MySQL.
  • Optimizing Your MySQL Server Configuration.
  • Optimizing Your Database.
  • Optimizing Your Queries. Index.

See also:

PHP and MySQL Training Courses

• PHP Training
• MySQL Training