Introduction to MySQL 5.5

Course details

This one–day seminar covers all the new features and other key enhancements to MySQL 5.5 and the MySQL
Enterprise Edition. This includes performance, scalability, availability and backups.

What do you learn from this course?

• Plan your use of the MySQL 5.5 product release more effectively.
• Recognize new MySQL 5.5 features.
• Understand Replication features and functionality.
• Recognize how to support full, incremental and partial backups with compression,as well as point-in-time recovery.
• Distinguish how MySQL Workbench provides GUI-based data modeling, SQL development, deployment and
• comprehensive administrative tools.

Course Overview:
Introduction

• Features and Benefits of MySQL 
• MySQL Products and Service 
• MySQL Community Edition vs. MySQL Enterprise Edition
• MySQL Certification Program 
• MySQL Website 
• MySQL Architecture 
• How do I upgrade to MySQL 5.5

Whats New in MySQL 5.5

• Introducing InnoDB as MySQL’s Default Storage Engine 
• Performance and Scalability and Benchmarks
• Improved Availability
• Improved Manageability and Efficiency
• Improved Usability
• Improved Instrumentation and Diagnostics

MySQL Production Ready Software and Support

• MySQL Administration
• Enterprise Monitor and Query Analizer
• MySQL Workbench (server configuration, user administration, object management)
• MySQL 5.5 Replication Enhancements
• Overview of MySQL Replication

MySQL 5.5 Replication Features

• Users Wants and Needs
• Replication Enhancements in MySQL 5.5
• What’s Cooking in the Replication Labs
• Getting Started with MySQL 5.5 Replication

MySQL Enterprise Backup

• Database Backup Overview
• MySQL Enterprise Backup Features and Benefits
• Database Backup Types: Comparison
• MySQL Enterprise Backup: how it Works