Course details
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.
Course Content
- Lesson 1: Introduction to MySQL
- Lesson 2: Architecture
- Lesson 3: System Administration
- Lesson 4: Server Configuration
- Lesson 5: Clients and Tools
- Lesson 6: Data Types
- Lesson 7: Obtaining Metadata
- Lesson 8: Transactions and Locking
- Lesson 9: Storage Engines
- Lesson 10: Partitioning
- Lesson 11: User Management
- Lesson 12: Security
- Lesson 13: Table Maintenance
- Lesson 14: Exporting and Importing Data
- Lesson 15: Programming inside MySQL
- Lesson 16: MySQL Backup and Recovery
- Lesson 17: Replication
- Lesson 18: Introduction to Performance Tuning
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Data Analytics (8-in-1 Career Guided Bundle) NextGen LearningZAR 991Duration: Upto 20 Hours
- A to Z SQL Programming JanetsZAR 184Duration: Upto 22 Hours
