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.
Skills Gained
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
Who Can Benefit
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
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
Format
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
Code:
MySQL5-NF
Length:
3 days
Type:
Instructor-Led
Certified By:
MySQL
Tuition:
$1,499
This course is taught by Certified MySQL instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Course Topics
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.
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
