Book a Demo Start Instantly

Introduction

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

Free online learning is coming soon!

Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.

Contact Sales

Summary

  • Audience: Backend developers
  • Level: Intermediate
  • Duration: 1.5 hours
  • Prerequisites: Experience with SQL and backend application programming.
  • TiDB Version: v6.x

Course Outline

  • Describe best scenarios for TiDB
  • Describe transaction best practices on TiDB
  • Describe best practices for using secondary indexes
  • Try to avoid full table scan
  • Ensure the returning order for result set
  • JDBC configuration parameters best practices
  • Prepared statements best practices
  • Batching best practices

Build out a custom training plan?  Contact Sales

Module 1: Describe best practices for using TiDB SQL

  • Describe best scenarios for TiDB
  • Describe transaction best practices on TiDB
  • Describe best practices for using secondary indexes
  • Try to avoid full table scan
  • Ensure the returning order for result set

Module 2: Describe best practices for developing applications using TiDB (using Java as an example)

  • JDBC configuration parameters best practices
  • Prepared statements best practices
  • Batching best practices
TiDB Dedicated

TiDB Dedicated

A fully-managed cloud DBaaS for predictable workloads

TiDB Dedicated

TiDB Serverless

A fully-managed cloud DBaaS for auto-scaling workloads