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 |
Techflames is an online training hub where we provide experienced tutors on any technology. We serve all the major time zones be it USA, UK, Canada, Australia, New Zealand, India, Saudi, Dubai..
