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