===== MySQL Certification =====

[[https://education.oracle.com/mysql-57-database-administrator/pexam_1Z0-888]]\\

==== Installing MySQL ====
[[InstallMySQL|Install MySQL]] \\
[[MySQLFilesDirectories|Identify installed Files and Directories]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html|Understand Initial Configuration]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html|Start and Stop MySQL]] \\

==== Configuring MySQL ====
Understand Server Options, Variables, and the Command Line \\
Define Option Files \\
Use System Variables \\

==== User Management ====
Identify MySQL Privilege System \\
Create and Modify User Accounts \\
Configure Passwords and Account Expiration \\
Understand Authentication Plug-Ins \\
Grant Permissions \\
Reset a Forgotten Root Password \\

==== Maintaining a Stable System ====
Define Stability \\
Use Capacity Planning \\
Troubleshoot \\
Identify the Causes of Server Slowdowns \\
Describe InnoDB Recovery \\

==== Backup Strategies ====
[[https://dev.mysql.com/doc/refman/5.7/en/backup-types.html|Understand Backups]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html|Create a Backup Strategy]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html|Use MySQL Backup Tools]] \\
Define Raw Backup Methods \\
[[https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html|Explain Techniques that Use the Binary Log]] \\

==== MySQL Architecture ====
Understand How MySQL Processes Requests \\
Explain How MySQL Stores Data \\
[[https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html|Use Tablespaces]] \\
Identify Redo and Undo Logs \\
Define How MySQL Uses Memory \\

==== Monitoring MySQL ====
Monitor MySQL with Log Files \\
Monitor MySQL with Status Variables \\
[[https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html|Monitor MySQL with Performance Schema]] \\

==== MySQL Security ====
Identify Security Risks \\
Understand Network security \\
Use Password Security \\
Explain Operating System Security \\
Protect Against SQL Injections \\

==== Optimizing Query Performance ====
[[https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html|Identify Slow Queries]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/explain-output.html|Understand the EXPLAIN statement]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html|Work with Indexes]] \\
[[https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html|Use Index Statistics]] \\

==== Configuring a Replication Topology ====
Replicate Conflicts \\
Explain Replication \\
Configure Replication \\
Use MySQL Utilities \\
Identify Replication Threads \\
Monitor Replication \\
Troubleshoot Replication \\