Free e-Learning | TiDB Essentials

Course Info

What You Will Learn

In this course, you will have a general understanding of TiDB's architecture and design principles, which are the basis for future administer, development, performance tuning and troubleshooting, specifically:

Gain a general understanding of TiDB's architecture and design principles
Learn the roles and processes of TiDB, TiKV, and Placement Driver (PD) servers.
Understand the execution processes for SQL commands, including DML and DDL.
Explore the Hybrid Transactional/Analytical Processing (HTAP) technology and its architecture.
Discover new features introduced in TiDB versions 6.0, 8.1, and 8.5 via hands-on labs
Learn about TiDB Cloud, its benefits, account types, and how to create an account.

Who This Course is For

This course is suitable for:

Developers seeking to enhance their knowledge of TiDB.
Architects looking to understand the design principles behind TiDB.
Database administrators aiming to improve their skills in administration, performance tuning, and troubleshooting of TiDB.

Prerequisites

Basic knowledge of computers, operating systems, networks, and databases.
Ability to read and understand simple SQL statements.

Course Outline

TiDB Database Architecture Overview

Understand the overall architecture of TiDB
Describe the key features of TiDB server, TiKV server, and Placement Driver (PD) server

TiDB SQL Execution Process

Describe the process of reading and writing data with DML
Describe the execution flow of DDL

TiDB HTAP

Understand HTAP technology, architecture, and core functions of TiDB database
Describe the architecture and main functions of TiFlash

New Features in TiDB v6.0

Understand Placement Rules in SQL
Describe small table cache, in-memory pessimistic lock, and Top SQL

New Features in TiDB 8.1 and 8.5

Understand TiKV MVCC in-memory engine, foreign keys, global index for partitioned tables, monitoring indexes usage statistics, TiProxy, and Vector Search