MySQL Database Administration Online Training|Training- 3092003878

[Davidjhon]

We Provide Online Training |Training|   MySQL Database Administration  with Real Time Experts

Course Outline:

 

ourse Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
• Introduction
• Client Program Limitations
• mysql
• MySQL Admin
• Exercises: Using Client Programs

The Information_Schema Database

• What is Metadata?
• The mysqlshow Utility
• The SHOW and DESCRIBE Commands
• The Information_Schema Database
• Exercises: Obtaining Information about MySQL

Mysql Administrator

• Installation
• Connecting
• Server Information
• Service Control
• User Administration
• Privileges
• Health
• Backup and Restore
• Catalogs
• Exercises: Using the MySQL Administrator Tool

Installing, Configuring, Starting And Stopping

• MySQL Distributions
• Installing on Windows
• Installing on Linux and UNIX
• Starting and Stopping on Windows
• Starting and Stopping on UNIX/Linux
• Configuration
• Log and Status Files
• The Default SQL Mode
• Time Zone Tables
• Some Security Issues
• Upgrading
• Exercises: Installing, configuring, stopping and starting

Interpreting Error And Diagnostic Information

• MySQL Error Messages
• The SHOW Statement
• SQL Modes
• The PERROR Utility
• The Log
• The Error Log
• The Slow Query Log
• Exercises: Interpreting Error and Diagnostic Information

Mysql Architecture

• Client/Server Overview
• Communication Protocols
• The SQL Parser and Storage Engine Tiers
• How MySQL Uses Disk Space
• How MYSQL Uses Memory
• Exercises: Examining the Architecture

 

You can reach us @   3092003878 or Email us: [email protected]