PingCAP offers well-designed online courses and private training to help users get ramped quickly on TiDB and TiDB Cloud. Backend developers, database administrators and operations professionals can benefit from the training program and demonstrate their expertise by earning a globally recognized certification.
Featured courses and workshops for all technical roles to get started with TiDB and TiDB Cloud, covering TiDB overview, architecture, and hands-on exercises.
Introduction to TiDB
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
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.
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
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.
Specialized training courses for database administrators to deep dive into how TiDB works and how to use TiDB on-premises.
TiDB Essentials
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.
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.
Courses for application developers, covering how to interact with TiDB via SQL and Connectors to enhance your development with Java/Python/PHP ORM frameworks.
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: Knowing how to connect to TiDB with the MySQL Client.
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
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: Introductory
Duration: 2 hours
Prerequisites: Experience with Python programming and SQL
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