Duration
5 days
1. Introduction
- MySQL Product Community vs Enterprise
- MySQL Services and Support
- MySQL Resources
- MySQL Certification Program
- 2. MySQL Architecture
- The client/server model
- Communication protocols
- The SQL Layer
- The Storage Layer
- How the server supports storage engines
- How MySQL uses memory and disk space
- The MySQL plug-in interface
- 3. MySQL System Administration and Configuration
- Choosing between types of MySQL distributions
- Installing the MySQL Server
- The MySQL Server installation file structure
- System variables
- Starting and stopping the MySQL server
- 3. MySQL Clients
- Available clients for administrative tasks
- MySQL administrative clients
- The mysql command-line client
- The mysqladmin command-line client
- The MySQL Workbench graphical client
- MySQL tools
Day 2
- 4. Manipulating Table Data
- The INSERT Statement
- The DELETE Statement
- The UPDATE Statement
- The TRUNCATE TABLE Statement
- 5. Database
- Database Properties
- Good Design Practices
- Creating Databases
- Altering Databases
- Dropping Databases
- 6. Overview of Data Types
- Numeric Data Types
- Character String Data Types
- Binary String Data Types
- Temporal Data Types
- Spatial Data Types
- NULLs
- 7. Obtaining Metadata
- Available metadata access methods
- Structure of INFORMATION_SCHEMA
- Using the available commands to view metadata
- Differences between SHOW statements and INFORMATION_SCHEMA tables
- The mysqlshow client program
- Using INFORMATION_SCHEMA queries to create shell commands and SQL statements
Day 3
- 8. Storage Engines
- Storage engines in MySQL
- InnoDB storage engine
- InnoDB system and file-per-table tablespaces
- Configuring tablespaces efficiently
- Using foreign keys to attain referential integrity
- InnoDB locking
- Features of available storage engines
- 9. Partitioning
- Partitioning and its use in MySQL
- Reasons for using partitioning
- Types of partitioning
- Creating partitioned tables
- Subpartitioning
- Obtaining partition metadata
- Modifying partitions to improve performance
- Storage Engine Support of Partitioning
- 10. Security and User Management
- Requirements for user authentication
- Using SHOW PROCESSLIST to show which threads are running
- Creating, modifying and dropping user accounts
- Alternative authentication plugins
- Requirements for user authorization
- Levels of access privileges for users
- Types of privileges
- Granting, modifying and revoking user privileges
Day 4
- 11. Table Maintenance
- Types of table maintenance operations
- SQL statements for table maintenance
- Client and utility programs for table maintenance
- Maintaining tables for other storage engines
- 12. Exporting and Importing Data
- Exporting Data
- Importing Data
- 13. Backup and Recovery
- Backup basics
- Types of backup
- Backup tools and utilities
- Making binary and text backups
- Role of log and status files in backups
- Data Recovery
Day 5
- 14. Introduction to Performance Tuning
- Using EXPLAIN to Analyze Queries
- General Table Optimizations
- Monitoring status variables that affect performance
- Setting and Interpreting MySQL server Variables
- Overview of Performance Schema
- 15. Introduction to High Availability (MySLQ Replication)
- Managing the MySQL Binary Log
- MySQL replication threads and files
- Setting up a MySQL Replication Environment
- Designing Complex Replication Topologies
- Multi-Master and Circular Replication
- Performing a Controlled Switchover
- Monitoring and Troubleshooting MySQL Replication
- Replication with Global Transaction Identifiers (GTIDs)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.