IIRF Online > Development > Database Design & Development > MySQL > Certificate in MySQL DB Administration
Certificate in MySQL DB Administration by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 20+ hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
Curriculum
4 Topics
Client/Server basics and communication protocols
The SQL parser and storage engine tiers
Disk space and memory requirements
Installation
4 Topics
Databases and tables
Data types
Constraints indexes and views
Data types for character columns
3 Topics
Search add remove and update data
Grouping and aggregate functions
Expressions and joining
5 Topics
MySQL distributions
Start and stop MySQL server and runtime configuration
Log and status files
Security-related configuration
INFORMATION_SCHEMA
1 Topic
mysql mysqladmin mysqlimport and mysqldump
2 Topics
Locking overview
Explicit table and advisory locking
2 Topics
MySQL storage engines
InnoDB merge innodb memory federated cluster storage and other storage engines
2 Topics
Table maintenance
Repairing tables and auto-repair
3 Topics
Binary and textual backups
Log and status files
Replication data recovery and mysql cluster
3 Topics
User account management and client access control
File system operating system log files network and federated table security
Using stored routines and triggers
3 Topics
Optimizing queries by explain show warnings and index caching
Normalization and storage engine specific optimization for schema optimization
Server optimization by tuning memory parameters using the query cache and stored routines
2 Topics
Error Log and Slow Query Log
Hardware disk and network issues
2 Topics
Multiple Servers
Replication
Certificate in MySQL DB Administration
Related MySQL Courses
Thank You!
Your review has been submitted successfully.