MySQL for DBAs (Certificate)

Montreal College of Management and Technology
Montreal, Quebec, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Is your MySQL database secure? Do your users have the correct privileges and access rights?
Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
Do you want to save time using features like Stored Procedures, Triggers and Views?
Do you want to utilize the new enterprise features of MySQL 5.0?
Then MySQL for DBAs is the class for you! An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!

This instructor led, hands-on class will teach you how to 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.

At the completion of this course, you should be able to:

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 5.0 for the most common operating systems
Perform the MySQL start and shutdown operations
Configure MySQL server options at runtime
Activate and manage numerous server logs
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
Create, Maintain and Manage MySQL tables
Perform backup and restore operations utilizing multiple MySQL tools
Manage user maintenance and access to a MySQL Server
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
Scale MySQL operations up

Certification:

Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Database Administrator Certification Exams
Who should Attend

DBAs and developers who want to administer MySQL
Prerequisites
Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.

Format

Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
...''

Phone:1 514 312 2383

School Address:

1255 University Street, Suite 510
Montreal, Quebec, Canada
H3B 3V8


Jobs & Resumes: Montreal
Houses & Roommates: Montreal
Travel Agencies: Montreal

Search other schools for MySQL for DBAs training resources.

SAS Programming I: Essentials
SAS Programming II: Data Manipulation Using the Data Step
SAS Programming III: Advanced Techniques
SQL Processing with SAS Software
Crystal Reports
Linux
MySQL for Beginners
MySQL for Developers
MySQL and PHP - Developing Dynamic Web Applications
MySQL 5.0: Upgrading and New Features
MySQL

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.