Jump to content

MySQL Database Administration Online Training|Training- 3092003878


Davidjhon

Recommended Posts

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]

 

MySQL-Database-Administration-Online-Tra

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...