MySQL for Database Administrators Ed 4

loading..
(Course eligible for SATVs)

loading..

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

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          OnlineLive   

            Show all

            Connected Classroom   

              Show all

              Connected Classroom   

                Show all

                Connected Classroom   

                  Show all

                  Connected Classroom   

                    Show all

                    Flexible Mentored Learning   

                      Show all

                      Flexible Mentored Learning   

                        Show all

                        Flexible Mentored Learning   

                          Show all

                          Flexible Mentored Learning   

                            Show all

                            Not currently scheduled

                            Fast track the availability of this course.
                            Add to watch list or call 1300 794 006.

                            Need your team upskilled?
                            Request a Quote

                            blah is false
                            top