Hakkında
This Course of Database Administrators course imparts DBAs and other database professionals in what way to make the most of their organization savings in MySQL and about the assistances of using the MySQL Cloud Service. Acquire to configure the MySQL Server, set up repetition and security, perform database backups, optimize query performance, and confirm high obtainability. Course Objectives: Install and configure MySQL Server and client programs. Recognize the key components of the MySQL architecture. Protect our server. Troubleshoot server slowdowns and other issues. Progress query performance. Configure and administer a variability of replication topologies. Comprehend the benefits of MySQL Cloud.
Önkoşullar
Should be knowlegeable with Joining tables
Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL
Should be knowlegeable with relational database concepts and using the mysql command-line client
MySQL Fundamentals Ed 1
Kurs Süresi
- Instructor-led training: 5 days with hands-on lab practice
- Virtual instructor-led training: 5 days of web-based classes with hands-on lab practice
- E-learning: Equivalent of 5 days of instruction with hands-on lab practice
Kurs Hedefleri
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
Ders İçeriği
Introduction to MySQL
MySQL overview
MySQL Enterprise Edition
MySQL on the Web
MySQL in the Cloud
The MySQL community
Installing MySQL
Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL
Upgrading MySQL
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
Configuring MySQL
Server Options, Variables, and the Command Line
Option Files
System Variables
Launching Multiple Servers on the Same Host
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
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
MySQL Security
Security Risks
Network Security
Secure Connections
Password Security
Operating System Security
Protecting Against SQL Injections
MySQL Enterprise Firewall
Maintaining a Stable System
Stability
Why Databases Fail
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery
Optimizing Query Performance
Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics
Backup Strategies
Understanding Backups
Backup Techniques
Creating a Backup Strategy
Performing Backups
MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log
Configuring a Replication Topology
Overview of Replication
Replication Conflicts
When to Use Replication
Configuring Replication
Administering a Replication Topology
Failover
MySQL Utilities
Replication Threads
Monitoring Replication
Group Replication
Overview
Single-Primary and Multi-Primary Modes
Configuring Group Replication
Monitoring Group Replication
Kimler Katılmalı
Database Administrators
Database Developers
Technical Consultant
Troubleshooting Replication
