MySQL for Database Administrators

Duration: 5 Days

What you will learn

The MySQL for Database Administrators course is for MySQL DBAs and other professionals who want to install and optimize MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

Learn To:

  • Install and configure the MySQL server.
  • Secure users and data.
  • Understand the use of the InnoDB storage engine with MySQL.
  • Configure privileges and access controls.
  • Work with stored procedures and triggers.
  • Plan for disaster recovery.
  • Configure the server for performance and high availability.

Benefits to You

After taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether your application uses complex queries or the NoSQL API, and whether your preferred challenge is replicated servers or highly-tuned transactional systems.

Engage in Hands-On Practices

Extensive hands-on practices guide you through each concept. You will install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more. Explore real-world problems and discover best practices as you work with the tools and techniques used by professional MySQL database administrators.


Database Administrators

Related Training

Required Prerequisites
Have some experience with relational databases and SQL
MySQL for Beginners Ed 2

Course Objectives

  • 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
  • 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

Course Topics

  • Introduction
  • MySQL Architecture
  • System Administration
  • Server Configuration
  • Clients and Tools
  • Data Types
  • Obtaining Metadata
  • Transactions and Locking
  • Storage Engines
  • Partitioning
  • User Management
  • Security
  • Table Maintenance
  • Exporting and Importing Data
  • Programming Inside MySQL
  • MySQL Backup and Recovery
  • Replication
  • Introduction to Performance Tuning
  • Conclusion
Gostaríamos muito de falar com você! Clique aqui!
#COMPARTILHE nossos cursos

Rua Emiliano Perneta, 680 - 9º Andar
Centro - Curitiba - Paraná - 80420-080
Fones: Curitiba - 3204-1999
Demais localidades - 4007-2186