MySQL Online Training

MySQL is (as of July 2013) the world's second most widely used relational database management system (RDBMS) and most widely used open-source RDBMS. Browse through the contents of the program.

MYSQL Course Contents
Client/Server Overview
Communication Protocols
The SQL Parser and Storage Engine Tiers
How MySQL Uses Disk Space
How MySQL Uses Memory
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
Overview of Administrative Clients
mysql
mysqladmin
mysqlimport
mysqldump
Client Program Limitations
Performance Issues
Choosing Data Types for Character Columns
Locking Concepts
Explicit Table Locking
Advisory Locking
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
Types of Table Maintenance Operations
SQL Statements for Table Maintenance
Client and Utility Programs for Table Maintenance
Repairing InnoDB Tables
Enabling MyISAM Auto-Repair
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
Using Stored Routines and Triggers for Security Purposes
Using Stored Routines to Enhance Performance
User Account Management
Client Access Control
Security Issues
Operating System Security
Filesystem Security
Log Files and Security
Network Security
FEDERATED Table Security
Upgrading the Privilege Tables
Security-Related SQL Mode Values
Identifying Candidates for Query Analysis
Using EXPLAIN to Analyze Queries
Using SHOW WARNINGS for Optimization
MyISAM Index Caching
General Table Optimizations
Normalization
MyISAM-Specific Optimizations
InnoDB-Specific Optimizations
MERGE-Specific Optimizations
MEMORY-Specific Optimizations
Interpreting mysqld Server Information
Measuring Server Load
Tuning Memory Parameters
Using the Query Cache
Sources of Diagnostic Information
Using the Error Log for Diagnostic Purposes
Using The Slow Query Log for Diagnostic Purposes
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
Contact us today at info@techflames.com or call us at +91-9100947004.