MySQL for Database Administrators

Overview

This MySQL for Database Administrators training is an establishment course. It shows database administrators and developers how to utilize this capable database. Learners Who Will Benefit from this Course: DBAs and developers who need to administer MySQL. Students wishing to get ready for the MySQL Database Administrator Certification Exams. Figure out how to secure clients benefits, set asset restrictions and access controls. Trainers will demonstrate to you proper methodologies to make and utilize Stored Procedures, Triggers and Views.

Course 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

This course prepares you for Exam 1Z0-883. Download Course Contents Test your current knowledge Qubits

Schedule & Prices

Course Details	Schedule
Classroom Training* Duration : 5 Days Fee : Sydney : USD 3,000 London : USD 3,200 Dubai : USD 3,700 India : USD 2,000	April 13-17 (Birmingham) (Venue) 13-17 (Brisbane) (Venue) 13-17 (Delhi) (Venue) 13-17 (Manchester) (Venue) 13-17 (Melbourne) (Venue) 13-17 (Sydney) (Venue) 20-24 (Chennai) (Venue) 20-24 (London) (Venue) 27-01 (Bangalore) (Venue) May 11-15 (Birmingham) (Venue) 11-15 (Brisbane) (Venue) 11-15 (Delhi) (Venue) 11-15 (Manchester) (Venue) 11-15 (Melbourne) (Venue) 11-15 (Sydney) (Venue) 18-22 (Chennai) (Venue) 18-22 (London) (Venue) 25-29 (Bangalore) (Venue) June 08-12 (Birmingham) (Venue) 08-12 (Brisbane) (Venue) 08-12 (Delhi) (Venue) 08-12 (Manchester) (Venue) 08-12 (Melbourne) (Venue) 08-12 (Sydney) (Venue) 15-19 (Chennai) (Venue) 15-19 (London) (Venue) 22-26 (Bangalore) (Venue) July 06-10 (Delhi) 06-10 (London) 12-16 (Dubai) 13-17 (Bangalore) 13-17 (London) 20-24 (Chennai) August 03-07 (Delhi) 03-07 (London) 09-13 (Dubai) 10-14 (London) September 14-18 (Bangalore)

Enquire Now

Input symbols

Course Prerequisites

Attend the MySQL for Beginners course or some experience with Relational Databases and SQL.

Upon Completion of this Course, you will accomplish following:-

Introduction
MySQL Architecture
The MySQL Server
Configuring the MySQL Server
MySQL Clients
Overview of Data Types
Metadata
Storage Engines
Partitioning
Transactions and Locking
Security and User Management
Table Maintenance
Exporting and Importing Data
Programming with MySQL
Backup and Recovery