MySQL for Database Administrators (D61762GC30)

Cursusbeschrijving Beschikbare data Gedetailleerde cursusinhoud
 

Who Should Attend

  • Database Administrators
  • Developer

Prerequisites

Required Prerequisites

  • Have some experience with relational databases and SQL

Course Objectives

  • Use the INFORMATION_SCHEMA 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 in MySQL
  • Understand the use of the InnoDB storage engine with MySQL
  • Maintain integrity of a MySQL installation
  • Use triggers for administration tasks
  • Understand views
  • Describe introductory performance tuning techniques
  • Perform backup and restore operations
  • Describe the MySQL Architecture
  • Install and Upgrade MySQL

Course Content

The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and 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

Database administrators will learn how new enhancements made available in MySQL will increase performance, scalability, reliability and manageability for their Web, Cloud and embedded application requirements. You will be able to install, configure, maintain and tune databases for a wide variety of workloads and environments.

Setting up the Server and Databases

This course teaches you how to install, configure, maintain, and tune databases for a wide variety of workloads and environments. You will install and configure MySQL, and set appropriate configuration options. You will connect to the server, using both graphical and command-line clients, and create and populate databases.

Maintaining and Securing Data

In this course, you will examine the structure of tables, their columns and data types, and the different ways to check and repair tables. You will program MySQL stored routines, events, and triggers to process data in complex and automated ways. You will partition tables, work with locking and transactions, and explore the key features of InnoDB and other storage engines to understand how data is processed, stored, and retrieved.

Configuring for Performance and High Availability

To help avoid and deal with failures, this course teaches you to tune databases by choosing and setting the most appropriate options, perform logical and physical backups, configure replication between multiple instances, recover from network or hardware failure, or between replicated systems.

Learn by Doing

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.

Certification

This course fulfils the training requirements for the Oracle Certified Professional, MySQL 5 Database Administrator certification.

Duur: 5 dagen

Prijs (excl. BTW):
  • Nederland: 2.210,- €
  • België: 2.210,- €
 
Klik op de plaats & boek onlineBeschikbare data
Nederland
25-08-2014 - 29-08-2014 Utrecht boek direct
03-11-2014 - 07-11-2014 Utrecht boek direct
België
25-08-2014 - 29-08-2014 Brussel boek direct
03-11-2014 - 07-11-2014 Brussel boek direct