MySQL 5.7 OCP考试大纲

     目录

1 Installing MySQL

2 Configuring MySQL

3 User Management

4 Maintaining a Stable System

5 Backup Strategies

6 MySQL Architecture

7 Monitoring MySQL

8 MySQL Security

9 Optimizing Query Performance

10 Configuring a Replication Topology


       MySQL DBA的认证截至当前(2019.8.10)已推出5.7版本的OCP,可点击此处跳转到Oracle education进行查看,网页截图如下。

       MySQL 5.7 OCP的考试代号是1Z0-888,120分钟的考试时间需做完75选择题,考题形式为单选和多选,正确率达到58%可通过考试。考试费目前为人民币1077元。如果了解甲骨文认证,一定知道考试内容是纯英文的。

       值得一提的是目前MySQL认证不要求有培训经历,相关的训练课程标注了“可选”,见下图,也就是说可以花费一千出头的费用直接参加考试,相对比其他的Oracle认证,这个价格确实是比较便宜。

 

       目前网络上5.7 OCP相关的资料还比较少,在备考上相对Oracle OCP难度稍高,更考验个人的基本功,下面我将考试介绍中大纲部分的内容粘贴如下,共涉及10个主题。

1 Installing MySQL

  • Install MySQL
  • Identify installed Files and Directories
  • Understand Initial Configuration
  • Start and Stop MySQL

2 Configuring MySQL

  • Understand Server Options, Variables, and the Command Line
  • Define Option Files
  • Use System Variables

3 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

4 Maintaining a Stable System

  • Define Stability
  • Use Capacity Planning
  • Troubleshoot
  • Identify the Causes of Server Slowdowns
  • Describe InnoDB Recovery

5 Backup Strategies

  • Understand Backups
  • Create a Backup Strategy
  • Use MySQL Backup Tools
  • Define Raw Backup Methods
  • Explain Techniques that Use the Binary Log

6 MySQL Architecture

  • Understand How MySQL Processes Requests
  • Explain How MySQL Stores Data
  • Use Tablespaces
  • Identify Redo and Undo Logs
  • Define How MySQL Uses Memory

7 Monitoring MySQL

  • Monitor MySQL with Log Files
  • Monitor MySQL with Status Variables
  • Monitor MySQL with Performance Schema

8 MySQL Security

  • Identify Security Risks
  • Understand Network security
  • Use Password Security
  • Explain Operating System Security
  • Protect Against SQL Injections

9 Optimizing Query Performance

  • Identify Slow Queries
  • Understand the EXPLAIN statement
  • Work with Indexes
  • Use Index Statistics

10 Configuring a Replication Topology

  • Replicate Conflicts
  • Explain Replication
  • Configure Replication
  • Use MySQL Utilities
  • Identify Replication Threads
  • Monitor Replication
  • Troubleshoot Replication

       为了方便阅读,我使用了Google浏览器的翻译功能将翻译后的中文页面截图如下,机器翻译仅供参考。

 

       在目前考试资料比较少的情况下,从以上10个主题中出75道考题,对于专职的MySQL DBA来讲也是有一定难度的,关键是纯英文考试。

       证书有没有必要考仍然得一分为二的看,根据自身情况,银子够并、精力够就趁早拿下,某些机会的出现不会看技术具体有多好,毕竟靠纯技术流走在技能金字塔顶端的人还是占少数的。

相关链接

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

 

 

Tank

2019.8.10

 

 

©️2020 CSDN 皮肤主题: 精致技术 设计师:CSDN官方博客 返回首页