Search for Training

MySQL DBA

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on MySQL DBA which gives you the opportunity to interact with a MySQL DBA instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 8 + 6? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234


Our Initiatives

ExpertsCertify - Skill Assessment And Tests
AreuCertified - Certification Training
Xpertised IT Solutions - Custom Application Development
Xpertised Learning - Redefine Skills

Subscribe to our weekly newsletter

Batch Details
  Request a Callback
Call us at: +91 7259222234