Learn TiDB from PingCAP

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 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

In this course, you will learn and master TiDB architecture, design practices, performance monitoring, parameter optimization, troubleshooting, SQL optimization, and high-availability design.

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

In this course, you will learn to understand TiDB 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

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

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

This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL from the first place. And, most of the content in this course is applicable with MySQL, learners can understand the compatibility of TiDB and MySQL by practices.

• 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

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 policies, 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

This course guides you through a series concepts and hands-on best practices to implement read and write operations via Java program. It focuses on the JDBC Connector/J driver perspective to get the audience ready to face any ORM frameworks built upon Connector/J.

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

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