MYSQL DBA Online Training

MYSQL DBA Course Content

    Introduction

  • Describing MySQL
  • Listing MySQL Products and Professional Services
  • Describing MySQL Enterprise Subscription
  • Currently Supported Operating Systems
  • Describing MySQL Certification Program
  • Listing Available MySQL Courses
  • Describing Installation of MySQL
  • Describing Installation of world Database
  • MySQL Architecture

  • Client/Server Architecture
  • MySQL Architecture Overview
  • How MySQL Uses Disk Space
  • How MySQL Uses Memory
  • The MySQL Plug-In Interface
  • The MySQL Server

  • Types of MySQL Distributions
  • Starting and Stopping MySQL on Windows
  • Starting and Stopping MySQL on Linux
  • Upgrading MySQL
  • Managing Multiple Servers
  • Configuring the MySQL Server

  • MySQL Configuration
  • Dynamic Server Variables
  • Server SQL Modes
  • Log and Status Files
  • Binary Logging
  • MySQL Clients

  • Overview of Administrative Clients
  • Invoking MySQL Client Programs
  • Using the mysql Client
  • The mysqladmin Client
  • MySQL Connectors
  • Third-Party APIs
  • Overview of Data Types

  • Data Types
  • Numeric Data Types
  • Character String Data Types
  • Binary String Data Types
  • Temporal Data Types
  • NULLs
  • Column Attributes
  • Metadata

  • Metadata Access Methods
  • The INFORMATION_SCHEMA Database/Schema
  • Using SHOW and DESCRIBE
  • The mysqlshow Command
  • Storage Engines

  • Storage Engine Overview
  • MyISAM, InnoDB, and MEMORY Storage Engines
  • Other Storage Engines
  • Choosing Appropriate Storage Engines
  • Using Multiple Storage Engines
  • Storage Engine Comparison Chart
  • Partitioning

  • Overview of Partitioning and reasons for using Partitioning
  • Creating a Partitioned Table
  • Obtaining Partition Information
  • Modifying and Removing Partitions
  • Partition Modification Performance Effects
  • Partition Pruning
  • Storage Engine Partition Information
  • Partitioning and Locking and Limitations
  • Transactions and Locking

  • Transactions
  • Transaction Control statements
  • Isolation Levels
  • Locking
  • Security and User Management

  • Security Risks
  • Security Measures
  • Privileges
  • Access Levels, including:
    • - User Accounts,
    • – Databases,
    • – Tables,
    • – Columns,
    • - Stored Routines
  • User Account Maintenance
  • Client Access Control
  • Using Secure Connections
  • Table Maintenance

  • Table Maintenance
  • SQL Statements for maintenance operations
  • Client and Utility Programs for table maintenance
  • Table Maintenance per Storage Engine
  • Exporting and Importing Data

  • Exporting and Importing Data
  • Exporting and Importing Data Using SQL
  • Import Data with the SQL scripts
  • Programming with MySQL

  • Defining, Executing and Examining Stored Routines
  • Stored Routines and Execution Security
  • Defining, Creating, and Deleting Triggers
  • Trigger Restrictions and Privileges
  • Defining Events
  • Schedule Events
  • DBA's Use of MySQL Programming
  • Backup Stored Routines
  • Views

  • What is a view?
  • Creating Views
  • Updatable Views
  • Managing Views
  • Backup and Recovery

  • Planning for Recovery Backup
  • Backup Tools Overview
  • Making Raw Backups
  • Making Logical (Text) Backups
  • Backup Log and Status Files
  • Replication as an Aid to Backup
  • Backup Method Comparison
  • Data Recovery
  • Introduction to Performance Tuning

  • Using EXPLAIN to Analyze Queries
  • General Table Optimizations
  • Setting and Interpreting MySQL Server Variables
  • Introduction to High Availability

  • MySQL Replication

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

" The MySQL DBA training is good thanks for the excellent work." - Soujanya (MySQL DBA)