LOGO For Immediate Assistance Call 855-211-9361

Enterprise

MySQL for DBAs

Price: $2,495.00

Call for availability 855-211-9361

This hands-on MySQL training class for DBAs will teach you how to properly install MySQL and create and execute Backup Strategies. You will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn to use the new enterprise features of MySQL 5.0 such as creating and using Stored Procedures, Triggers and Views.

Although this course is not a Certification Exam Prep “bootcamp”, if you have sufficient hands-on experience working with MySQL, this course will prepare you for the MySQL 5.0 Database Administrator Certification Exams.

Course Overview

By the end of the class students will be able to:

  • Perform common Database Administration tasks
  • Utilize the MySQL Administrator GUI to manage a MySQL server
  • add as many list items as you need
  • remove any list items you don't use
  • Install and Upgrade MySQL 5.0 for the most common operating systems
  • Perform the MySQL start and shutdown operations and configure MySQL server options at runtime
  • Activate and manage numerous server logs
  • Evaluate data types and character sets for performance issues
  • Understand data locking concepts and the different levels of locking in MySQL
  • Create, Maintain and Manage MySQL tables
  • Perform backup and restore operations utilizing multiple MySQL tools
  • Manage user maintenance and access to a MySQL Server
  • Maintain integrity of a MySQL installation utilizing security protocols
  • Use stored routines and triggers for administration tasks
  • Manage, apply and understand the reason for using views
  • Improve performance through query optimization
  • Optimize Schemas (Databases) utilizing multiple techniques
  • Utilize MySQL monitoring tools to improve server performance
  • Compare multiple environment options to improve server performance
  • Scale MySQL operations up

Prerequisites

800 PB Tech Capstone: Fundamentals of Relational Databases, or basic MySQL beginner level training, or experience with Relational Databases and SQL.

Course Outline

  • MySQL Architecture

    • Client/Server Overview
    • Communication Protocols
    • The SQL Parser and Storage Engine Tiers
    • How MySQL Uses Disk Space
    • How MySQL Uses Memory
  • Starting, Stopping, and Configuring MySQL

    • Types of MySQL Distributions
    • Starting and Stopping MySQL Server on Windows
    • Starting and Stopping MySQL Server on Unix
    • Runtime MySQL Configuration
    • Log and Status Files
    • Loading Time Zone Tables
    • Security-Related Configuration
    • Setting the Default SQL Mode
    • Upgrading MySQL
  • Client Programs for DBA Work

    • Overview of Administrative Clients
    • mysql
    • mysqladmin
    • mysqlimport
    • mysqldump
    • Client Program Limitations
  • Character Set Support

    • Performance Issues
    • Choosing Data Types for Character Columns
  • Locking

    • Locking Concepts
    • Explicit Table Locking
    • Advisory Locking
  • Storage Engines

    • MySQL Storage Engines
    • The MyISAM Engine
    • The MERGE Engine
    • The InnoDB Engine
    • The MEMORY Engine
    • The FEDERATED Engine
    • The Cluster Storage Engine
    • Other Storage Engines
  • Data (Table) Maintenance

    • Types of Table Maintenance Operations
    • SQL Statements for Table Maintenance
    • Client and Utility Programs for Table Maintenance
    • Repairing InnoDB Tables
    • Enabling MyISAM Auto-Repair
  • The INFORMATION_SCHEMA Database

    • INFORMATION_SCHEMA Access Syntax
    • INFORMATION_SCHEMA Versus SHOW
    • Limitations of INFORMATION_SCHEMA
  • Data Backup and Recovery Methods

    • Introduction
    • Binary Versus Textual Backups
    • Making Binary Backups
    • Making Text Backups
    • Backing Up Log and Status Files
    • Replication as an Aid to Backup
    • MySQL Cluster as Disaster Prevention
    • Data Recovery
  • Stored Routines

    • Using Stored Routines and Triggers for Security Purposes
    • Using Stored Routines to Enhance Performance
  • User Management

    • User Account Management
    • Client Access Control
  • Securing the Server

    • Security Issues
    • Operating System Security
    • Filesystem Security
    • Log Files and Security
    • Network Security
    • FEDERATED Table Security
  • Upgrade-Related Security Issues

    • Upgrading the Privilege Tables
    • Security-Related SQL Mode Values
  • Optimizing Queries

    • Identifying Candidates for Query Analysis
    • Using EXPLAIN to Analyze Queries
    • Using SHOW WARNINGS for Optimization
    • MyISAM Index Caching
  • Optimizing Schemas

    • General Table Optimizations
    • Normalization
    • MyISAM-Specific Optimizations
    • InnoDB-Specific Optimizations
    • MERGE-Specific Optimizations
    • MEMORY-Specific Optimizations
  • Optimizing the Server

    • Interpreting mysqld Server Information
    • Measuring Server Load
    • Tuning Memory Parameters Using the Query Cache
  • Interpreting Error Messages

    • Sources of Diagnostic Information
    • Using the Error Log for Diagnostic Purposes
    • Using The Slow Query Log for Diagnostic Purposes
  • Optimizing the Environment

    • Choosing Hardware for MySQL Use
    • Configuring Disks for MySQL Use
    • Network Issues
    • Optimizing the Operating System for MySQL Use
  • Scaling MySQL

    • Using Multiple Servers
    • Replication