Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Overview of MySQL products and service offerings
- Available support channels and service levels
- Compatible operating systems
- Structured training pathways
- Reference documentation and resources
MySQL Architecture
- Client/server architecture fundamentals
- Communication protocol specifications
- SQL processing layer
- Storage layer functionality
- Integration with storage engines
- Memory management and disk resource utilization
- Plug-in interface capabilities
System Administration
- Evaluating MySQL distribution options
- Server installation procedures
- Post-installation directory structure
- Server startup and shutdown protocols
- Version upgrade procedures
- Deploying multiple server instances on a single host
Server Configuration
- Server configuration parameters
- System variable management
- SQL mode configurations
- Log file types and management
- Binary log configuration
Clients and Tools
- Administrative client utilities
- Standard administrative tools
- Command-line interface (mysql)
- Administrative command-line tool (mysqladmin)
- MySQL Workbench graphical interface
- Supplementary utility suite
- Application programming interfaces (APIs), drivers, and connectors
Data Types
- Primary data type classifications
- Definition and handling of NULL values
- Column attribute specifications
- Character set integration
- Selection of appropriate data types for operational requirements
Obtaining Metadata
- Methods for metadata retrieval
- INFORMATION_SCHEMA structure
- Metadata visualization commands
- Comparison of SHOW statements and INFORMATION_SCHEMA tables
- mysqlshow utility usage
- Generating shell commands and SQL statements via INFORMATION_SCHEMA queries
Transactions and Locking
- Transaction control statements for concurrent operations
- ACID transaction properties
- Transaction isolation levels
- Locking mechanisms for transaction integrity
Storage Engines
- MySQL storage engine framework
- InnoDB storage engine specifications
- InnoDB system and file-per-table tablespaces
- NoSQL capabilities and Memcached API integration
- Efficient tablespace configuration
- Referential integrity via foreign keys
- InnoDB locking mechanisms
- Feature comparison of available storage engines
Partitioning
- Partitioning concepts and applications
- Operational benefits of partitioning
- Partitioning methodologies
- Creation of partitioned tables
- Subpartitioning strategies
- Retrieval of partition metadata
- Partition modifications for performance optimization
- Storage engine compatibility with partitioning
User Management
- Authentication requirements
- Thread monitoring via SHOW PROCESSLIST
- Account lifecycle management (creation, modification, deletion)
- Alternative authentication plugins
- Authorization requirements
- Privilege hierarchy and access levels
- Privilege classification
- Privilege management (granting, modification, revocation)
Security
- Identification of common security vulnerabilities
- Installation-specific security risks
- Mitigation strategies for network, OS, filesystem, and user-related threats
- Data protection measures
- SSL implementation for secure server connections
- SSH for secure remote administration
- Resources for addressing security incidents
Table Maintenance
- Classification of maintenance operations
- SQL maintenance statements
- Utility programs for maintenance tasks
- Maintenance procedures for specific storage engines
- Data export and import procedures
Programming Inside MySQL
- Development and execution of stored routines
- Security implications of routine execution
- Development and execution of triggers
- Event management (creation, alteration, deletion)
- Scheduling event execution
MySQL Backup and Recovery
- Backup fundamentals
- Backup classification
- Backup tools and utilities
- Binary and text backup methods
- Utilization of log and status files in backup strategies
- Data recovery procedures
Replication
- Binary log management
- Replication threads and file structures
- Establishing a replication environment
- Complex replication topology design
- Multi-master and circular replication configurations
- Controlled switchover procedures
- Replication monitoring and troubleshooting
- Replication using Global Transaction Identifiers (GTIDs)
Introduction to Performance Tuning
- Query analysis using EXPLAIN
- General table optimization techniques
- Monitoring performance-affecting status variables
- Configuration and interpretation of server variables
- Performance Schema overview
Conclusion
Q&A Session
Requirements
**Prerequisites**
No formal prerequisites are required for enrollment. However, candidates with a foundational understanding of database management principles may find the curriculum more accessible.
**Target Audience**
This program is designed for information technology professionals seeking to establish careers as Database Administrators (DBAs) or database support specialists. The training focuses on administering MySQL databases across Linux and Windows operating system environments.
**Instructional Format**
The course structure consists of 40% theoretical instruction and lectures, complemented by 60% practical, hands-on laboratory exercises to reinforce technical skills. This balanced approach ensures that participants gain the operational competence necessary for effective implementation in government IT infrastructure contexts for government.
28 Hours
Testimonials (1)
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
