课程长度：5天/30小时
　　课程描述：
　　This MySQL for Developers training teaches developers how to plan, design and implement applications using MySQL. Expert Oracle University instructors will teach you through realistic examples, interactive instruction and hands-on exercises using Java and PHP languages.
　　Learn To:
　　·Use client programs and options.
　　·Access the database from program code.
　　·Build "NoSQL" applications.
　　·Write effective queries and stored routines.
　　·Inspect database metadata.
　　·Respond to database events with triggers.
　　·Handle errors and exceptions.
　　·Optimize SQL statements.
　　学员根底：
　　Attend the MySQL for Beginners course or some experience with Relational Databases and SQL.
　　课程目标：
　　·Use the INFORMATION_SCHEMA database to access metadata
　　·Configure advanced replication topologies for high availability
　　·Describe introductory performance tuning techniques
　　·Perform backup and restore operations
　　·Automate administrative tasks with scheduled events
　　·Describe the MySQL Architecture
　　·Install and Upgrade MySQL
　　·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
　　训练内容：
　　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
　　·Enterprise Audit
　　Clients and Tools
　　·Available clients for administrative tasks
　　·MySQL administrative clients
　　·The mysql command-line client
　　·The mysqladmin command-line client

培训世界 杭州博学教育体验课 免费预约