MySQL 5.0 (Certificate)

Sun Microsystems K.K.
Tokyo, Japan

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

Course Description:

'' Then MySQL 5.0: Upgrading and New Features is the class for you! This course is designed for Developers and Database Administrators who wish to migrate to MySQL 5.0. This course will prepare each student with the skills needed to utilize Stored Procedures, Triggers, Views, and the INFORMATION_SCHEMA metadata to enhance their productivity. Students will be exposed to the new storage engines, the ANSI SQL features and commands, the new status and configuration variables, the new precise math features and commands, and the new indexing and optimization features. In addition, this course will explain the MySQL recommended migration strategy.

At the completion of this course, you should be able to:
Create database procedures and functions (including cursors), triggers and views
Describe the new status and configuration variables
Write SQL to retrieve information from the INFORMATION_SCHEMA database
Understand how MySQL 5.0 performs more precise calculations independent of the operating system and gives greater control over handling and invalid values
Describe the new storage engines available and improvement on pre-5.0 storage engines
Explain the new “greedy�optimizer and index merge method
Describe the SQL features and commands that are now available in MySQL 5.0
Describe the MySQL recommended migration strategy
Certification:
If you are MySQL 4 Core (or Professional) certified then this course combined with sufficient practical experience, prepares you for the MySQL 5.0 Developer (or MySQL 5.0 DBA) Upgrade Certification Exam ...''

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 5.0 training resources.

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

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: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.