Registration for TiDB SCaiLE 2025 is now open! Secure your spot at our annual event.Register Now
Sign In Start for Free
Start for Free

Public Training Classes

Public classes are live, instructor-led classes through remote, virtual sessions on a regularly published schedule. Each class accommodates up to 16 students, ensuring personalized attention and an interactive learning environment.

en
Asia–Pacific Session | English

Session Date & Time
SGT (UTC+8:00) | 14~15 October, 2025, 9:00 AM~5:00 PM
Registration Ends
SGT (UTC+8:00) | 6 October, 2025, 5:00 PM

Purchase A Seat
en
Asia–Pacific Session | English

Session Date & Time
SGT (UTC+8:00) | 2~3 December, 2025, 9:00 AM~5:00 PM

Registration Ends
SGT (UTC+8:00) | 24 November, 2025, 5:00 PM

Purchase A Seat
cn
Asia–Pacific Session | Mandarin

Session Date & Time
HKT (UTC+8:00) | 28~29 October, 2025, 9:00 AM~5:00 PM
Registration Ends
HKT (UTC+8:00) | 20 October, 2025, 5:00 PM

Purchase A Seat
cn
Asia–Pacific Session | Mandarin

Session Date & Time
HKT (UTC+8:00) | 16~17 December, 2025, 9:00 AM~5:00 PM
Registration Ends
HKT (UTC+8:00) | 8 December, 2025, 5:00 PM

Purchase A Seat

Private Training Classes

Private Training allows you to pick-and-choose a specific time to deliver the course to your team in a private classroom on your schedule. To purchase a private training class, please speak to your PingCAP Sales representative or Contact Us directly.

Contact Us

Course Info

What You Will Learn

In this course, you will learn how to manage a self-managed TiDB cluster, implement backup and restore strategies, and explore common usage scenarios of various ecosystem tools.

Who This Course is For

This course is suitable for:

  • Database Administrators
  • Professionals with experience in distributed database operations and administration

Whether you're new to distributed databases or looking to expand your knowledge, this course will set you on the right path.

Prerequisites

To ensure you are well-prepared for this course, please complete the following free e-learning courses:

Course Outline

ppt
TiDB Cluster Deployment
  • Describe TiUP
  • Understand how to deploy a TiDB Cluster
  • Understand how to connect to TiDB
ppt
Configuring TiDB
  • Understand TiDB system variables
  • Understand the scope of TiDB system variables
  • Understand TiDB configuration file parameters
  • Describe how to modify TiDB system variables
  • Describe how to modify TiDB configuration file parameters
ppt
Security and User Management
  • Understand authentication and authorization
  • Understand the levels of access privileges for users
  • Manage TiDB user accounts
  • Grant and revoke privileges
  • Use SQL statements to manage accounts
ppt
Maintaining a TiDB cluster
  • Understand how to scale out and scale in TiDB cluster components
  • Understand how to clean up and Delete a TiDB cluster
  • Understand the timezone in TiDB
  • Describe placement rule
  • Understand how to upgrade a TiDB cluster
  • Understand how to monitor a TiDB cluster
ppt
Resource Control
  • Describe what resource control is
  • Understand the decision logic of resource control
  • Discuss the usage scenarios of resource control
  • Explain how to use resource control
  • Understand a real-world use case of resource control
ppt
Backup Terminology and Strategies
  • Describe TiDB backup types
  • Compare the various backup techniques
ppt
Importing Data using TiDB Lightning
  • Describe what TiDB Lightning is
  • Explain when and how to use TiDB Lightning
  • Using TiDB Lightning to import data
ppt
Exporting Data using Dumpling
  • Explain when and how to use Dumpling
  • Use Dumpling to perform logical backups
ppt
Backup and Restore
  • Describe what BR is
  • Explain when and how to use BR
  • Using BR to backup and restore TiDB cluster data
  • Understand point-in-time recovery (PITR)
  • Understand how to recover from data loss
ppt
Using sync-diff-inspector to Validate Data
  • Describe the key features of sync-diff-inspector
  • Explain when and how to use sync-diff-inspector
  • Using sync-diff-inspector to compare schema and data
ppt
Migrating Data with TiDB Data Migration (DM)
  • Describe the key features of TiDB Data Migration
  • Explain when and how to use TiDB Data Migration
  • Replicate data from MySQL-compatible upstream by using TiDB Data Migration cluster
ppt
Replicating TiDB Change Events Using TiCDC
  • Describe the key features of TiCDC cluster
  • Explain when and how to use TiCDC cluster
  • Using TiCDC cluster to fan out database change events to downstreams

After completing this course, you are recommended to take the following certification exam.

CTA
Master TiDB: Scale Your Skills, Certify Your Success

Register Now