温馨提示

1、列表网提醒您:在交易前请仔细核实商家真实资质!如发现非法商家,欢迎广大网民举报,举报电话:4000-999-800。

2、该信息由列表网网友发布,其真实性及合法性由发布人负责,列表网仅引用以供用户参考,详情请阅读列表网免责条款。

3、在签订合同或相关协议之前,任何要求预付定金、汇款等方式均存在风险,谨防上当受骗!

详情描述

MySQL数据库管理员(OCP)

课程长度 5天30小时

培训价格:技术培训:5000元人(含教材)

认证培训:7500元人(含电子教材+认证考试)

认证科目 课程描述:The MySQL for Database Administrators course is the foundation

course for database administrators and developers who want to

use this powerful database. In this course you will learn how to

secure users privileges, set resource limitations, and access

controls. In addition, you will learn multiple new 5.0 features such

as creating and using Stored Procedures, Triggers and Views.

学员基础:Attend the MySQL for Beginners course or some experience with

Relational Databases and SQL.

课程目标:Install and Upgrade MySQL 5.0 for the most common operating

systems

Utilize the MySQL Administrator Graphical User Interface (GUI)

to managea MySQL server

Use the INFORMATIONSCHEMA database to access metadata

Perform the MySQL start and shutdown operations

Configure MySQL server options at runtime

Evaluate data types and character sets for performance issues

Understand data locking concepts and the different levels of

locking in MySQL

Differentiate between the multiple storage engines available in

MySQL

Perform backup and restore operations utilizing multiple MySQL

tools

Maintain integrity of a MySQL installation utilizing security

Use stored routines and triggers for administration tasks

Manage, apply and understand the reason for using views

Improve performance through query optimization

Optimize Schemas (Databases) utilizing multiple techniques

Utilize MySQL monitoring tools to improve server performance

Compare multiple environment options to improve server

performance