DB Wiki

User Tools

Site Tools

Trace:
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/04/02 08:46] – z0hpvkmysqlcertification [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 6: Line 6:
 [[InstallMySQL|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]] \\
 [[https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html|Start and Stop MySQL]] \\ [[https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html|Start and Stop 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]] \\
 [[https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html|Use Index Statistics]] \\ [[https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html|Use Index Statistics]] \\
  
mysqlcertification.1554194793.txt.gz · Last modified: 2025/03/08 22:23 (external edit)