Course Code: MYSDBA
Duration: 5 days
Our training courses can also be delivered at a location of your choice...
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 and optimising query performance. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability.
Versions supported 8, 5.7, 5.6.
The delegate will learn and acquire skills as follows:
Database Administrators, Database Developers and Technical Consultants who need to setup, administer, monitor and support MySQL databases and servers.
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 5.6, 5.7 and 8 databases and servers.
The MySQL Database Administration course will teach the major topics required for the delegate to work towards achieving the following examination:
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.
MySQL Database Administration
Duration: 5 days
RRP: £1,495.00 exc. VAT
|03 Feb 2020||Spaces||Book|
|23 Mar 2020||Spaces||Book|
|11 May 2020||Spaces||Book|
|29 Jun 2020||Spaces||Book|
|17 Aug 2020||Spaces||Book|
|12 Oct 2020||Spaces||Book|
|07 Dec 2020||Spaces||Book|
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
Public Scheduled and Closed
UK and Overseas
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!
Our Course Curriculum