Course overview

- Do you want to have hands-on experience administering a MySQL database?
- Are you concerned about your MySQL database being secure?
- Do your users have the correct privileges and access rights?
- Do you want to develop and implement a backup strategy for you MySQL data?
- Do you want to utilize the latest features of the MySQL server to improve efficiency?

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, implement partitioning, manage users and so much 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 the latest features such as Partitioning, Stored Procedures, Triggers and Views.

Goal

Upon completion of this course, students 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
• 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
• 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 Explain and utilize Partioning
• 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
• Understand how stored routines and triggers can be used for administration tasks
• Manage, apply and understand the reason for using views
• Describe ways that MySQL performance can be improved
• Describe how MySQL can be used for high availability

Duration
5 days from 9AM to 5PM

Location
Housing d.o.o., Zaharova 7, 10000 Zagreb, Croatia

Special offer
- 5 - 9 students from the same company 10%
- 10 and more students from the same company 20%

Price
1.199 EUR + VAT

Date
26.04.2010. - 30.04.2010.

Target group

DBAs and developers who want to administer MySQL.

Prerequisites

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

Curriculum material

Official MySQL Student Kit

Certification

Tthis course prepares you for the exam:

• Sun Certified MySQL Associate (CX-310-814)

Combined with sufficient practical experience and/or course MySQL Performance Tuning (SQL-4402), this course prepares you for the exams:

• Sun Certified MySQL 5.0 Database Administrator Part I (CX-310-810)
• Sun Certified MySQL 5.0 Database Administrator Part II (CX-310-811)

Contact

Housing d.o.o.
Zaharova 7, 10000 Zagreb, Croatia
T: +385 1 4878999
F: +385 1 4878998
e-mail: info@housing.hr