MySQL Bootcamp (5 days)

The MySQL Boot Camp training course provides students with an 11 hour-per-day immersion into MySQL latest version 5.0. The program is an accelerated course that provides experienced developers and administrators with the necessary skills to successfully develop and administer MySQL 5 applications. Students will learn from MySQL-Certified experts through a combination of lab exercises, lectures, and presentations.

This is an intense immersion learning experience - live, breathe, eat, drink, MySQL 5.0 administration and development for one week!

Your registration includes:

• Five days (11-hour immersion) of MySQL-Certified topnotch instruction,
• MySQL Courseware,

What you will Learn

• Describe the MySQL Architecture, general operational characteristics and resources utilized for running it.
• Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
• Utilize MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performance
• Explain the MySQL connectors that provide connectivity for client programs
• Install and Upgrade MySQL 5.0 for the most common operating systems
• Perform the MySQL start and shutdown operations
• Configure MySQL server options at runtime
• Activate and manage numerous server logs
• Maintain integrity of a MySQL installation utilizing security protocols
• Manage user maintenance and access to a MySQL Server
• Manage the structural characteristics of your databases
• Create, Maintain and Manage MySQL tables
• Manage the structural characteristics of the tables within your databases
• Select the best data type for representing information and managing performance in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Perform bulk data import and export operations
• Utilize the SELECT statement to retrieve information from database tables
• Utilize expressions in SQL statements to retrieve more detailed information
• Write join expressions in your SQL statements to obtain information from multiple tables
• Utilize SQL statements to modify the contents of database tables
• Utilize subqueries in your SQL statements
• Understand data locking concepts and the different levels of locking in MySQL
• Perform backup and restore operations utilizing multiple MySQL tools
• Improve performance though query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Create user defined variables, prepared statements and stored routines
• Create and manage triggers
• Use the INFORMATION_SCHEMA database to access metadata
• Manage, apply and understand the reason for using views
• Debug MySQL applications
• Scale-out deployments of MySQL

Who should Attend

• Developers and DBAs

Prerequisites

• Some experience with Relational Databases and SQL.

Format

• Instructor led, with hands-on lab exercises
• Each student will be provided with their own computer
• Each day starts at 7:30am and ends at 7:30pm
• Breakast is served from 7:00am

Applies to MySQL Version:

5.0, 5.1

Duration

5 Days, 7:30am to 7:30pm.

How to Register and Locations

See Upcoming Sessions.

Upcoming Sessions