The delegate will learn and acquire skills as follows:
- Obtaining metadata
- Configuring the Server
- Administering and tuning a server
- Upgrading a Running Server
- Setting up Character Set Support
- Configuring log files and using them to monitor database activity
- Interpreting error messages
- Locking and transactions
- Using different storage engines
- Table Maintenance
- Implementing a backup strategy
- Performing physical and logical backups of data
- Administering Users and Privileges
- Securing the Server from common security threats
- Identify and Optimise poorly tuned queries
- Tuning Tables and Indexes
- Using the Event Scheduler
- Creating Partitioned Tables
- Replication
- Configure simple and complex replication topologies
- Administer a replication topology
Administer a replication topology Course Objectives Course Objectives