MySQL管理员认证培训

kider

课程名称：MySQL 5.0 for Database Administrator
适用对象：本课程适用于管理 MySQL 的数据库管理员和开发人员。对关系数据库和SQL有一定的使用经验的人员；
需要认证。
能够熟练阅读英文原版教材
课时：2天
相关证书：CMDBA认证
授课教师：MySQL社区认证教师
价格：RMB2900（人多价格更低）
授课形式：讲解，练习，考试

学习完成该课程，你能够：
描述 MySQL 体系结构，一般操作特性及运行中的资源利用
利用 MySQL 应用中包含的多种程序完成数据库管理任务
利用 MySQL 管理员图形用户界面管理 MySQL 服务器
利用 INFORMATION_SCHEMA 数据库访问元数据
为最常用的操作系统安装及更新 MySQL 5.0
完成 MySQL 启动和关闭操作
在运行时间配置 MySQL 服务器选项
激活和管理众多的服务器日志
为解决性能问题评估数据类型及字符集
了解数据锁定概念以及在 MySQL 中不同级别的锁定
MySQL 中多种存储引擎的区别
建立、维护和管理 MySQL 表
利用多种 MySQL 工具完成备份及恢复操作
管理访问 MySQL 服务器的用户
提升 MySQL 服务器的安全性
采用存储事务及触发器执行管理任务
管理，应用及了解使用视图的理由
查询优化以改善性能
利用多重技巧优化Schemas （数据库）
利用 MySQL 监视工具分析服务器性能问题
选择合适的启动选项以改善服务器性能

培训提纲：
Introduction

• MySQL Overview, Products, Services
• MySQL Services and Support
• Supported Operating Services
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Documentation Resources
  

MySQL Architecture

• Describe the client/server model
• Understand communication protocols
• Understand how the server supports storage engines
• Explain the basics of how MySQL uses memory and disk space
  

System Administration

• Choose between types of MySQL distributions
• Install the MySQL Server
• Describe the MySQL Server installation file structure
• Start and stop the MySQL server
• Upgrade MySQL
• Run multiple MySQL servers on a single host
  

Server Configuration

• Set up MySQL server configuration files
• Explain the purpose of dynamic server variables
• Review the server status variables available
• Configure operational characteristics of the MySQL server
• Describe the available log files
• Explain binary logging
  

Clients and Tools

• Describe the available clients for administrative tasks
• Use MySQL administrative clients
• Use the mysql command line clients
• Use the mysqladmin for administrative tasks
• Describe available MySQL tools
• List the available APIs (drivers and connectors)
  

Data Types

• Describe the major categories of data types
• Explain the meaning of NULL
• Describe column attributes
• Explain character set usage with data types
• Choose an appropriate data type
  

Obtaining Metadata

• List the various metadata access methods available
• Recognize the structure of the INFORMATION_SCHEMA database schema
• Use the available commands to view metadata
• Describe differences between SHOW statements and INFORMATION_SCHEMA tables
• Use the mysqlshow client program
• Use INFORMATION_SCHEMA to create shell commands and SQL statements
  

Transaction and Locking

• Use transaction control statement to run multiple SQL statements concurrently
• Explain the ACID properties
• Describe the transaction isolation levels
• Use locking to protect transactions
  

InnoDB Storage Engine

• Describe the InnoDB storage engine
• Set the storage engine to InnoDB
• Illustrate the InnoDB tablespace storage system
• Efficiently configure the tablespace
• Use foreign keys to attain referential integrity
• Explain InnoDB locking
  

Other Storage Engines

• Explain the general purpose of storage engines in MySQL
• List the storage engines available for MySQL
• Describe the key features of the MyISAM storage engine
• Describe the key features of the MEMORY storage engine
• Give an overview of other storage engines: FEDERATED, ARCHIVE, BLACKHOLE, NDBCLUSTER
• Choose an appropriate storage engine
  

Partitioning

• Define partitioning and its particular use in MySQL
• Determine server partitioning support
• List the reasons for using partitioning
• Explain the types of partitioning
• Create partitioned tables
• Describe subpartitioning
• Obtain partitioning metadata
• Use partitioning to improve performance
  

User Management

• Depict the user connection and query process
• List requirements for user authentication
• Use SHOW PROCESSLIST to show which threads are running
• Create, modify and drop user accounts
• List requirements for user authorization
• Describe the levels of access privileges for users
• List the types of privileges
• Grant, modify and revoke user privileges
  

Security

• Recognize common security risks
• Describe security risks specific to the MySQL installation
• List security problems and counter-measures for network, operating system, filesystem and users
• Protect your data
• Use SSL for secure MySQL server connections
• Explain how SSH enables a secure remote connection to the MySQL server
• Find additional information for common security issues
  

Table Maintenance

• Recognize types of table maintenance operations
• Execute SQL statements for table maintenance
• Client and utility programs for table maintenance
• Maintain tables according to specific storage engines
  

Exporting and Importing Data

• Exporting Data using SQL
• Importing Data using SQL
  

Programming Inside MySQL

• Creating and executing Stored Routines
• Describing stored routine execution security
• Creating and executing triggers
• Creating, altering and dropping events
• Explaining even execution scheduling
  

Views

• Defining views
• Reasons to use views
• Altering, checking and removing a view
• Setting privileges for views
  

MySQL Backup and Recovery

• Describing backup basics
• Types of backups
• Backup tools and utilities
• Making binary and text backups
• Role of log and status files in backups
• Data Recovery
  

Introduction to Replication

• Describing MySQL Replication
• Managing the MySQL Binary Log
• Explaining MySQL replication threads and files
• Setting up a MySQL Replication Environment
• Monitoring MySQL Replication
• Troubleshooting MySQL Replication
  

Introduction to Performance Tuning

• Using EXPLAIN to Analyze Queries
• General Table Optimizations
• Monitoring status variables that affect performance
• Setting and Interpreting MySQL server Variables
  

Conclusion

• Course Overview
• MySQL Curriculum
• Course Evaluation
• Thank You!
• Q&A Session
  

kider

最近没有。

有需要的可以反馈