Get Demo Get Started
TiDB TiDB
Community EditionEnterprise Subscription
cloud icon_black-01 TiDB Cloud
Get Started

Introduction

Designed for developers, DBAs, and architects who will use the TiDB database in their work. The course focuses on the architecture and design principles of the TiDB database, which is the basis for future administer, development, performance tuning and troubleshooting.

Start Free Learning

Summary

  • Audience: Database beginners who plan to become TiDB experts
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: Basic computer, operating system, network and database knowledge; Ability to read simple SQL statements.
  • TiDB Version: v6.x

Build a training plan for your team? Contact Sales

Course Outline

Chapter 01: TiDB Database Architecture Overview

  • The overall architecture of TiDB database
  • The key features of TiDB Server, TiKV, and PD

Chapter 02: TiDB Server

  • The TiDB Server architecture
  • The functions of TiDB Server
  • The process of TiDB Server
  • The cache of TiDB Server

Chapter 03: TiKV

  • The architecture and features of TiKV
  • The data persistence of TiKV
  • How TiKV provides MVCC and distributed transaction
  • The consistency of TiKV based on raft
  • Coprocessor

Chapter 04: PD（Placement Driver）

  • The architecture and functions of PD
  • The allocation of TSO
  • The scheduling process
  • The labels and high availability

Chapter 05: TiDB Database SQL Execution Process

  • DML process
  • DDL process

Chapter 06: TiDB Database HTAP Overview

  • HTAP technology
  • TiDB HTAP Architecture
  • The core features of HTAP

Chapter 07: TiFlash

  • The architecture and features of TiKV
  • The core functions of TiFlash

Chapter 08: TiDB 6.0 New Features

  • Placement Rules in SQL
  • Cached Tables
  • In-memory pessimistic lock
  • Top SQL
  • TiDB Enterprise Manager（TiEM）

Chapter 09: TiDB Cloud

  • Why TiDB Cloud
  • The architecture of TiDB Cloud
  • The features of TiDB Cloud
  • Quick start TiDB Cloud

Want to build a training plan for your team?  Contact Sales

Module 1: TiDB Database Architecture

Chapter 01: TiDB Database Architecture Overview

  • The overall architecture of TiDB database
  • The key features of TiDB Server, TiKV, and PD

Chapter 02: TiDB Server

  • The TiDB Server architecture
  • The functions of TiDB Server
  • The process of TiDB Server
  • The cache of TiDB Server

Chapter 03: TiKV

  • The architecture and features of TiKV
  • The data persistence of TiKV
  • How TiKV provides MVCC and distributed transaction
  • The consistency of TiKV based on raft
  • Coprocessor

Chapter 04: PD（Placement Driver）

  • The architecture and functions of PD
  • The allocation of TSO
  • The scheduling process
  • The labels and high availability

Chapter 05: TiDB Database SQL Execution Process

  • DML process
  • DDL process

Module 2: TiDB HTAP

Chapter 06: TiDB Database HTAP Overview

  • HTAP technology
  • TiDB HTAP Architecture
  • The core features of HTAP

Chapter 07: TiFlash

  • The architecture and features of TiKV
  • The core functions of TiFlash

Module 3: TiDB 6.0 New Features

Chapter 08: TiDB 6.0 New Features

  • Placement Rules in SQL
  • Cached Tables
  • In-memory pessimistic lock
  • Top SQL
  • TiDB Enterprise Manager（TiEM）

Module 4: TiDB Cloud

Chapter 09: TiDB Cloud

  • Why TiDB Cloud
  • The architecture of TiDB Cloud
  • The features of TiDB Cloud
  • Quick start TiDB Cloud
TiDB logo-black

TiDB

The most advanced, open source, distributed SQL database

Get Demo Learn More
TiDB Cloud logo-black

TiDB Cloud

A fully-managed DBaaS with zero operational overhead

Try Free Learn More