TiDB Training and Certification

Introduction to TiDB Starter

In this hands-on lab, you'll learn basic operations and advanced features of TiDB Cloud. Tasks include connecting to a TiDB Cloud Starter cluster, exploring MySQL compatibility, eliminating manual sharding, using TiFlash for analytics, and understanding Non-Blocking Online DDL, Request Units, and database branches for innovative scaling.

Database Zero Downtime Under Availability Zone Failure

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

Build Vector Search Apps Using Jupyter Notebook

In this lab, you will learn to store and search text and image embeddings using TiDB Cloud Starter to accelerate AI development; use Amazon models for embeddings; perform vector similarity search via SQL; utilize Retrieval-Augmented Generation (RAG); and apply Hybrid Search and GraphRAG for improved data retrieval.

Using Resource Control with Mixed Workloads

This hands-on lab demonstrates how to use TiDB's resource control feature to manage mixed workloads in a database. TiDB's resource control feature allows you to set resource limits for different workloads, ensuring that one workload doesn't consume all the resources and impact other workloads.

Database Zero Downtime Online Upgrade With TiProxy

This hands-on lab showcases TiDB's seamless online rolling upgrade capability, avoiding disruptions to client applications — a common issue with traditional database upgrades. TiDB's cloud-native, loosely coupled architecture allows component-by-component, instance-by-instance upgrades.

Certified TiDB Practitioner

Becoming a certified TiDB Practitioner shows your understanding of TiDB's basic concepts, terminology, and use cases. This entry-level, beginner-friendly certification is free and can be retaken until you succeed, making it a great starting point for advanced TiDB Certifications.

Build Vector Search Applications Using Jupyter Notebook

In this lab, you will learn to store and search text and image embeddings using TiDB Cloud Starter to accelerate AI development; use Amazon models for embeddings; perform vector similarity search via SQL; utilize Retrieval-Augmented Generation (RAG); and apply Hybrid Search and GraphRAG for improved data retrieval.

Build RAG and Text2SQL AI Apps (Amazon Bedrock)

In this lab, you will learn to use TiDB Cloud Starter 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.

Build RAG and Text2SQL AI Apps (OpenAI)

In this lab, you will learn to use TiDB Cloud Starter 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.

Use TiDB as a Unified Storage for AI Apps (Amazon Bedrock)

In the first four modules, you'll work with various data stores (MySQL, Milvus, ElasticSearch) to meet different requirements in a GenAI RAG application, using multiple Python packages. In Module 5, you'll switch to pytidb and TiDB for a simpler, more efficient experience.

Use TiDB as a Unified Storage for AI Apps (OpenAI)

In the first four modules, you'll work with various data stores (MySQL, Milvus, ElasticSearch) to meet different requirements in a GenAI RAG application, using multiple Python packages. In Module 5, you'll switch to pytidb and TiDB for a simpler, more efficient experience.

Build GraphRAG and Tool Calling AI Agent Using TiDB (OpenAI)

In this lab, you will learn to: utilize TiDB Cloud Starter as a data storage layer for AI applications to speed up development; extract graphs from text using dspy; transform your RAG into GraphRAG for better retrieval performance; leverage LLM's Tool Calling mechanism to enhance AI Agent capabilities; and build an Agent to address practical problems.

Deploying a TiDB Cluster Using TiUP

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.

Database Seamless Scalability

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.

Dual Data Center Deployment Solution - TiDB Disaster Recovery Auto-Sync

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.

TiDB Essentials

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

Certified TiDB Associate Database Administrator

This credential helps organizations identify and develop talent with critical skills for deploying, managing, and operating workloads on TiDB and TiDB Cloud.

Using TiDB as an Operational Data Layer

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.

Migrate from MySQL to TiDB Using TiDB Data Migration

This hands-on lab illustrates the migration process from MySQL to TiDB using TiDB Data Migration, a powerful tool that simplifies data transfer with a unified interface. Learn to set up migration tasks and verify results effectively.

SQL Workload Replay

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.

TiDB Self-Managed Administration Using TiUP

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.

TiDB SQL Tuning

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.

TiDB Essentials

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

Database Scalability Deep Dive - Mastering the Rebalance Speed

In this hands-on lab, you will learn how to control the scaling rates of the TiKV cluster by adjusting the parameters of the PD component and the TiKV cluster itself. This will help in managing the impact of scaling operations on the load of the TiKV cluster.

Pause and Resume DDL Execution (v7.5+)

In this practice, participants will learn to utilize `ADMIN PAUSE DDL` to pause ongoing DDL executions and `ADMIN RESUME DDL` to resume them. This feature, available from TiDB v7.5, minimizes the impact of long-running DDL tasks on database performance and ensures smooth maintenance.

Database Scalability Deep Dive - Best Practice during SQL Layer Scaling In

TiDB is a distributed database that offers easy scalability for both the SQL (computing) and TiKV (storage) layers. To ensure zero downtime during computing layer scaling, applications must adhere to best practices, which we will discuss in this lab.

Working with TiKV MVCC In-Memory Engine (v8.5+)

In this practice, participants will learn to utilize the TiKV MVCC In-Memory Engine (IME) to enhance query performance, especially when scanning numerous MVCC historical versions. This feature is beneficial when total scanned versions exceed processed versions.

Managing Runaway Queries (v8.5+)

In this lab, we demonstrate how to identify and manage resource-intensive queries (runaway queries) and monitor them effectively. TiDB's resource control feature allows you to set criteria for resource groups to automatically manage runaway queries, preventing resource exhaustion. Additionally, runaway watches help quickly identify runaway queries for specific SQL statements or digests.

TiDB Self-Managed Administration Using TiUP

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.

TiDB SQL Tuning

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.

Certified TiDB Professional Database Administrator

This credential is designed to validate candidates’ proficiency in TiDB’s principles, large-scale TiDB clusters management as well as TiDB tools, such as TiDB Lightning, TiDB Data Migration, TiCDC, sync-diff-inspector and troubleshooting skills.

Get TiDB Certified

Enhance your expertise and validate your skills with TiDB certification. Our exams assess your knowledge of TiDB’s architecture, features, and best practices for deployment and management. Certification showcases your proficiency and boosts your credibility in database management.

Earn A TiDB Certificate