Introduction to MySQL 5.5

Course Description

This one–day seminar covers all the new features and other key enhancements to MySQL 5.5 and the MySQL Enterprise Edition, including Performance, Scalability, Availability and Backups. Instructor lecture is supported by live demos as necessary. By attending this course, you learn how to plan your use of the MySQL 5.5 product release more effectively. Students who can benefit from this course: New users of MySQL, who have little or no previous experience with a relational database management system.Existing MySQL users who are interested in learning about the new functionality possible with the MySQL 5.5 ReleaseLearn to:Plan your use of the mySQL 5.5 product release more effectivelyA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

• Understand the features and benefits of MySQL
• Recognize new MySQL 5.5 features
• Understand how MySQL Enterprise Monitor and MySQL Query Analyzer alerts DBA to potential problems, queries and tuning opportunities before they impact key systems or applications
• Understand how MySQL Enterprise Monitor and MySQL Query Analyzer works with MySQL databases
• Distinguish how MySQL Workbench provides GUI-based data modeling, SQL development, deployment, and comprehensive administrative tools
• Understand Replication features and functionality
• Recognize how to supports full, incremental and partial backups with compression as well as point-in-time recovery

Who Can Benefit

• Database Administrators
• Database Designers

Prerequisites

• Basic computer literacy is required
• Previous experience with any command-line program
• Knowledge of database concepts

Syllabus

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