Udemy – MySQL 9 Database Administration: The Complete Deep Dive

Welcome to MySQL 9 Database Administration: The Complete Deep Dive – a comprehensive, hands-on course designed for anyone who wants to develop strong, practical and in-depth MySQL Database Administration skills. This is not a SQL course, and it is not designed around simply memorizing MySQL commands. Instead, this course takes you deep into the world of MySQL Database Administration, helping you understand not only how to perform DBA tasks, but also why MySQL behaves the way it does.

What Will You Learn?

You will progressively build your knowledge across the complete MySQL DBA lifecycle, including:

• MySQL Architecture & Internals: Understand MySQL server architecture and how the major components work together. Dive into InnoDB architecture and internals, memory structures, storage, transactions, logging and other fundamental concepts that every serious MySQL DBA should understand.
• Installation & Configuration: Learn how to install, configure and manage MySQL database servers and understand the important configuration parameters that influence reliability and performance.
• Database Administration: Learn practical DBA activities including users, roles, privileges, security, database maintenance, configuration management, logs, storage and resource management.
• InnoDB Deep Dive: Go beyond the basics and understand the concepts behind the InnoDB storage engine, including transactions, locking, concurrency, undo, redo, buffer pool and other important internal mechanisms.