MySQL Bootcamp

Sun Microsystems K.K.
Tokyo, Japan

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 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!

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 ...''

Elements of this syllabus are subject to change.

Phone:81-3-5843-1140

School Address/Venue(s):

4-11, Jingumae 2-chom, Shibuya-ku,
Tokyo 150-0001, Japan

Jobs & Resumes: Tokyo
Houses & Roommates: Tokyo
Travel Agencies: Tokyo

Search other schools for MySQL Bootcamp training resources.

Managing MySQL
MySQL for Beginners
MySQL for DBAs
MySQL Performance Tuning
MySQL High Availability
MySQL Cluster
MySQL Developer Techniques
MySQL Advanced Stored Procedures
MySQL 5.0
MySQL for Developers
MySQL and PHP
Using MySQL
MySQL 5.0 In Depth
Advanced MySQL Cluster
NDB API

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.