MySQL

CFR-210-1 : MySQL for Database Administrators Ed 4

Course Duration

2 Days

Delivery

ILT VILT

Overview

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.

Learn To:

Install and configure MySQL Server and client programs.
Recognize the key components of the MySQL architecture.
Secure your server.
Troubleshoot server slowdowns and other issues.
Improve query performance.
Configure and administer a variety of replication topologies.
Understand the benefits of MySQL Cloud.

What You'll Learn

Upon completing this course, the learner will be able to meet these overall objectives:

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 to monitor database activity
Create and manage users
Protect your data from common security risks
Identify and optimize poorly-performing queries
Troubleshoot server slowdowns and other common problems
Gain an understanding of MySQL Cloud

Who Should Attend

Database Administrators
Database Developers
Technical Consultant

Prerequisites

Should be knowlegeable with relational database concepts and using the mysql command-line client
Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL
Should be knowlegeable with Joining tables
MySQL Fundamentals Ed 1

Suggested Prerequisites:

MySQL for Developers

Learning Journey

Coming Soon...

Module 1: Introduction to MySQL

MySQL overview
MySQL Enterprise Edition
MySQL on the Web
MySQL in the Cloud
The MySQL community

Module 2: Installing MySQL

Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL
Upgrading MySQL

Module 3: MySQL Architecture

Architectural Overview
How MySQL Transmits Data
How MySQL Processes Requests
How MySQL Stores Data
Tablespaces
Redo and Undo Logs
How MySQL Uses Memory
Plug-in Interface

Module 4: Configuring MySQL

Server Options, Variables, and the Command Line
Option Files
System Variables
Launching Multiple Servers on the Same Host

Module 5: Monitoring MySQL

Monitoring MySQL with Log Files
Monitoring MySQL with Status Variables
Monitoring MySQL with Performance Schema
MySQL Enterprise Audit
MySQL Enterprise Monitor
Monitoring User Activity

Module 6: User Management

MySQL Privilege System
Creating and Modifying User Accounts
Configuring Passwords and Account Expiration
Authentication Plug-Ins
Granting Permissions
Grant Tables
Resetting a Forgotten Root Password

Module 7: MySQL Security

Security Risks
Network Security
Secure Connections
Password Security
Operating System Security
Protecting Against SQL Injections
MySQL Enterprise Firewall

Module 8: Maintaining a Stable System

Stability
Why Databases Fail
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery

Module 9: Optimizing Query Performance

Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics

Module 10: Backup Strategies

Understanding Backups
Backup Techniques
Creating a Backup Strategy

Module 11: Performing Backups

MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log

Module 12: Configuring a Replication Topology

Overview of Replication
Replication Conflicts
When to Use Replication
Configuring Replication

Module 13: Administering a Replication Topology

Failover
MySQL Utilities
Replication Threads
Monitoring Replication
Troubleshooting Replication

Module 12: Group Replication

Overview
Single-Primary and Multi-Primary Modes
Configuring Group Replication
Monitoring Group Replication

Module 13: Conclusion

Course Overview
MySQL Curriculum
Course Evaluation
Thank You!
Q&A Session

Instructors

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)

10 Courses

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)

10 Courses

This course is not associated with any Certification.

Frequently Asked Questions (FAQs)

Why get Oracle certified?

Oracle certifications are globally recognized credentials that validate your expertise in Oracle technologies and solutions.
Whether your focus is on database administration, cloud infrastructure, Java development, or other Oracle products, these certifications demonstrate your skills and knowledge to employers, enhancing your career prospects and earning potential.
Oracle-certified professionals are highly sought after in the IT industry for their ability to design, implement, and manage complex Oracle environments.
What to expect for the examination?

Oracle certification exams assess your knowledge and skills in specific Oracle technologies and products.
Exams typically consist of multiple-choice questions, and some may include performance-based questions or simulations that test your ability to apply your knowledge in real-world scenarios.
Note: Certification requirements and policies may be updated by Oracle from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is Oracle certification valid for?

The validity period of Oracle certifications varies depending on the specific certification:
Cloud Application Certifications: Valid for 18 months from the date of passing the exam. To maintain your credential, you must take the Delta version of the exam before the 18 months expire.
Oracle Cloud Infrastructure (OCI) Certifications: OCI certification credentials are now valid for 2 years (previously 18 months), enabling users to learn and certify on multiple OCI technologies.
Oracle Database Certifications: If you hold a retiring Oracle Database credential that requires recertification, you must upgrade to a current version within twelve (12) months following retirement to keep your credential in active status.
Note: Certification requirements and policies may be updated by Oracle from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By Oracle

Browse All Courses

Oracle Database 18c

CFR-210-1 : MySQL for Database Administrators Ed 4

What You'll Learn

Who Should Attend

Prerequisites

Learning Journey

Instructors

Frequently Asked Questions (FAQs)

Why get Oracle certified?

What to expect for the examination?

How long is Oracle certification valid for?

Why take this course with Trainocate?

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By Oracle

Oracle Database 18c: Administration Workshop

Java Performance Tuning and Optimization

Oracle Application Express Workshop I Ed 2

Ready to Take Your Business from Great to Awesome?

Request More Information