Introduction to MySQL 5.5 Ed 1

Požadované predpokladané znalosti

• Basic computer literacy is required

Doporučené predpokladané znalosti

• Previous experience with any command-line program
• Knowledge of database concepts

Ciele kurzu

• 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

Témy kurzu

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