Database Operation Courses

TiDB logo-black
DBA COURSE 1: TiDB Essentials for DBA

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

  • Audience: Anyone (technical roles)
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: Basic computer, operating system, network and database knowledge; Ability to read simple SQL statements.
  • TiDB Version: v6.x

Start Free Learning

TiDB logo-black
DBA COURSE 2: TiDB Administration

This course guides you learn about managing TiDB. Understand TiDB's data migration, replication and backup recover method, as well as the scenarios and basic usage of the common ecosystem tools.

  • Audience: Database administrators
  • Level: Intermediate
  • Duration: 3 days
  • Prerequisites: You have completed DBA COURSE 1: TiDB Essentials for DBA, or you should be familiar with distributed database operation and administer or equivalent work experience.
  • TiDB Version: v6.x
See Course Outline
TiDB logo-black
DBA COURSE 3: TiDB Performance Tuning Case Studies

In this course, you will learn TiDB's performance optimization principles, SQL optimization, performance monitoring, tuning tools and performance optimization best practice cases.

  • Audience: Database administrators
  • Level: Advanced
  • Duration: 2 days
  • Prerequisites: TiDB system management basics, or equivalent work experience
  • TiDB Version: v5.x
See Course Outline

Developer Courses

TiDB logo-black
DEV COURSE 1: TiDB Architecture Basics for Developer

This course introduces the core components and their concepts to build up the distributed TiDB cluster and TiDB Cloud.

  • Audience: Any roles
  • Level: Introductory
  • Duration: 1.5 hours
  • Prerequisites: None
  • TiDB Version: General

Start Free Learning

TiDB logo-black
DEV COURSE 2: Learn SQL with TiDB

This course teaches you how to write SQL queries. More importantly, it takes performance into consideration at the very first place. Most of the content in the course is also compatible with MySQL. Learners can understand the compatibility of TiDB and MySQL in the course by practice.

  • Audience: SQL developer beginners
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: You know how to connect to TiDB with the MySQL Client.
  • TiDB Version: v6.x

Start Free Learning

TiDB logo-black
DEV COURSE 3: TiDB Specific Features and Transaction Control

This course provides the TiDB unique features you can leverage for your applications, such as AUTO_RANDOM, AUTO_INCREMENT special considerations, global temporary tables, how to work with TiFlash to enable data agility, and placement rules, etc.

  • Audience: SQL developers
  • Level: Intermediate
  • Duration: 1 day
  • Prerequisites: Experienced with SQL queries and basic knowledge with DML and DDL on MySQL compatible RDBMS.
  • TiDB Version: v6.x

Start Free Learning

java-pc
DEV COURSE 4: Working with TiDB from Java

This course guides you through a series of concepts and hands-on best practices to implement read and write operations via Java applications. It focuses on the JDBC driver perspective to get the audience ready to face any Java based ORM frameworks.

  • Audience: SQL and Java developers
  • Level: Intermediate
  • Duration: 3 hours
  • Prerequisites: Experience with Java programming and SQL
  • TiDB Version: v6.x

Start Free Learning

python
DEV COURSE 4: Working with TiDB from Python

This course guides you through a series of concepts and hands-on best practices to implement read and write operations via Python applications. It focuses on the connectors perspective to get the audience ready to face any Python based ORM frameworks.

  • Audience: SQL and Python developers
  • Level: Intermediate
  • Duration: 2 hours
  • Prerequisites: Experience with Python programming and SQL
  • TiDB Version: v6.x

Start Free Learning

PHP Logo
DEV COURSE 4: Working with TiDB from PHP

This course guides you through a series of concepts and hands-on best practices to implement read and write operations via PHP. Two APIs are introduced: mysqli and PDO_MySQL.

  • Audience: SQL and PHP developers
  • Level: Intermediate
  • Duration: 3 hours
  • Prerequisites: Experience with PHP programming and SQL
  • TiDB Version: v6.x

Start Free Learning

TiDB logo-black
DEV COURSE 5: Best Practices for Developing on TiDB

This course summarizes the guidelines and best practices about developing on TiDB.

  • Audience: Backend developers
  • Level: Intermediate
  • Duration: 1.5 hours
  • Prerequisites: Experience with SQL and backend application programming.
  • TiDB Version: v6.x
See Course Outline

Kickstart Workshops

cloud-native
TiDB Cloud Kickstart Workshop

This workshop contains a collection of hands-on labs and tasks to help you gain an understanding of TiDB Cloud features.

  • Participants: Any roles
  • Level: Introductory
  • Duration: 3 hours
  • Prerequisites: Basic computer, operating system, network and database knowledge

Get Started

TiDB Cloud logo-black

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-black

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise