Differences

This shows you the differences between two versions of the page.

--- mysqlcertification [2019/02/18 11:03] – created z0hpvk
+++ mysqlcertification [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 [[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 \\