隨著 Oracle 的收購並為 MySQL 不斷加入企業功能至 MySQL Enterprise Edition (企業付費版),現時 MySQL 除在開源市場有極高的佔有率,近年更有不少企業購買使用,對於 MySQL 的人材需求亦相對提升。
相比先前的版本,本課程教授的 MySQL 8.0 新版提供以下新特性!
Transactional Data Dictionary
Window Functions
Common Table Expressions (CTEs)
Roles
Improved JSON support
Functional Indexes
Descending Indexes
Invisible Indexes
Atomic DDL
Resource Groups
Default character set: utf8mb4
MySQL Shell
Enhanced Performance Schema
GIS improvements
InnoDB enhancements
為了讓您在競爭激烈的職場中脫穎而出,並證明您具備專業水準來安裝、管理及規劃 MySQL 8.0 資料庫,Oracle 推出了備受推崇的 OCP: MySQL 8.0 Database Administrator 國際認證考試!
本課程經過擁有豐富業界經驗的資深導師精心設計,涵蓋 MySQL Community Edition (開源版) 的核心功能,以及 MySQL Enterprise Edition (企業付費版) 的進階企業功能,完美對應 OCP MySQL 8.0 Database Administrator 的考試要求。從基礎安裝到高級管理與規劃,我們不僅助您考試過關,更讓您收穫實用的實戰技能,立即應用於工作場景,讓您的專業能力更具競爭力!
課程名稱:OCP: MySQL 8.0 Database Administrator 國際認可證書課程 - 簡稱:OCP MySQL Training Course (8.0) (提供 7x24 實習器材)
1Z0-908 MySQL 8.0 Database Administrator (30 hours)
1. Introduction to MySQL Database
1.1 Open Source RDBMS vs Commercial RDMBS
1.2 MySQL Platforms
1.3 MySQL works in client/server or embedded systems
1.4 Introduction to MySQL Enterprise Edition features
1.5 Verifying MySQL Server Version
1.6 Resetting Root Password of MySQL Database
1.7 Stopping and Starting MySQL database safely
1.8 MySQL Database Server and Server Startup programs
1.9 Data Directory initialization during installation
1.10 More about mysql_secure_installation
2. Concepts of MySQL Database
2.1 Creating a Database using MySQL Workbench
2.2 Table
2.3 Introduction to InnoDB storage engine
2.4 Introduction to MyISAM storage engine
2.5 Introduction to MEMORY storage engine
3. MySQL Server Configuration Options
3.1 Option files
3.2 Option Groups in my.cnf
3.3 Sample Default Server Configuration File
4. Login Access to MySQL Server
4.1 Overview
4.2 MySQL User Account Management Concept
4.3 Manipulating MySQL User Accounts
4.4 Password Hashing in MySQL Database
4.5 MySQL Password Validation Plugin
5. Granting Privileges on MySQL Server
5.1 How the Privilege System Works
5.2 The Grant Tables in MySQL
5.3 Authentication procedures
5.4 Privileges Management on MySQL server
5.5 Granting privileges
5.6 Revoking Privileges
5.7 The “ALL” privilege
5.8 Account Resource Limits
6. MySQL Metadata
6.1 INFORMATION_SCHEMA
6.2 SHOW command
6.3 INFORMATION_SCHEMA vs. SHOW command
7. Log and Status Files
7.1 Overview of Log and Status Files
7.2 General Log and Slow Query Log Output Destinations
7.3 The General log
7.4 The Slow Query Log
7.5 The Binary Log
7.6 Error Log
8. MySQL Enterprise Audit Log
8.1 Introduction to MySQL Enterprise Audit Log plugin
8.2 Installing and Configuring the Enterprise Audit Log plugin
8.3 Audit Log storage management
8.4 Filtering Events by Account
9. Backup and Recovery
9.1 Binary Backups Versus Textual Backups
9.2 Binary MyISAM Backups
9.3 Binary InnoDB Backups
9.4 Making Text Backups
9.5 Text Backup using “mysqldump”
9.6 Restoring to the latest state
9.7 InnoDB Force Recovery Option
10. High-Availability: Replication
10.1 Configuring Replication
10.2 Replication Process Threads
10.3 Replicating specific database
10.4 Replication and Temporary tables
10.5 Time-Delayed Replication
10.6 Replication with Different Table Definition
10.7 Configuring GTID Mode with Replication
10.8 Identifying and Blocking unwanted transactions in a GTID-Replication environment
10.9 Other H.A. Technologies: MySQL Cluster
10.10 Other H.A. Technologies: Oracle VM Template
10.11 Other H.A. Technologies: MySQL with Windows Failover Cluster
10.12 Other H.A. Technologies: MySQL with DRBD
The course content above may change at any time without notice in order to better reflect the content of the MySQL 8.0 examination.