返回列表 发帖

MySQL 5.6数据库管理员(OCP最新版)认证考试

分享到: 新浪微博 腾讯微博 人人网 更多   ☆关注我们:

  


Oracle认证专家中,MySQL 5.6数据库管理员
The Oracle Certified Professional, MySQL 5.6 Database Administrator (OCP) Certification proves your ability to install and optimize MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases.
甲骨文认证专家中,MySQL 5.6数据库管理员( OCP )认证证明您的安装和优化MySQL服务器,设置复制和安全,执行数据库备份及性能优化和保护MySQL数据库的能力。

MySQL 5.6 delivers superior performance monitoring & diagnostics using PERFORMANCE_SCHEMA, replication enhancements including support for multi-threaded replications, new NoSQL interface and partitioning improvements to support scalability and security enhancements.
MySQL 5.6提供了使用PERFORMANCE_SCHEMA卓越的性能监控和诊断,复制增强功能,包括对多线程复制,新的NoSQL接口和分区的改进,以支持可扩展性和安全性增强的支持。

MySQL Application Database Administrator – Certification Exam
MySQL的应用程序数据库管理员 - 认证考试


The MySQL application database administrator exam now requires knowledge across a very broad set of areas. The certification path has been streamlined, requiring only a single exam to become certified, or to upgrade from a prior release. This more technical exam focuses on practitioner-level skills. It covers a broader set of topics and deep dives into key topics such as security, backup, replication and optimization. Successfully passing this exam gives you an advantage over your peers working on MySQL 5.6. Up-to-date training and field experience are recommended.
MySQL的应用程序数据库管理员考试,现在要求在一个非常广泛的领域的知识。证书路径已经简化,只需要一个单一的考试获得认证,或者从以前的版本升级。这更多的技术考试侧重于执业水平的技能。它涵盖了一组主题和深海潜水的更广泛的进入关键主题,如安全性,备份,复制和优化。顺利通过这门考试,你就比你的同龄人工作在MySQL 5.6的优势。截至最新的培训和现场经验建议。




MySQL 5.6 Database Administrator
Exam Number:1Z0-883Duration:150 minutes
Associated Certifications:Oracle Certified Professional, MySQL 5.6 Database Administrator
Number of Questions:100
Passing Score:64% View passing score policy
Exam Product Version:MySQL Database Administration,
Validated Against:This exam has been validated against 5.6.
Exam Price:CNY 1077 More on exam pricing
format:Multiple Choice

考试编号:1Z0-883
考试时间: 150分钟
题量:100 (全是选择题)
考试通过: 正确率 64%
针对:Oracle Certified Professional, MySQL 5.6  管理员认证考试
考试费用  1077 (就是200美金)




你将学到什么?
The MySQL for Database Administrators course is for DBAs and other database professionals who want to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
Learn To:
•        Describe the MySQL Architecture.
•        Install and upgrade MySQL.
•        Configure MySQL server options at runtime.
•        Evaluate data types and character sets for performance issues.
•        Understand the use of the InnoDB storage engine with MySQL.
•        Perform backup and restore operations.
课程主题
Introduction
•        MySQL Overview, Products, Services
•        MySQL Services and Support
•        Supported Operating Services
•        MySQL Certification Program
•        Training Curriculum Paths
•        MySQL Documentation Resources
MySQL Architecture
•        The client/server model
•        Communication protocols
•        The SQL Layer
•        The Storage Layer
•        How the server supports storage engines
•        How MySQL uses memory and disk space
•        The MySQL plug-in interface
System Administration
•        Choosing between types of MySQL distributions
•        Installing the MySQL Server
•        The MySQL Server installation file structure
•        Starting and stopping the MySQL server
•        Upgrading MySQL
•        Running multiple MySQL servers on a single host
Server Configuration
•        MySQL server configuration options
•        System variables
•        SQL Modes
•        Available log files
•        Binary logging
Clients and Tools
•        Available clients for administrative tasks
•        MySQL administrative clients
•        The mysql command-line client
•        The mysqladmin command-line client
•        The MySQL Workbench graphical client
•        MySQL tools
•        Available APIs (drivers and connectors)
Data Types
•        Major categories of data types
•        Meaning of NULL
•        Column attributes
•        Character set usage with data types
•        Choosing an appropriate data type
Obtaining Metadata
•        Available metadata access methods
•        Structure of INFORMATION_SCHEMA
•        Using the available commands to view metadata
•        Differences between SHOW statements and INFORMATION_SCHEMA tables
•        The mysqlshow client program
•        Using INFORMATION_SCHEMA queries to create shell commands and SQL statements
Transactions and Locking
•        Using transaction control statement to run multiple SQL statements concurrently
•        The ACID properties of transactions
•        Transaction isolation levels
•        Using locking to protect transactions
Storage Engines
•        Storage engines in MySQL
•        InnoDB storage engine
•        InnoDB system and file-per-table tablespaces
•        NoSQL and the Memcached API
•        Configuring tablespaces efficiently
•        Using foreign keys to attain referential integrity
•        InnoDB locking
•        Features of available storage engines
Partitioning
•        Partitioning and its use in MySQL
•        Reasons for using partitioning
•        Types of partitioning
•        Creating partitioned tables
•        Subpartitioning
•        Obtaining partition metadata
•        Modifying partitions to improve performance
•        Storage Engine Support of Partitioning
User Management
•        Requirements for user authentication
•        Using SHOW PROCESSLIST to show which threads are running
•        Creating, modifying and dropping user accounts
•        Alternative authentication plugins
•        Requirements for user authorization
•        Levels of access privileges for users
•        Types of privileges
•        Granting, modifying and revoking user privileges
Security
•        Recognizing common security risks
•        Security risks specific to the MySQL installation
•        Security problems and counter-measures for network, operating system, filesystem and users
•        Protecting your data
•        Using SSL for secure MySQL server connections
•        How SSH enables a secure remote connection to the MySQL server
•        Finding additional information for common security issues
Table Maintenance
•        Types of table maintenance operations
•        SQL statements for table maintenance
•        Client and utility programs for table maintenance
•        Maintaining tables for other storage engines
Exporting and Importing Data
•        Exporting Data
•        Importing Data
Programming Inside MySQL
•        Creating and executing Stored Routines
•        Describing stored routine execution security
•        Creating and executing triggers
•        Creating, altering and dropping events
•        Event execution scheduling
MySQL Backup and Recovery
•        Backup basics
•        Types of backup
•        Backup tools and utilities
•        Making binary and text backups
•        Role of log and status files in backups
•        Data Recovery
Replication
•        Managing the MySQL Binary Log
•        MySQL replication threads and files
•        Setting up a MySQL Replication Environment
•        Designing Complex Replication Topologies
•        Multi-Master and Circular Replication
•        Performing a Controlled Switchover
•        Monitoring and Troubleshooting MySQL Replication
•        Replication with Global Transaction Identifiers (GTIDs)
Introduction to Performance Tuning
•        Using EXPLAIN to Analyze Queries
•        General Table Optimizations
•        Monitoring status variables that affect performance
•        Setting and Interpreting MySQL server Variables
•        Overview of Performance Schema
Conclusion
•        Course Overview
•        MySQL Curriculum
•        Course Evaluation
•        Thank You!
•        Q&A Session


课程目标
•        Describe the MySQL Architecture
•        Install and Upgrade MySQL
•        Use the INFORMATION_SCHEMA database to access metadata
•        Perform the MySQL start and shutdown operations
•        Configure MySQL server options at runtime
•        Use available tools including MySQL Workbench
•        Evaluate data types and character sets for performance issues
•        Understand data locking in MySQL
•        Understand the use of the InnoDB storage engine with MySQL
•        Maintain integrity of a MySQL installation
•        Use triggers for administration tasks
•        Use Enterprise Audit and Pluggable Authentication
•        Configure advanced replication topologies for high availability
•        Describe introductory performance tuning techniques
•        Perform backup and restore operations
•        Automate administrative tasks with scheduled events
收藏 分享
【誉天教育官方微信】(微信公众账号:誉天教育 ;或加微信号:yutianedu2013) 求调戏

誉天腾讯微博:http://t.qq.com/yutianedu
誉天新浪微博:http://weibo.com/yutianedu

2014.04.22誉天mysql开班,名额已经满了。如果想要学习的同学可以预约下一期的班哦。
【誉天教育官方微信】(微信公众账号:誉天教育 ;或加微信号:yutianedu2013) 求调戏

誉天腾讯微博:http://t.qq.com/yutianedu
誉天新浪微博:http://weibo.com/yutianedu

TOP

有题库分享不

TOP

返回列表