Master 1Z0-908 Mysql 8.0 Database Administrator Training
Published 9/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Oracle 1Z0-908 and MySQL 8.0 Essentials: Certification, Performance Tuning, and Advanced Techniques for Success.
What you’ll learn
Oracle 1Z0-908 Preparation
MySQL 8.0 Fundamentals
Database Administration Skills
Security and User Management
Performance Tuning and Optimization
Backup and Recovery Strategies
High Availability and Replication
Monitoring and Maintenance
Advanced MySQL Features
and much more
Requirements
Willingness or Interest to learn.
Description
Overview
Section 1: Introduction to Oracle 1Z0-908 and MySQL 8.0
Lecture 1 Overview of Oracle 1Z0-908 Certification
Lecture 2 Introduction to MySQL 8.0
Lecture 3 Key Concepts in MySQL 8.0 Database Administration
Section 2: MySQL 8.0 Architecture and Components
Lecture 4 In-depth Analysis of MySQL 8.0 Architecture
Lecture 5 Exploring MySQL 8.0 Storage Engines
Lecture 6 MySQL 8.0 Data Dictionary
Section 3: MySQL 8.0 Security and User Management
Lecture 8 MySQL 8.0 Security Overview
Lecture 9 User and Privilege Management
Lecture 10 Authentication Plugins and Security Enhancements
Lecture 11 Auditing and Monitoring Security
Section 4: MySQL 8.0 Performance Tuning and Optimization
Lecture 12 Introduction to Performance Tuning
Lecture 13 Query Optimization Techniques
Lecture 14 Indexing Strategies for Optimization
Lecture 15 MySQL 8.0 Performance Schema
Lecture 16 MySQL 8.0 Buffer Pool and Memory Management
Section 5: MySQL 8.0 Backup and Recovery
Lecture 17 Importance of Backup and Recovery
Lecture 18 MySQL 8.0 Backup Strategies
Lecture 19 Overview of MySQL 8.0 Backup Tools
Section 6: High Availability and Replication in MySQL 8.0
Lecture 20 Introduction to High Availability
Lecture 21 MySQL 8.0 Replication Overview
Lecture 22 MySQL 8.0 InnoDB Cluster
Lecture 23 MySQL 8.0 Failover and Recovery Strategies
Section 7: MySQL 8.0 Monitoring and Maintenance
Lecture 24 Overview of MySQL 8.0 Monitoring
Lecture 25 MySQL Enterprise Monitor
Lecture 26 Routine Maintenance in MySQL 8.0
Section 8: Advanced Topics and Best Practices in MySQL 8.0
Lecture 27 MySQL 8.0 JSON Support
Lecture 28 MySQL 8.0 Geographic Information System (GIS) Support
