授课人：丁雪峰 ORACLE公司MySQL亚太区首席顾问
² 数据库管理员
² 66（课堂培训）+33 学时（实训）及课余技术和面试辅导
培养对象：
具备一定的LINUX基础，想成为一个MYSQL DBA 或者想熟悉MYSQL开发的人群。
培养周期：
授课：66学时； 实训：33学时
培养形式：
理论解析+互联网行业MySQL数据库资深项目总监手把手实验指导+项目经验分享。
技术准备：
具备一定的Linux操作系统知识，能够在Windows平台上 熟练使用vmware等虚拟机软件。
培养目标：
◇ 熟悉SQL语句；
◇ 熟悉一种LINUX或者UNIX系统平台，熟练运用Linux/UNIX进行数据库管理；
◇ 熟练掌握数据库性能快速诊断技术；
◇ 了解应用和硬件基础架构，初步掌握数据库性能的优化与调整；
◇ 了解并掌握一种主流的备份方法；
◇ 快速处理系统突发事件的能力,较强的学习和创新能力，良好的数据库专业沟通能力及团队合作精神；
◇ 通过MySQL官方认证考试
通过培训可以胜任的工作任务：
1、MySQL数据库架构设计与部署、日常运维、监控、数据备份与恢复方案的制定；
2、负责MySQL数据库性能调优及数据库安全；
3、编写、管理数据库规范化文档；
4、完成前瞻性数据库技术与解决方案的研究；
5、提供24H*7的产品环境服务支持；
6、负责MySQL数据库管理维护，监控及性能优化；
7、开发项目支持与优化；
8、研究MYSQL数据库源代码；
9、大型网站社区网站架构数据建模码；
10、后台数据支撑能力，细粒度报表设计；
11、数据仓库设计和实施。
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
京公网安备11010102001479号