Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Choose date
From: R14 999,00
Price excluding VAT
Introduction:
This five-day instructor-led course is for DBAs and other database professionals who want to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases. Database administrators will learn how new enhancements made available in MySQL 5.6 will increase performance, scalability, reliability and manageability for their Web, Cloud and embedded application requirements. You will be able to install, configure, maintain and tune databases for a wide variety of workloads and environments.
Audience profile:
Database Administrators, Database Designers and Developers
Pre-requisites:
Before attending this course, students must have:
- Have some experience with databases and the SQL language Oracle requires and recommends that delegates have attended the following course prior to attending this course.
- D61918GC30 MySQL for Beginners
Course objectives:
After completing this course, students will be able to:
- Describe the MySQL Architecture
- Install and Upgrade MySQL
- Use the INFORMATION_SCHEMA database to access metadata
- Perform the MySQL start and shutdown operations
- Configure MySQL server options at runtime
- Use available tools including MySQL Workbench
- Evaluate data types and character sets for performance issues
- Understand data locking in MySQL
- Understand the use of the InnoDB storage engine with MySQL
- Maintain integrity of a MySQL installation
- Use triggers for administration tasks
- Use Enterprise Audit and Pluggable Authentication
- Configure advanced replication topologies for high availability
- Describe introductory performance tuning techniques
- Perform backup and restore operations
- Automate administrative tasks with scheduled events
Lesson 1: Introduction to MySQL
This lesson describes the goals of the course and the classroom learning environment. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 2: Architecture
This lesson describes the nature and architecture of the MySQL Server/Client model, MySQL storage engines and memory and disk space usage. Lessons: |
|
|
|
|
|
|
|
Lesson 3: System Administration
This lesson explains the available software distributions and the installation and configuration of MySQL. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 4: Server Configuration
This lesson explains the concepts of configuring MySQL server through the use of configuration files, server variables, SQL modes and log files. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 5: Clients and Tools
This lesson describes the use of various clients and tools for server administration. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 6: Data Types
This lesson explores the data types and character sets available within the MySQL database environment. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 7: Obtaining Metadata
This lesson explains the use of different interfaces and methods for obtaining database metadata. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 8: Transactions and Locking
This lesson describes the use of transactional control statements and the concepts of transaction isolation and protection. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 9: Storage Engines
This lesson describes the general purpose and availability of storage engines within MySQL. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 10: Partitioning
This lesson describes the nature, implementation and usage of table partitioning within MySQL. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 11: User Management
This lesson explains creation and management of user accounts and account security. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 12: Security
This lesson describes the various security risks that could affect MySQL. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 13: Table Maintenance
This lesson explains how to perform table maintenance through the use of SQL statements and MySQL utilities. Lessons: |
|
|
|
|
|
|
|
|
|
Lesson 14: Exporting and Importing Data
This lesson explains how to export and import MySQL data. Lessons: |
|
|
|
|
|
|
|
Lesson 15: Programming inside MySQL
This lesson describes how to create automated routines within MySQL. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 16: MySQL Backup and Recovery
This lesson describes the concepts, and creation of, MySQL backups. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 17: Replication
This lesson describes how to create high availability solutions through database replication. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lesson 18: Introduction to Performance Tuning
This lesson describes how to address performance related issues on MySQL through query analysis and modification of server variables. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Torque IT specializes in providing our Clients with Vendor authorized instructor-led training, enablement IT courses, and certification solutions.
Associated certifications and exam:
This course prepares students to write Exam 1Z0-883: MySQL 5.6 Database Administrator Certified Professional. On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorized Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorized Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorized Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognized by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognized and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognized by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.