MySQL for Database Administrators Training Ed 3.1

MySQL for Database Administrators Training Ed 3.1 (MySQL5-DBA)

Introduction:

MySQL for Database Administrators Training Ed 3.1 Course by Example

The MySQL for Database Administrators Training Ed 3.1 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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

Database Administrators
Developer

MySQL for Database Administrators Training Ed 3.1 (MySQL5-DBA)Related Courses:

Duration: 5 days

Class Prerequisites:

Have some experience with relational databases and SQL

Skills Gained:

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 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
Understand data locking in MySQL

Course Content:

Introduction

MySQL Overview, Products, Services
MySQL Services and Support
Supported Operating Services
MySQL Certification Program
Training Curriculum Paths
MySQL Documentation Resources

MySQL Architecture

The client/server model
Communication protocols
The SQL Layer
The Storage Layer
How the server supports storage engines
How MySQL uses memory and disk space
The MySQL plug-in interface

System Administration

Choosing between types of MySQL distributions
Installing the MySQL Server
The MySQL Server installation file structure
Starting and stopping the MySQL server
Upgrading MySQL
Running multiple MySQL servers on a single host

Server Configuration

MySQL server configuration options
System variables
SQL Modes
Available log files
Binary logging
Enterprise Audit

Clients and Tools

Available clients for administrative tasks
MySQL administrative clients
The mysql command-line client
The mysqladmin command-line client
The MySQL Workbench graphical client
MySQL tools
Available APIs (drivers and connectors)

Data Types

Major categories of data types
Meaning of NULL
Column attributes
Character set usage with data types
Choosing an appropriate data type

Obtaining Metadata

Available metadata access methods
Structure of INFORMATION_SCHEMA
Using the available commands to view metadata
Differences between SHOW statements and INFORMATION_SCHEMA tables
The mysqlshow client program
Using INFORMATION_SCHEMA queries to create shell commands and SQL statements

Transactions and Locking

Using transaction control statement to run multiple SQL statements concurrently
The ACID properties of transactions
Transaction isolation levels
Using locking to protect transactions

Storage Engines

Storage engines in MySQL
InnoDB storage engine
InnoDB system and file-per-table tablespaces
NoSQL and the Memcached API
Configuring tablespaces efficiently
Using foreign keys to attain referential integrity
InnoDB locking
Features of available storage engines

Partitioning

Partitioning and its use in MySQL
Reasons for using partitioning
Types of partitioning
Creating partitioned tables
Subpartitioning
Obtaining partition metadata
Modifying partitions to improve performance
Storage Engine Support of Partitioning

User Management

Requirements for user authentication
Using SHOW PROCESSLIST to show which threads are running
Creating, modifying and dropping user accounts
Alternative authentication plugins
Requirements for user authorization
Levels of access privileges for users
Types of privileges
Granting, modifying and revoking user privileges

Security

Recognizing common security risks
Security risks specific to the MySQL installation
Security problems and counter-measures for network, operating system, filesystem and users
Protecting your data
Using SSL for secure MySQL server connections
How SSH enables a secure remote connection to the MySQL server
Finding additional information for common security issues

Table Maintenance

Types of table maintenance operations
SQL statements for table maintenance
Client and utility programs for table maintenance
Maintaining tables for other storage engines

Exporting and Importing Data

Exporting Data
Importing Data

Programming Inside MySQL

Creating and executing Stored Routines
Describing stored routine execution security
Creating and executing triggers
Creating, altering and dropping events
Event execution scheduling

MySQL Backup and Recovery

Backup basics
Types of backup
Backup tools and utilities
Making binary and text backups
Role of log and status files in backups
Data Recovery

Replication

Managing the MySQL Binary Log
MySQL replication threads and files
Using MySQL Utilities for Replication
Designing Complex Replication Topologies
Multi-Master and Circular Replication
Performing a Controlled Switchover
Monitoring and Troubleshooting MySQL Replication
Replication with Global Transaction Identifiers (GTIDs)

Introduction to Performance Tuning

Using EXPLAIN to Analyze Queries
General Table Optimizations
Monitoring status variables that affect performance
Setting and Interpreting MySQL server Variables
Overview of Performance Schema
Tuning the MySQL Server

Conclusion

Course Overview
MySQL Curriculum
Course Evaluation
Thank You!

QA Session

Request More Information

Time Frame: 0-3 Months4-12 Months

Print Friendly, PDF & Email

No Comments Yet.

Leave a comment