Learn TiDB and Advance Your Career

This course introduces the reasons behind customers' adoption of TiDB, as well as the core components and their concepts required to build up a distributed TiDB cluster and TiDB Cloud.

• Audience: Architects, Developers and Database administrators
• Level: Introductory
• Duration: 1.5 hours
• Prerequisites: None

Start Free Learning

This workshop is a shortcut path to help an experienced MySQL user understand the unique features of TiDB and TiDB Cloud, with a series of hands-on exercises.

• Audience: Architects, Developers and Database administrators
• Level: Intermediate
• Duration: 5 hours
• Prerequisites: Experienced with SQL queries and basic knowledge with DML and DDL on MySQL compatible RDBMS.

Start Free Learning

The course focuses on the architecture and design principles of TiDB, which is the basis for administration, development, performance tuning and troubleshooting.

• Audience: Database administrators
• Level: Intermediate
• Duration: 1 day
• Prerequisites: Basic computer, operating system, network and database knowledge; Ability to read simple SQL statements.

Start Free Learning

This course is designed to provide comprehensive knowledge and best practices for ensuring the security of your data when utilizing the TiDB Cloud platform.

• Audience: Architects, Developers and Database administrators
• Level: Intermediate
• Duration: 3 hours
• Prerequisites: Complete the free e-learning course, Introduction to TiDB.

Start Free Learning

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: Knowing how to connect to TiDB with the MySQL Client.

Start Free Learning

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: Introductory
• Duration: 3 hours
• Prerequisites: Experience with Java programming and SQL

Start Free Learning

In this course, you will learn how to: Connect to, access and modify data in TiDB Cloud Serverless cluster by Python code; Use prepared statements and batch inserts to improve the performance of your application; Use AUTO_RANDOM instead of AUTO_INCREMENT to avoid hotspots; Use online DDL to add columns to a table without blocking or interrupting ongoing transactions.

• Audience: SQL and Python developers
• Level: Introductory
• Duration: 90 minutes
• Prerequisites: Experience with Python programming and SQL

Start Lab

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: Introductory
• Duration: 3 hours
• Prerequisites: Experience with PHP programming and SQL

Start Free Learning

This instructor-led training course guides you learn about managing TiDB Self-Managed, backup and restore strategies, as well as the scenarios and common usage of some ecosystem tools.

• Audience: Database administrators
• Level: Intermediate
• Duration: 2 days
• Prerequisites: You have completed Introduction to TiDB and TiDB Essentials, or you should be familiar with distributed database operations and administration or equivalent work experience.

This instructor-led training course provides in-depth knowledge and practical skills to optimize SQL performance in TiDB. You will learn to design effective table and index structures, manage partitioned tables, and understand the SQL optimization processes.

• Audience: SQL developers and database administrators
• Level: Intermediate
• Duration: 2 days
• Prerequisites: A good working knowledge and understanding of SQL statements is assumed. Completing the TiDB training courses, Introduction to TiDB and Learn SQL with TiDB is recommended.