KT-30915 MySQL for Database Administrators Ed 3.1 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


MySQL for Database Administrators Ed 3.1


Description: 

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.6 to improve performance, scalability, reliability and manageability for your Web, Cloud and embedded application requirements.

Audience:

  • Database Administrators
  • Developer

Course 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

 
Click here to view the Course Outline
     
Prerequisite: 
  • Have some experience with relational databases and SQL
 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 

Course Schedule
  Start Date  City  Price  
 6/19/2017
 $2450
 7/31/2017
 $2450
 9/11/2017
 $2450

To Inquire About Future Classes

Request a class date

if one is not scheduled.