MySQL-for-Database-Administrators-Ed-5
免费下载
C/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)
C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)
Avda. París, 26 – 10005 Cáceres (España)
https://www.corenetworks.es/
Tfno.: +34 91 767 10 65 | Mail: formacion@corenetworks.es
MySQL for Database Administrators Ed 5
Duración
Días: 5 Días
Horas: 30 horas
Descripción
The MySQL course for Database Administrators is designed for DBA and other
database professionals. Learn how to configure MySQL Server, configure
replication and security, perform database backups and performance tuning,
and protect MySQL databases.
Objetivos
1. Automate administrative tasks with scheduled events
2. Configure MySQL server options at runtime
3. Configure advanced replication topologies for high availability
4. Describe introductory performance tuning techniques
5. Describe the Architecture of MySQL
6. Evaluate data types and character sets to locate performance issues
7. Install and update MySQL
8. Maintain the integrity of a MySQL installation
9. Perform backup and restore operations
10. Perform MySQL startup and shutdown operations
11. Describe data locking in MySQL
12. Describe using the InnoDB storage engine with MySQL
13. Using Enterprise Audit and Pluggable Authentication
14. Use available tools, including MySQL Workbench
15. Using the INFORMATION_SCHEMA Database to Access Metadata
16. Use triggers for management tasks
C/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)
C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)
Avda. París, 26 – 10005 Cáceres (España)
https://www.corenetworks.es/
Tfno.: +34 91 767 10 65 | Mail: formacion@corenetworks.es
Qué aprenderá
Describe the architecture of MySQL.
Install and update MySQL.
Configure MySQL server settings at runtime.
Evaluate data types and character sets to locate performance issues.
Understand the use of the InnoDB storage engine with MySQL.
Perform backup and restore operations.
A quién va dirigido
Database Administrators
Developer
Pre-requisitos
Experience with relational database concepts
Knowledge of basic SQL statements
Understand how to execute Linux/Unix commands.
Contenido
1. Introduction to MySQL
•
MySQL overview
•
MySQL Enterprise Edition
•
MySQL on the Web
•
MySQL in the Cloud
•
The MySQL community
2. Installing MySQL
•
Installing MySQL
•
Installed Files and Directories
•
Initial Configuration
•
Starting and Stopping MySQL
•
Upgrading MySQL
of 5
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论