MySQL-DBA

Duration: 5 days

Students should have a basic understanding of database concepts

Please find the course objectives below:

Day 1

  • Introduction
  • Describing MySQL
  • Currently Supported Operating Systems
  • Describing Installation of MySQL
  • Installation on windows platform
  • Installation on linux platform
  • 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

Day 2

  • Configuring the MySQL Server
  • MySQL Configuration
  • Dynamic Server Variables
  • Server SQL Modes
  • Log and Status Files

  • MySQL Clients

  • Overview of Administrative Clients

  • Invoking MySQL Client Programs
  • Using the mysql Client
  • The mysqladmin Client

  • Overview of Data Types

  • Data Types

  • Numeric Data Types
  • Character String Data Types
  • Binary String Data Types
  • Temporal Data Types
  • NULLs
  • Column Attributes
  • Understanding queries, joins in mysql
  • Understanding Mysql Datafiles

Day 3

  • 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

Day 4

  • Transactions and Locking

  • Transactions

  • Transaction Control statements
  • Isolation Levels
  • Locking

  • Security and User Management

  • Privileges

  • Access Levels
  • User Account Maintenance
  • Client Access Control
  • Using Secure Connections

  • Table Maintenance

  • Exporting and Importing Data

  • Exporting and Importing Data

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

Day 5

  • 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 restore

  • Backup Tools Overview

  • Making Raw Backups
  • Making Logical (Text) Backups
  • Backup Log and Status Files

  • Introduction to Performance Tuning

  • Using EXPLAIN to Analyze Queries

  • General Table Optimizations
  • Setting and Interpreting MySQL Server Variables
For an onsite course please contact us