Learn Bench

Introduction

• The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database.
• In this course you will learn how to secure users privileges, set resource limitations, and access controls.
• In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.

Students who can benefit from this course

• DBAs and developers who want to administer MySQL
• Students wishing to prepare for the MySQL Database Administrator Certification Exams

Prerequisites

• Attend the MySQL for Beginners course or some experience with Relational Databases and SQL.
• MySQL for Beginners (SQL-4401)

Objectives

• Install and Upgrade MySQL for the most common operating systems
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Use the INFORMATION_SCHEMA database to access metadata
• Perform the MySQL start and shutdown operations
• Configure MySQL server options at runtime
• Evaluate data types and character sets for performance issues
• Understand data locking concepts and the different levels of locking in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Perform backup and restore operations utilizing multiple MySQL tools
• Maintain integrity of a MySQL installation utilizing security protocols
• Use stored routines and triggers for administration tasks
• Manage, apply and understand the reason for using views
• Improve performance through query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Utilize MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performance