MySQL Bootcamp :: MySQL-BOOTCAMP

start > courses and registration > training feature sheet

code.

MySQL-BOOTCAMP

length.

5 days

type.

Instructor-Led

partner.

MySQL

price.

$4,999

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!

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

Developers and DBAs

prerequisites

Some experience with Relational Databases and SQL.

skills gained

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

your registration includes:

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

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

course content details

	Course Topics

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!