Requisitos
- Having some experience with relational databases and SQL
Descripción del curso Mysql For Database Administrators:
MySQL for data managers training is designed for database administrators and other professional’s databases. Be taught how to install and configure the MySQL server, configure replication and security, backup and database performance tuning and protect MySQL databases.
Learn To:
- Describe the MySQL Architecture.
- Install and upgrade MySQL.
- Configure MySQL server options at runtime.
- Evaluate data types and character sets for performance issues.
- Understand the use of the InnoDB storage engine with MySQL.
- Perform backup and restore operations.
Benefits to You:
After taking this course, you’ll have a greater understanding of new enhancements made available in MySQL 5.6 to improve performance, scalability, reliability and manageability for your Web, Cloud and embedded application requirements.
Objetivos:
- Describe the MySQL Architecture
- Install and Upgrade MySQL
- Use the INFORMATION_SCHEMA database to access metadata
- 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
- Configure advanced replication topologies for high availability
- Describe introductory performance tuning techniques
- Perform backup and restore operations
- Automate administrative tasks with scheduled events
Temario:
- Módulo 1: Introduction
- Módulo 2: MySQL Architecture
- Módulo 3: System Administration
- Módulo 4: Server Configuration
- Módulo 5: Clients and Tools
- Módulo 6: Data Types
- Módulo 7: Obtaining Metadata
- Módulo 8: Transactions and Locking
- Módulo 9: Storage Engines
- Módulo 10: Partitioning
- Módulo 11: User Management
- Módulo 12: Security
- Módulo 13: Table Maintenance
- Módulo 14: Exporting and Importing Data
- Módulo 15: Programming Inside MySQL
- Módulo 16: MySQL Backup and Recovery
- Módulo 17: Replication
- Módulo 18: Introduction to Performance Tuning
- Módulo 19: Conclusion
