The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability.
Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.
- MySQL on the Web
- The MySQL community
- MySQL in the Cloud
- MySQL overview
- MySQL Enterprise Edition
- Initial Configuration
- Starting and Stopping MySQL
- Upgrading MySQL
- Installing MySQL
- Installed Files and Directories
- Redo and Undo Logs
- How MySQL Stores Data
- Tablespaces
- How MySQL Uses Memory
- Architectural Overview
- How MySQL Processes Requests
- How MySQL Transmits Data
- Plug-in Interface
- Launching Multiple Servers on the Same Host
- Server Options, Variable, and the Command Line
- System Variables
- Option Files
- Monitoring MySQL with Performance Schema
- MySQL Enterprise Audit
- Monitoring MySQL with Log Files
- Monitoring User Activity
- MySQL Enterprise Monitor
- Monitoring MySQL with Status Variables
- Configuring Passwords and Account Expiration
- MySQL Privilege System
- Resetting a Forgotten Root Password
- Authentication Plug-Ins
- Grant Tables
- Creating and Modifying User Accounts
- Granting Permissions
- Security Risks
- Secure Connections
- MySQL Enterprise Firewall
- Network Security
- Protecting Against SQL Injections
- Operating System Security
- Password Security
- Troubleshooting
- Identifying the Causes of Server Slowdowns
- Capacity Planning
- Stability
- InnoDB Recovery
- Why Databases Fail
- Working with Indexes
- The EXPLAIN statement
- Identifying Slow Queries
- Index Statistics
- Understanding Backups
- Creating a Backup Strategy
- Backup Techniques
- MySQL Backup Tools
- Raw Backup Methods
- Techniques that use the Binary Log
- Configuring Replication
- Replication Conflicts
- Overview of Replication
- When to Use Replication
- Monitoring Replication
- Troubleshooting Replication
- Replication Threads
- Failover
- MySQL Utilities
- Monitoring Group Replication
- Single-Primary and Multi-Primary Modes
- Overview
- Configuring Group Replication
- Database Administrators
- Database Developers
- Technical Consultant
Suggested Pre-requisite:
- Should be knowledgeable with MySQL data types and executing basic DDL and DML queries using SQL
- Should be knowledgeable with relational database concepts and using the MySQL command-line client
- Should be knowledgeable with Joining Tables
Required Pre-requisites:
- MySQL Fundamentals Ed 1
- MySQL for Developers
Key Participants Benefit
After taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether you use on-premise or MySQL Cloud-based instances, and whether your challenge is complex replication requirements, or highly-tuned transactional systems.
- Define and implement a backup strategy
- Perform physical and logical backups of your data
- Describe MySQL replication and its role in high availability and scalability
- Configure simple and complex replication topologies
- Administer a replication topology
- Install the MySQL server and client programs
- Upgrade MySQL on a running server
- Describe MySQL architecture
- Explain how MySQL processes, stores, and transmits data
- Configure MySQL server and client programs
- Use server logs and other tools monitor database activity
- Create and manage users
- Protect your data from common security risks
- Identify and optimise poorly-performing queries
- Troubleshoot server slowdowns and other common problems
- Gain an understanding of MySQL Cloud
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.
Immediate Feedback on Mastery
Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.
SATV Eligible
Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)
Direct From the Source
MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).
Learn Anywhere Anytime
The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.
Live Hands-on
Labs
Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.
