Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL. Here, you will be able to configure and install the client programs for the MySQL server. You will also be able to recognize the key components of MySQL architecture. You will also learn about the process of managing user accounts on MySQL by controlling the access permission. Security of the data is one of the primary issues for any IT infrastructure. The subject matter of the Oracle Certified Professional, MySQL 8.0 Database Administrator course will let you learn about how to design, develop and deploy the security measures while working as a Database Designer or Database Developer using MySQL 8.0. You will also be able to troubleshoot the server and address other MySQL-related issues as well. You will also learn how to develop and implement an effective and appropriate backup and recovery process for MySQL Database.
ORACLE CERTIFIED PROFESSIONAL, MySQL 8.0 DATABASE ADMINISTRATOR TRAINING
Instructor
admin
- Description
- Curriculum
- FAQ
- Reviews
Prerequisites
- Officially, no particular prerequisite is mentioned for this course
- It is expected that you the concept of working with relational database
- You are also expected to have the knowledge and concept of the basic SQL statement
- You must be familiar with Linux/Unix Operating System, and you should know to execute commands using Linux/Unix
What will you gain after this course
- You will be able to install MySQL Server, including the client program.
- You will be able to describe the architecture of MySQL 8.0, as well.
- You will learn about how to upgrade a server using running on MySQL 8.0.
- You will also be able to explain the data transmission and storage process of MySQL 8.0.
- You will learn to configure the server logs and other tools to monitor the activities of the MySQL 8.0 Database.
- You will also be able to create users and develop and maintain their access role in MySQL 8.0.
- You will learn to protect your data from any data vulnerability
- You will be able to identify the problems and optimise the performance of MySQL 8.0.
- You will be able to configure replication topologies for both the complex and straightforward database, designed and developed by My SQL 8.0.
- You will learn how to configure and administer MySQL 8.0 using InnoDB Cluster.
Jobs you can get
with a Oracle Certified Professional, MySQL 8.0 Database Administrator
- MySQL Database Administrator
- IT Technical Specialist (Level – IV)
- Cloud Database Administrator
- Senior Database Administrator
- PostgreSQL Database Administrator
Select your preferred training delivery mode
Architecture
<ul>
<li> Configure client connections to the server</li>
<li> Understand how MySQL stores data</li>
<li> Understand how InnoDB stores data and logs</li>
<li> Configure buffers and caches</li>
<li> Understand and use the Data Dictionary</li>
</ul>
<li> Configure client connections to the server</li>
<li> Understand how MySQL stores data</li>
<li> Understand how InnoDB stores data and logs</li>
<li> Configure buffers and caches</li>
<li> Understand and use the Data Dictionary</li>
</ul>
Server Installation and Configuration
<ul>
<li> Install and use the MySQL server and client programs</li>
<li> Identify the files and folders created during installation</li>
<li> Start and stop MySQL</li>
<li> Upgrade MySQL</li>
<li> Configure MySQL by using options and option files</li>
<li> Configure MySQL variables</li>
<li> Launch multiple MySQL servers on the same host</li>
</ul>
<li> Install and use the MySQL server and client programs</li>
<li> Identify the files and folders created during installation</li>
<li> Start and stop MySQL</li>
<li> Upgrade MySQL</li>
<li> Configure MySQL by using options and option files</li>
<li> Configure MySQL variables</li>
<li> Launch multiple MySQL servers on the same host</li>
</ul>
Security
<ul>
<li> Create user accounts and roles</li>
<li> Use authentication plug-ins</li>
<li> Control user and role permissions</li>
<li> Recognize common security risks</li>
<li> Secure MySQL server connections</li>
<li> Provide password and login security</li>
<li> Secure the MySQL host environment</li>
<li> Prevent SQL injection attacks</li>
<li> Encrypt MySQL data</li>
<li> Configure MySQL Enterprise Firewall</li>
</ul>
<li> Create user accounts and roles</li>
<li> Use authentication plug-ins</li>
<li> Control user and role permissions</li>
<li> Recognize common security risks</li>
<li> Secure MySQL server connections</li>
<li> Provide password and login security</li>
<li> Secure the MySQL host environment</li>
<li> Prevent SQL injection attacks</li>
<li> Encrypt MySQL data</li>
<li> Configure MySQL Enterprise Firewall</li>
</ul>
Monitoring and Maintenance
<ul>
<li> Configure and view MySQL log files</li>
<li> Monitor MySQL processes and status</li>
<li> Configure MySQL Enterprise Audit</li>
<li> Use MySQL Enterprise Monitor to view activity in MySQL</li>
<li> Monitor database growth and explain capacity planning</li>
<li> Troubleshoot problems with locked resources</li>
<li> Query Optimization</li>
<li> Examine how MySQL optimizes queries</li>
<li> Analyze queries with MySQL Enterprise Monitor</li>
<li> Create indexes to improve server performance</li>
<li> Monitor and understand index statistics</li>
</ul>
<li> Configure and view MySQL log files</li>
<li> Monitor MySQL processes and status</li>
<li> Configure MySQL Enterprise Audit</li>
<li> Use MySQL Enterprise Monitor to view activity in MySQL</li>
<li> Monitor database growth and explain capacity planning</li>
<li> Troubleshoot problems with locked resources</li>
<li> Query Optimization</li>
<li> Examine how MySQL optimizes queries</li>
<li> Analyze queries with MySQL Enterprise Monitor</li>
<li> Create indexes to improve server performance</li>
<li> Monitor and understand index statistics</li>
</ul>
Backups and Recovery
<ul>
<li> Distinguish between the different types of backup</li>
<li> Implement a backup strategy</li>
<li> Backup and restore data with MySQL Enterprise Backup</li>
<li> Use mysqldump and mysqlpump to perform logical backups</li>
<li> Explain when and how to use raw file backups</li>
<li> Back up the binary log</li>
</ul>
<li> Distinguish between the different types of backup</li>
<li> Implement a backup strategy</li>
<li> Backup and restore data with MySQL Enterprise Backup</li>
<li> Use mysqldump and mysqlpump to perform logical backups</li>
<li> Explain when and how to use raw file backups</li>
<li> Back up the binary log</li>
</ul>
High Availability Techniques
<ul>
<li> Explain how replication provides high availability and scalability</li>
<li> Configure replication</li>
<li> Explain the role of the binary log in replication</li>
<li> Configure multi source replication</li>
<li> Explain the role of replication threads</li>
<li> Monitor and troubleshoot replication</li>
<li> Describe MySQL InnoDB cluster and Group Replication</li>
<li> Configure a MySQL InnoDB cluster</li>
<li> Perform an InnoDB cluster recovery</li>
</ul>
<li> Explain how replication provides high availability and scalability</li>
<li> Configure replication</li>
<li> Explain the role of the binary log in replication</li>
<li> Configure multi source replication</li>
<li> Explain the role of replication threads</li>
<li> Monitor and troubleshoot replication</li>
<li> Describe MySQL InnoDB cluster and Group Replication</li>
<li> Configure a MySQL InnoDB cluster</li>
<li> Perform an InnoDB cluster recovery</li>
</ul>
Please, login to leave a review
Course details
Duration
Full time, Part-time, Evening and Weekends, Virtual online
Video
London, Flexible online
Popular courses
