MySQL User Conference
 Co-presented by O'Reilly Media, Inc. and MySQL AB
 Sign Up for the Newsletter for up to date conference news.

Tutorial

Certify MySQL 4 Professional
Harrison Fisk

Track: General
Date: Monday, April 18
Time: 1:30pm - 5:00pm
Location: Ballroom F

TrackBackTrackBack

This tutorial covers the topics and concepts necessary to successfully pass the MySQL 4 Professional certification exam, an increasingly important requirement for MySQL related jobs. And even if you're not looking to pass the exam, this tutorial is a great way to brush up on your DBA fundamentals.

You will receive a free study guide and certification exam as part of this tutorial ($250 value).

Topics will range from basic to advanced in order to allow the greatest chance of passing the certification exam. Example topics include:

  1. MySQL Architecture
    • How MySQL uses memory/threads/disk space
  2. MySQL Installation and Configuration
    • Installing/Startup/Shutdown MySQL on Windows and Unix
    • Compiling MySQL
  3. Security Issues
    • Securing an initial MySQL Installation
    • User account management
  4. Optimizing for Query Speed
    • Index optimization and index usage
    • Using EXPLAIN to analyze queries
  5. MyISAM and InnoDB Tables overview
    • Locking
    • Backup and recovery
  6. Advanced Server Features
    • Tuning memory parameters
    • Replication

Also included will be example questions and test taking techniques, which will increase the chances of successfully passing the exam.



Diamond Sponsor

Hewlett Packard

Platinum Sponsors

Business Objects
Emic
Four J's Development Tools, Inc
Genesi
Intel Corporation

Gold Sponsors

GoldenGate Software, Inc.
IBM
Ticketmaster

Silver Sponsors

Dell Inc.
Embarcadero Technologies
JasperReports
MetiLinx, Inc.
Novell, Inc.
OLAP4All
Quest Software
Rackspace Managed Hosting
SpikeSource
SugarCRM
Zend Technologies, Inc.

Media Sponsors

ActiveWireless
C/C++ Users Journal
DevtownStation News
Digital ID World
Integration Developer News
Linux Journal
Open Enterprise Trends
Queue
SDForum
Wi-Fi Technology Forum

MySQL User Conference Sponsor Opportunities — Reach business leaders and technology influencers at the MySQL User Conference. Download Exhibitor and Sponsor Prospectus. Call Andrew Calvo at 707-829-0515 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Media Center — Press releases, news, and information for the press.

Conference News

Want to receive conference news? Sign up for our email newsletter.
Copyright MySQL AB and O'Reilly Media, Inc.
MySQL O'Reilly