TiDB Training & Certification - All Roles: Architect/AppDev/DBA

TiDB Specific Features Workshop [TiDB v6.x] (201.3_v6.1_en)


Description
This workshop, through a series of carefully-designed hands-on exercises, enables you to gain an understanding of the unique features of TiDB and TiDB Cloud.

This course is also available through Private Training. To purchase Private Training, Contact Sales to build out a custom training plan.
Content
  • Welcome to the Course
  • TiDB Specific Features Workshop Entry Survey
  • TiDB Specific Features Workshop
  • Unit 1: Creating Database
  • Exercises 1: Start a TiDB Cluster
  • Unit 2: Table DDL
  • Exercises 2: Flashback Table
  • Exercises 3: Use AUTO_INCREMENT in TiDB
  • Exercises 4: Use AUTO_RANDOM in TiDB
  • Unit 3: Temporary Table and Online DDL
  • Exercises 5: Global Temporary Table
  • Exercises 6: Online DDL
  • Unit 4: Index DDL
  • Exercises 7: Clustered and Non-Clustered Primary Key
  • Unit 5: Placement Rules
  • Exercises 8: Implementing Hot and Cold Data Separation
  • Unit 6: Cached Table and Partitioned Table
  • Exercises 9: Partitioned Table
  • Unit 7: TiFlash
  • Exercises 10: The Column Storage Engine - TiFlash
  • Unit 8: DML
  • Unit 9: Transaction Control
  • Exercises 11: Isolation Levels in TiDB
  • Exercises 12: Pessimistic Transaction Lock
  • Exercises 13: Optimistic Transaction Lock
  • Exit Survey
  • TiDB Specific Features Workshop Exit Survey
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever