DB Wiki

User Tools

Site Tools

Trace: • databaseauditing • mysqlcertification
mysqlcertification

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysqlcertification [2019/03/11 15:29] – z0hpvkmysqlcertification [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 4: Line 4:
  
 ==== Installing MySQL ==== ==== Installing MySQL ====
-Install MySQL \\+[[InstallMySQL|Install MySQL]] \\
 [[MySQLFilesDirectories|Identify installed Files and Directories]] \\ [[MySQLFilesDirectories|Identify installed Files and Directories]] \\
-Understand Initial Configuration \\ +[[https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html|Understand Initial Configuration]] \\ 
-Start and Stop MySQL \\+[[https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html|Start and Stop MySQL]] \\
  
 ==== Configuring MySQL ==== ==== Configuring MySQL ====
Line 30: Line 30:
  
 ==== Backup Strategies ==== ==== Backup Strategies ====
-Understand Backups \\ +[[https://dev.mysql.com/doc/refman/5.7/en/backup-types.html|Understand Backups]] \\ 
-Create a Backup Strategy \\ +[[https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html|Create a Backup Strategy]] \\ 
-Use MySQL Backup Tools \\+[[https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html|Use MySQL Backup Tools]] \\
 Define Raw Backup Methods \\ Define Raw Backup Methods \\
-Explain Techniques that Use the Binary Log \\+[[https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html|Explain Techniques that Use the Binary Log]] \\
  
 ==== MySQL Architecture ==== ==== MySQL Architecture ====
 Understand How MySQL Processes Requests \\ Understand How MySQL Processes Requests \\
 Explain How MySQL Stores Data \\ Explain How MySQL Stores Data \\
-Use Tablespaces \\+[[https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html|Use Tablespaces]] \\
 Identify Redo and Undo Logs \\ Identify Redo and Undo Logs \\
 Define How MySQL Uses Memory \\ Define How MySQL Uses Memory \\
Line 46: Line 46:
 Monitor MySQL with Log Files \\ Monitor MySQL with Log Files \\
 Monitor MySQL with Status Variables \\ Monitor MySQL with Status Variables \\
-Monitor MySQL with Performance Schema \\+[[https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html|Monitor MySQL with Performance Schema]] \\
  
 ==== MySQL Security ==== ==== MySQL Security ====
Line 56: Line 56:
  
 ==== Optimizing Query Performance ==== ==== Optimizing Query Performance ====
-Identify Slow Queries \\ +[[https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html|Identify Slow Queries]] \\ 
-Understand the EXPLAIN statement \\ +[[https://dev.mysql.com/doc/refman/5.7/en/explain-output.html|Understand the EXPLAIN statement]] \\ 
-Work with Indexes \\ +[[https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html|Work with Indexes]] \\ 
-Use Index Statistics \\+[[https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html|Use Index Statistics]] \\
  
 ==== Configuring a Replication Topology ==== ==== Configuring a Replication Topology ====
mysqlcertification.1552318176.txt.gz · Last modified: (external edit)