TiDB Training and Certification

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.

• Level: Introductory
• Duration: 90 minutes
• Prerequisites: None

In this hands-on lab, you'll learn basic operations and advanced features of TiDB Cloud Serverless, including creating a cluster, issuing queries from MySQL Client, accessing the database via Python scripts, and accelerating complex queries with TiFlash/HTAP. This lab caters to beginners and covers both basics and advanced features.

• Level: Introductory
• Duration: 90 minutes
• Prerequisites: None

This hands-on lab demonstrates achieving zero downtime during a data center or availability zone failure. TiDB's distributed architecture allows clients to seamlessly connect to available server instances, ensuring continuous operations without waiting for server-side failover.

• Level: Introductory
• Duration: 60 minutes
• Prerequisites: None

In this lab, you'll learn to connect to and modify data in a TiDB Cloud Serverless cluster using Python. You'll also use prepared statements and batch inserts for performance, AUTO_RANDOM to avoid hotspots, online DDL for schema changes, and compare pessimistic and optimistic transaction concurrency control modes.

• Level: Introductory
• Duration: 90 minutes
• 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 Java applications. It focuses on the JDBC driver perspective to get the audience ready to face any Java based ORM frameworks.

• 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 PHP. Two APIs are introduced: mysqli and PDO_MySQL.

• Level: Introductory
• Duration: 3 hours
• Prerequisites: Experience with PHP programming and SQL

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

• Level: Intermediate
• Duration: 2 days
• Prerequisites: A good working knowledge and understanding of SQL statements.

In this lab, you will learn to use TiDB Cloud Serverless as a unified storage layer for AI applications, generate embeddings with Amazon Bedrock, perform Retrieval-Augmented Generation (RAG) for large datasets, and build a Text-to-SQL AI app with Streamlit for interactive tools.

• Level: Introductory
• Duration: 90 minutes
• Prerequisites: None

In this lab, you will learn to use TiDB Serverless as a storage layer for AI applications, generate embeddings with OpenAI models, perform Retrieval-Augmented Generation (RAG) from large datasets, and build a Text-to-SQL AI app with Streamlit for interactive tools.

• Level: Introductory
• Duration: 90 minutes
• Prerequisites: None

This hands-on lab demonstrates deploying a TiDB cluster using TiUP, a powerful management tool. Learn to simplify deployment with a unified interface for deploying, scaling, and managing TiDB clusters, including setting up topology and verifying cluster status.

• Level: Introductory
• Duration: 90 minutes
• Prerequisites: None

This hands-on lab demonstrates how to scale a TiDB cluster in and out by adding or removing nodes to adjust capacity. This common operation in cloud environments is essential for managing rapidly changing workloads. Learn to scale using TiUP, a powerful management tool for TiDB.

• Level: Introductory
• Duration: 45 minutes
• Prerequisites: None

In the financial industry, dual data center architecture is crucial for core systems, emphasizing data availability and disaster recovery. This lab simulates deploying TiDB's DR Auto-sync solution in such environments, ensuring an RPO of 0 and RTO in minutes for high availability and data consistency.

• Level: Intermediate
• Duration: 100 minutes
• Prerequisites: None

In this hands-on lab, you'll set up a database replication task from MySQL to TiDB and perform real-time analysis on TiDB as changes occur in MySQL. This enables TiDB to balance transactional and analytical workloads as an Operational Data Layer with TiFlash/HTAP support.

• Level: Intermediate
• Duration: 90 minutes
• Prerequisites: None

This hands-on lab demonstrates replaying a SQL workload using TiDB Data Migration and the sql-replay utility. You'll learn to capture a SQL workload from MySQL, replay it on a TiDB cluster, and analyze the cluster's performance in this practical workshop.

• Level: Intermediate
• Duration: 90 minutes
• Prerequisites: None

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

• Level: Intermediate
• Duration: 1 day
• Prerequisites: Familiarity with computers, operating systems, networks, and databases; ability to read basic SQL statements.

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

• Level: Intermediate
• Duration: 2 days
• Prerequisites: Completion of Introduction to TiDB and TiDB Essentials, or familiarity with distributed database operations and administration, or equivalent work experience.