Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL for Database Administrators
Course type Essentials (What does this mean?)
| Course title | MySQL for Database Administrators |
|---|---|
| Delivery method |  Classroom |
| RRP | £1650 exc. VAT |
| Days/Duration | 5 |
| Code | SQL4502 |
Secure online payment
- view dates / book course
- course description
- skills paths
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |- |- |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |- |1 |26 |- Tabernacle Street, EC2 location information and directions
01 Oct 5 or more places available £1,815 exc VAT 26 Nov 5 or more places available £1,815 exc VAT MySQL for Database Administrators training in Tabernacle Street, EC2
North
Manchester |- |- |9 |- Location Sep Oct Nov Dec view earlier dates Manchester |- |- |- |- Manchesterlocation information and directions
09 Jul 5 or more places available £1,650 exc VAT MySQL for Database Administrators training in Manchester
Special Notices
Please note – courses taking place in London are subject to a 10% surcharge
Overview
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 5.0 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 MySQLStudents wishing to prepare for the MySQL 5.0 Database Administrator Certification Exams.
Prerequisites
Having attended the MySQL for Beginners (SQL4401) course or some experience with Relational Databases and SQL
Delegates will learn how to
- Install and Upgrade MySQL 5.0 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
Related certification and/or skills paths
This course forms part of the following certification track(s) or skills path(s):
Need help planning your training?
The easiest way to get help planning your training is to call one of our specialists on 0845 757 3888 or to email us info@qa.com. We'll be happy to help.
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
