MySQL Database Developer & Administrator

Program Code: MySDB-14-201

In this 12 - 14 month program, you will 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, secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new 5.0 features such as creating and using Stored Procedures, Triggers, and Views.

 

Target Audience

Anyone who wants to be an MySQL Database Administrator

Prerequisites

None

List of Some Lesson Objectives

  • MySQL Architecture
  • Install and Upgrade MySQL
  • Starting, Stopping, and Configuring MySQL
  • Client Programs for DBA Work
  • Character Set Support
  • Data Locking
  • Storage Engines
  • Use available tools
  • Data (Table) Maintenance
  • Data Backup and Recovery Methods
  • Stored Routines
  • User Management
  • Securing the Server
  • Automate administrative tasks with scheduled events
  • Hands-on Labs

Location

Online-Classroom

Program Code:

MySDB-14-201

Schedule and Registration

To view and register for a schedule, click "View Schedule" button shown below.