Explore MySQL: A Beginner’s Journey into Database Internals – Premium Edition
0h 0m 0s
English
Paid
Embark on a step-by-step journey to understand how MySQL operates internally—from executing simple queries to exploring advanced mechanisms. This comprehensive course caters to beginner developers, students, and anyone eager to delve into the intricate workings of MySQL. Starting with fundamental SQL queries, you will progressively cover the following topics:
Course Topics
B+-trees and Indexes: Learn how MySQL utilizes B+-trees to organize and search data efficiently.
Buffer Pool and Caching Mechanisms: Understand how MySQL uses its buffer pool to enhance performance by minimizing direct disk accesses.
Transactions, MVCC, Redo and Undo Logs: Explore how transactions are managed to ensure data consistency and integrity.
Isolation Levels, Locks, and Reliability Guarantees: Gain insights into different isolation levels and how locks contribute to data reliability.
Execution Plan, Types of JOIN, and Performance Analysis: Analyze how execution plans and JOIN types impact query performance.
MySQL Trace Tool
Enhance your learning experience with access to a high-performance tracing tool tailored to a specific version of MySQL. This tool enables you to observe how SQL statements are parsed, optimized, and executed in real time, offering a profound understanding of MySQL's internal processes.
An expert in solving complex problems in software development, possessing deep knowledge of the TCP core, MySQL, and PostgreSQL, as well as being passionate about artificial intelligence, history, mathematics, and physics.
