Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Exam 006-002

This course will be retired in 252 days. If you have questions, please contact us.

Note: The 006-002 exam has been retired. However, this course remains a valuable IT resource for database administrators....
Note: The 006-002 exam has been retired. However, this course remains a valuable IT resource for database administrators.

In this terrific course, Tim Warner shows you how to run a production MySQL environment, build Web applications that rely upon MySQL and be fully prepared for the second of two MySQL Certified Dabase Administrator (CMDBA) exams.

Tim demonstrates MySQL on both Windows and Linux platforms, demonstrates MySQL replication (something you're unlikely to see in any other training) and leaves with a crystal-clear understanding of MySQL security.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Course Overview (22 min)
2. Understanding Identifiers (31 min)
3. Creating Stored Procedures (36 min)
4. Creating Triggers (24 min)
5. Using Stored Routines for Administration (18 min)
6. MySQL User Account Administration (36 min)
7. MySQL Security Basics Part 1 (31 min)
8. MySQL Security Basics Part 2 (40 min)
9. MySQL Security Basics Part 3 (35 min)
10. Upgrade-Related Security Considerations (26 min)
11. Optimizing Queries Part 1 (36 min)
12. Optimizing Queries Part 2 (29 min)
13. Optimizing Databases and Tables (28 min)
14. Storage Engine-Specific Optimizations Part 1 (34 min)
15. Storage Engine-Specific Optimizations Part 2 (25 min)
16. Performance Tuning MySQL Server (33 min)
17. Diagnosing MySQL Problems (27 min)
18. Optimizing the MySQL Server Environment Part 1 (20 min)
19. Optimizing the MySQL Server Environment Part 2 (18 min)
20. Scaling Out MySQL (34 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
10 hrs 20 videos


Training Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.