Course Code: MYSDBA
Duration: 5 days
This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.
The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 8, 5.7, 5.6.
At the end of the MySQL Database Administration course, delegates will have the knowledge to use the features available to administer, monitor and support MySQL databases and servers.
Database Administrators, Database Developers and Technical Consultants who need to setup, administer, monitor and support MySQL databases and servers.
The delegate will learn and acquire skills as follows:
The MySQL Database Administration course in conjunction with the MySQL Performance & Tuning course will teach the major topics required for the delegate to work towards achieving one of the following exams:
After passing the relevant exam, candidates will achieve one of the following certifications:
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam's objectives. Studying these courses and their associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
A working knowledge of MySQL is required. Delegates should have knowledge of relational database concepts; have knowledge of MySQL data types; be able run Queries using SQL; join tables and run basic DDL and DML statements. This knowledge can be gained by attendance on the Introduction to MySQL course.
This course is run on a Linux operating system platform, therefore, a good working knowledge of Linux/UNIX is strongly recommended. This knowledge can be gained by attendance on the Linux Introduction course.
Thank you for a wonderful and informative course will definitely look to you for future courses.
Jason - Travel
Excellent course as usual, great tutor and excellent knowledge.
Carl - DBA - Communications
First time using StayAhead for training and would use again and recommend.
Craig - Insurance
Good course, well instructed good learning environment.
Ellis - Finance
The trainer provided in depth knowledge of the MySQL product, and was very helpful with any questions that I had.
Paul - Systems Linux Engineer - Communications
I enrolled on this course to get a good initial understanding of MySQL and this course achieved it. The documentation and instruction were both excellent. Hopefully this will allow me to move on to gain on the job experience.
Shahriar - DBA
Duration: 5 days
Price: £1,495.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum