Kurs: Administering MySQL
Redpill Linpro AS
This 5 day class is for anyone who wants to administer a MySQL Database server. The course explains how MySQL works from the ground up, as well as covering the broader MySQL ecosystem.
You will learn how to:
- Install and configure the server
- Manage user accounts and privileges
- Choose and configure storage engines
- Design, backup, restore and upgrade your databases
- Handle crash recovery and emergency fail over
- Implement database replication and monitoring
Format:
Instructor led course with hands-on lab exercises.
Each student will be provided with an individual computer/workstation
Duration:
5 days
Table of contents (subject to changes):
-
Introduction
-
Installation
-
Client Utilities
-
Architecture
-
Configuration
-
Storage Engines
-
Resource Usage
-
Maintenance
-
Backups
-
Data Types
-
Views
-
Partitioning
-
Programming
-
Security
-
Replication
-
Monitoring
-
Troubleshooting
-
Optimization
-
High Availability
-
Conclusion
Forkunnskaper
Basic SQL knowledge is needed, as well as a mastery of fundamental database concepts. Prior usage of MySQL is recommended, but not required
Målgruppe
This course is both for new DBAs who want to learn all the tricks of the trade, as well as more knowledgeable DBAs who want to extend their skills to master all parts of administering a MySQL server.
Administering MySQL
100% sikkert skjema
Tar ett minutt å fullføre
Hurtig respons
Åpen deltakerdiskusjon om kurset eller emnet
Del gjerne din erfaring eller tanker om dette kurset eller temaet med andre!