Home » Oracle » OM-DA-E51: MySQL for Database Administrators Ed 5
OM-DA-E51: MySQL for Database Administrators Ed 5
Oracle MySQL Training and Certification.
MySQL is the world’s most popular open source database. Whether you’re a beginner or an experienced user, a MySQL database administrator, MySQL developer, or a MySQL security administrator, MySQL certification and training helps you develop deeper knowledge of relational databases so you can manage your MySQL applications more efficiently.
Home » Oracle » OM-DA-E51: MySQL for Database Administrators Ed 5
OM-DA-E51: MySQL for Database Administrators Ed 5
Oracle MySQL Training and Certification.
MySQL is the world’s most popular open source database. Whether you’re a beginner or an experienced user, a MySQL database administrator, MySQL developer, or a MySQL security administrator, MySQL certification and training helps you develop deeper knowledge of relational databases so you can manage your MySQL applications more efficiently.
The OM-DA-E51: MySQL for Database Administrators Ed 5 training enables DBAs and other database professionals to maximize their organization’s investment in MySQL. Learn to configure the MySQL Server, set up replication and security, perform database backups and recoveries, optimize query performance, and configure for high availability.
Install and configure MySQL Server and client programs
Recognize the key components of the MySQL architecture
Manage user accounts and secure your server
Troubleshoot server slowdowns and other issues
Backup and recover MySQL database
Configure and administer a variety of replication topologies
Skills Covered
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 and roles
Protect your data from common security risks
Troubleshoot server slowdowns and other common problems
Identify and optimize poorly performing queries
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
Configure and administer InnoDB Cluster
Who Should Attend
Cloud Administrators
Database Administrators
Database Designers
Web Administrators
Course Curriculum
Prerequisites
Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands
Objectives 1-2
Course Goals 1-3
Course Lesson Map 1-5
Introductions 1-6
Classroom Environment 1-7
MySQL Powers the Web 1-8
MySQL Market Share: DB-Engines 2019 1-9
MySQL Enterprise Edition 1-10
Oracle Premier Support for MySQL 1-11
MySQL and Oracle Integration 1-12
MySQL Websites 1-13
Community Resources 1-14
Oracle University: MySQL Training 1-15
MySQL Certification 1-16
Summary 1-17
Practices 1-18
Objectives 2-2
Topics 2-3
Installation Sequence 2-4
Installing MySQL from Downloaded Packages 2-5
MySQL RPM Installation Files for Linux 2-6
MySQL RPM Installation Process 2-7
MySQL DEB Installation 2-8
Linux Distribution–Specific Repositories 2-9
Installing MySQL by Using a Package Manager 2-10
Adding a Yum Repository 2-11
Configuring Yum Repository Versions 2-12
Adding an APT Repository 2-13
Configuring Repository Versions 2-14
Manually Configuring the APT Repositories 2-15
Installing MySQL on Windows 2-16
Installing on Windows: MySQL Installer 2-17
Installing on Windows: Selecting Products and Features 2-18
Installing on Windows: Product Configuration 2-19
Installing MySQL as a Windows Service 2-20
Installing MySQL from Source 2-21
Installing MySQL from Binary Archive 2-22
Deploying MySQL Server with Docker 2-25
Quiz 2-27
Topics 2-28
Linux MySQL Server Installation Directories 2-29
Windows MySQL Server Installation Directory 2-30
MySQL Programs 2-31
mysqld: MySQL Server Process 2-32
Installation Programs 2-33
Utility Programs 2-34
mysql_config_editor 2-35
.mylogin.cnf Format 2-36
Login Paths 2-37
Command-Line Client Programs 2-38
Launching Command-Line Client Programs 2-39
Topics 2-40
Configuring Mandatory Access Control 2-41
SELinux Example 2-42
AppArmor: Example 2-43
Changing the root Password 2-44
Using mysqladmin to Change the root Password 2-45
Quiz 2-46
Topics 2-47
Starting and Stopping MySQL 2-48
Stopping MySQL with mysqladmin 2-49
MySQL Service Files 2-50
Starting and Stopping MySQL on Windows 2-51
Starting and Stopping MySQL on Windows: MySQL Notifier 2-52
Topics 2-53
Upgrading MySQL 2-54
Reading Release Notes 2-55
MySQL Shell Upgrade Checker Utility 2-56
Using In-Place Upgrade Method 2-57
Using Logical Upgrade Method 2-58
mysql_upgrade 2-59
Summary 2-60
Practices 2-61
Objectives 3-2
Topics 3-3
Architecture 3-4
Client/Server Connectivity 3-5
MySQL Server Process 3-6
Terminology 3-7
Server Process 3-8
Topics 3-9
Connection Layer 3-10
Connection Protocols 3-11
Local and Remote Connection Protocol: TCP/IP 3-12
Local Connection Protocol in Linux: Socket 3-13
MySQL and localhost 3-14
Local Connection Protocols in Windows: Shared Memory and Named Pipes 3-15
SSL by Default 3-16
Connection Threads 3-17
Quiz 3-18
Topics 3-19
SQL Layer 3-20
SQL Layer Components 3-21
SQL Statement Processing 3-22
Topics 3-23
Storage Layer 3-24
Storage Engines Provided with MySQL 3-25
Storage Engines: Function 3-26
SQL and Storage Layer Interactions 3-27
Features Dependent on Storage Engine 3-28
InnoDB Storage Engine 3-30
MyISAM Storage Engine 3-31
MEMORY Storage Engine 3-32
ARCHIVE Storage Engine 3-33
NDBCluster Storage Engine 3-34
BLACKHOLE Storage Engine 3-35
Storage Engines Feature Summary 3-36
How MySQL Uses Disk Space 3-38
Data Directory 3-39
Topics 3-40
What Is a Data Dictionary? 3-41
Types of Metadata 3-42
Data Dictionary in Earlier Versions of MySQL 3-43
Transactional Data Dictionary in MySQL 8 3-44
Transactional Data Dictionary: Features 3-45
Serialization of the Data Dictionary 3-46
Dictionary Object Cache 3-47
Topics 3-48
InnoDB Tablespaces 3-49
InnoDB System Tablespace 3-50
File-per-Table Tablespaces 3-51
General Tablespaces 3-52
Choosing Between File-Per-Table and General Tablespaces 3-53
Locating Tablespaces Outside the Data Directory 3-54<