Skip navigation links

Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 653 0071
Germany: +49 89 420 95 98 95
France: +33 1 70 38 72 00
Sweden: +46 730 234 111
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 653 0071

Asia Pacific: +81 3 5918 7507

Contact Us Online »

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

MySQL 5.0: Upgrading and New Features (3 days)

FAQ

  • Do you need to migrate your existing data driven applications to MySQL 5.0
  • Do you want to design and implement stored procedures and functions to improve productivity and provide additional security in your existing and future data driven applications?
  • Do you want to design and implement views to improve end-user productivity, server optimization and ensure sensitive information is not compromised?
  • Do you want to design and implement triggers to enforce complex business rules and ensure data integrity in your existing and future data driven applications?

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
Who should Attend
  • Experienced Developers and Database Administrators who are upgrading from previous versions of MySQL to MySQL 5.0.
Prerequisites

Students who wish to attend this course, should have attended the Using MySQL 4.1 or Managing MySQL 4.1 courses or be able to perform the following task:

  • Can state general facts about the MySQL privilege system
  • Can view data in databases by using the MySQL SELECT Queries
  • Can use MySQL functions in SELECT Queries
  • Can create tables and explain column types in earlier versions of MySQL
  • Can use JOINs in earlier versions of MySQL SELECT Queries
Format
  • Instructor led, with extensive hands-on lab exercises
  • Each student will be provided with their own computer
Applies to MySQL Version:
5.0
Duration
3 Days.
How to Register
See Upcoming Sessions.

Upcoming Sessions