热门课程：
|
400-882-5311 |
|
-
- 课程详细介绍
-
MySQL5.6forDatabaseAdministrators(OCP)
关键字：MySQL 5.6 for Database Administrators (OCP)|mysql ocp认证费用|mysql ocp考试
学校价格：￥电话咨询 网上优惠价：￥可享团购价 关注度：627人 
总课时：预约咨询 开班日期：学校安排 上课时段：周末班、晚班、平时班 授课学校：杭州博学教育 上课地点：西湖区文三路252号伟星大厦 课程长度：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编号 班级名称 开班日期 教学点 网上优惠价 网上支付 -
- 相关课程推荐
- 相关学校推荐
- 相关资讯推荐
-
电子营业执照
教育资质
全国优秀教育网站
企业信用等级AA级