Location

Community Services & Continuing Education - Alexandria

Objectives

• This course aims to give administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services.

Outcomes

Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases.

Course Contents

- Describe the MySQL Architecture, general operational characteristics and resources utilized for running it. - Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application - Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server - Use the INFORMATION_SCHEMA database to access metadata - Install and Upgrade MySQL for the most common operating systems - Perform the MySQL start and shutdown operations - Activate and manage numerous server logs - Evaluate data types and character sets for performance issues - Differentiate between the multiple storage engines available in MySQL- Create, Maintain and Manage MySQL tables - Perform backup and restore operations utilizing multiple MySQL tools - Manage user maintenance and access to a MySQL Server - Use stored routines and triggers for administration tasks- Manage, apply and understand the reason for using vie