Home / Course catalog / TiDB SQL Tuning (vilt_307_sep_25_na)

Public Training Class

TiDB SQL Tuning (vilt_307_sep_25_na)


Description

This public training class 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.

  • Date & Time: PDT (UTC-7:00) | 9~10 September, 2025, 10:00 AM~5:00 PM
  • Duration: 2 days
  • Language: English
  • Capacity: 16
  • Location: Virtual classroom live via Zoom Meeting
  • Registration ends: PDT (UTC-7:00) | 1 September, 2025, 5:00 PM


Content
  • Welcome to the Workshop
  • Welcome to this public training class
  • Training class entry survey
  • Training schedule
  • Training class exit survey
  • Course Slides (available on the day of training)
  • Accessibility Guide
  • Unit 1: Clustered and Non-Clustered Indexes Considerations for Performance
  • Unit 2: Secondary Index and Partitioned Table
  • Unit 3: Optimizer Fundamentals
  • Unit 4: Optimizing Queries
  • Unit 5: Cost Based Optimizer (CBO) Statistics Management
  • Unit 6: Best Practices for SQL Tuning in TiDB
Completion rules
  • You must complete the units "Training class exit survey"
  • Leads to a certificate with a duration: Forever