Database Operation

 

TiDB logo-black

DBA COURSE 1: TiDB Essentials 101

Designed for developers, DBAs, and architects who will use the TiDB database in their work. The course focuses on the architecture and design principles of the TiDB database, which is the basis for future administration, development, performance tuning and troubleshooting.

  • Audience: Anyone (technical roles)
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: Basic computer, operating system, network and database knowledge; Ability to read simple SQL statements.
  • TiDB Version: v6.x

Start Free Learning

TiDB logo-black

DBA COURSE 2: TiDB Administration Advanced

In this course, you will learn and master TiDB architecture, design practices, performance monitoring, parameter optimization, troubleshooting, SQL optimization, and high-availability design.

  • Audience: Database administrators
  • Level: Advanced
  • Duration: 5 days
  • Prerequisites: TiDB system management basics, or equivalent work experience
  • TiDB Version: v5.x
See Course Outline
TiDB logo-black

DBA COURSE 3: TiDB Performance Tuning Case Studies

In this course, you will learn to understand TiDB performance optimization principles, SQL optimization, performance monitoring, tuning tools and performance optimization best practice cases.

  • Audience: Database administrators
  • Level: Advanced
  • Duration: 2 days
  • Prerequisites: TiDB system management basics, or equivalent work experience
  • TiDB Version: v5.x
See Course Outline

Developer

 

TiDB logo-black

DEV COURSE 1: TiDB Architecture Basics

This course introduces the core components and their concepts build up the TiDB distributed database cluster.

  • Audience: Any roles
  • Level: Introductory
  • Duration: 1.5 hours
  • Prerequisites: None
  • TiDB Version: General
See Course Outline
TiDB logo-black

DEV COURSE 2: Learn SQL with TiDB

This course focuses on the essential SQL query skills and guides the audience to take performance into consideration while writing SQL from the first place. And, most of the content in this course is applicable with MySQL, learners can understand the compatibility of TiDB and MySQL by practices.

  • Audience: SQL developer beginners
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: You know how to connect to TiDB with the MySQL Client.
  • TiDB Version: v6.x
See Course Outline
TiDB logo-black

DEV COURSE 3: TiDB Specific Features and Transaction Control

This course provides the TiDB unique features you can leverage for your applications, such as AUTO_RANDOM, AUTO_INCREMENT special considerations, global temporary tables, how to work with TiFlash to enable data agility, and placement policies, etc.

  • Audience: SQL developers
  • Level: Intermediate
  • Duration: 1 day
  • Prerequisites: Experienced with SQL queries and basic knowledge with DML and DDL on MySQL compatible RDBMS.
  • TiDB Version: v6.x
See Course Outline
TiDB logo-black

DEV COURSE 4: Using Connector/J

This course guides you through a series concepts and hands-on best practices to implement read and write operations via Java program. It focuses on the JDBC Connector/J driver perspective to get the audience ready to face any ORM frameworks built upon Connector/J.

  • Audience: SQL and Java developers
  • Level: Intermediate
  • Duration: 3 hours
  • Prerequisites: Experience with Java programming and SQL
  • TiDB Version: v6.x
See Course Outline
TiDB logo-black

DEV COURSE 5: Best Practices for Developing on TiDB

This course summarizes the guidelines and best practices about developing on TiDB.

  • Audience: Backend developers
  • Level: Intermediate
  • Duration: 1.5 hours
  • Prerequisites: Experience with SQL and backend application programming.
  • TiDB Version: v6.x
See Course Outline
TiDB Cloud logo-white

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-white

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise