Oracle/MySQL for Database Administrators Ed 3.1

MySQL for Database Administrators Ed 3.1 Certification Training Course Overview

Enroll for the 5-days MySQL for Database Administrators Ed 3.1 course from Koenig Solutions accredited by Oracle. The MySQL for Database Administrators training is designed for DBAs and other database professionals. Expert Oracle University instructors will teach you how to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases.

Learn To:

  • Describe the MySQL Architecture.
  • Install and upgrade MySQL.
  • Configure MySQL server options at runtime.
  • Evaluate data types and character sets for performance issues.
  • Understand the use of the InnoDB storage engine with MySQL.
  • Perform backup and restore operations.

Benefits to You:

After taking this course, you'll have a greater understanding of new enhancements made available in MySQL 5.5.8 to improve performance, scalability, reliability and manageability for your Web, Cloud and embedded application requirements.

Target Audience:

  • Database Administrators
  • Developer

 

MySQL for Database Administrators Ed 3.1 (40 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training
02 - 06 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Topic details are not available.
Module 2: MySQL Architecture
  • Topic details are not available.
Module 3: System Administration
  • Topic details are not available.
Module 4: Server Configuration
  • Topic details are not available.
Module 5: Clients and Tools
  • Topic details are not available.
Module 6: Data Types
  • Topic details are not available.
Module 7: Obtaining Metadata
  • Topic details are not available.
Module 8: Transactions and Locking
  • Topic details are not available.
Module 9: Storage Engines
  • Topic details are not available.
Module 10: Partitioning
  • Topic details are not available.
Module 11: User Management
  • Topic details are not available.
Module 12: Security
  • Topic details are not available.
Module 13: Table Maintenance
  • Topic details are not available.
Module 14: Exporting and Importing Data
  • Topic details are not available.
Module 15: Programming Inside MySQL
  • Topic details are not available.
Module 16: MySQL Backup and Recovery
  • Topic details are not available.
Module 17: Replication
  • Topic details are not available.
Module 18: Introduction to Performance Tuning
  • Topic details are not available.
Module 19: Conclusion
  • Topic details are not available.
Download Course Contents

Request More Information

Course Prerequisites

Have some experience with relational databases and SQL.

Objectives:

  • Describe the MySQL Architecture
  • Install and Upgrade MySQL
  • Use the INFORMATION_SCHEMA database to access metadata
  • Perform the MySQL start and shutdown operations
  • Configure MySQL server options at runtime
  • Use available tools including MySQL Workbench
  • Evaluate data types and character sets for performance issues
  • Understand data locking in MySQL
  • Understand the use of the InnoDB storage engine with MySQL
  • Maintain integrity of a MySQL installation
  • Use triggers for administration tasks
  • Use Enterprise Audit and Pluggable Authentication
  • Configure advanced replication topologies for high availability
  • Describe introductory performance tuning techniques
  • Perform backup and restore operations
  • Automate administrative tasks with scheduled events