Course Outline
 

MySQL Architecture

• Understanding the basics of client/server technology and communication protocols used by MySQL
• Clarifying the concepts of SQL parser and storage engine tiers in MySQL
• Detailing the disk space and memory needs for MySQL
• Explaining the process of installation of MySQL

Data Definition

• Describing the terms database, table, data types, constraints, indexes and views
• Illustrating data types used for character columns

Data Manipulation

• Describing SQL constructs for search, add, remove and update of data
• Illustrating the various grouping and aggregate functions in MySQL
• Understanding the concepts of expressions and joining

MySQL Service

• Explaining the various MySQL distributions
• Describing the steps for starting and stopping MySQL server
• Detailing the runtime configuration, log and status files used by MySQL
• Illustrating security-related configuration and INFORMATION_SCHEMA for metadata

Client Programs

• Describing various client programmes and their limitations of MySQL server consisting mysql, mysqladmin, mysqlimport and mysqldump

Locking

• Understanding the concepts of locking
• Describing explicit table and advisory locking in MySQL

Storage Engines

• Describing the concepts of storage engines in MySQL
• Detailing various storage engines of MySQL consisting of InnoDB, merge, innodb, memory, federated, cluster storage and other storage engines

Integrity and Repair

• Explaining the table maintenance operations and using SQL for it.
• Illustrating table repair and enabling auto-repair in MySQL

Backup and Recovery

• Clarifying the concepts of binary and textual backups
• Understanding the usage of log and status files for backup
• Explaining replication, data recovery and mysql cluster for MySQL server

Security

• Explaining the basics of user account management and client access control
• Describing the implementation of file system, operating system, log files, network and federated table security in MySQL
• Detailing stored routines and triggers usage for implementing security measures

Optimization

• Understanding query optimization by explain, show warnings and index caching
• Explaining normalization and storage engine specific optimization for schema optimization in MySQL
• Implementing server optimization by tuning memory parameters and techniques to use query cache and stored routines

Error Handling

• Describing the usage of error log and slow query log for error handling
• Techniques to manage hardware, disk and network issues

Scaling

• Understanding the concepts of replication and multiple server usage of MySQL

Apply for Certification

https://www.vskills.in/certification/Certified-MySQL-DB-Administrator