Get this course

For All Roles: Architect/AppDev/DBA

TiDB Workshop for MySQL Users (TiDB Specific Features) (201.3_en)


Description
This workshop is a shortcut path to help an experienced MySQL user understand the unique features of TiDB and TiDB Cloud, with a series of hands-on exercises.

This course is also available through Private Training. To purchase Private Training, Contact Us to build out a custom training plan.
Content
  • Welcome to the Course
  • TiDB Workshop for MySQL Users Entry Survey
  • Session 1: Creating Database
  • Video: Creating Database
  • Exercises 1: Creating a TiDB Cluster for Testing Purposes
  • Session 2: Table DDL
  • Video: Table DDL
  • Exercises 2: Importing Data from CSV Files Using TiDB Lightning
  • Exercises 3: Flashback Table and Flashback Query
  • Exercises 4: Using AUTO_INCREMENT in TiDB
  • Exercises 5: Using AUTO_RANDOM in TiDB
  • Session 3: Temporary Table and Online DDL
  • Video: Temporary Table and Online DDL
  • Exercises 6: Global Temporary Table
  • Exercises 7: Online DDL
  • Session 4: Index DDL
  • Session 4: Index DDL
  • Exercises 8: CLUSTERED and NONCLUSTERED Primary Key
  • Session 5: Placement Rules
  • Video: Placement Rules
  • Exercises 9: Partitioned Table
  • Session 6: Cached Table and Partitioned Table
  • Video: Cached Table and Partitioned Table
  • Exercises 10: Implementing Hot and Cold Data Storage Tiering
  • Session 7: TiFlash
  • Video: TiFlash
  • Exercises 11: TiFlash for Analytical Queries
  • Session 8: DML
  • Video: DML
  • Exercises 12: Configuring TiDB Server System Variables
  • Session 9: Transaction Control
  • Video: Transaction Control
  • Exercises 13: Transaction Isolation Levels in TiDB
  • Exercises 14: Resource Control and Database Consolidation (v7.1)
  • Exercises 15: Pessimistic Transaction Lock
  • Exercises 16: Optimistic Transaction Lock
  • Exit Survey
  • TiDB Workshop for MySQL Users Exit Survey
Completion rules
  • You must complete the units "Exercises 1: Creating a TiDB Cluster for Testing Purposes, Exercises 2: Importing Data from CSV Files Using TiDB Lightning, Exercises 3: Flashback Table and Flashback Query, Exercises 4: Using AUTO_INCREMENT in TiDB, Exercises 5: Using AUTO_RANDOM in TiDB, Exercises 6: Global Temporary Table, Exercises 7: Online DDL, Exercises 8: CLUSTERED and NONCLUSTERED Primary Key, Exercises 10: Implementing Hot and Cold Data Storage Tiering, Exercises 9: Partitioned Table, Exercises 11: TiFlash for Analytical Queries, Exercises 15: Pessimistic Transaction Lock, Exercises 16: Optimistic Transaction Lock, Exercises 14: Resource Control and Database Consolidation (v7.1), Exercises 13: Transaction Isolation Levels in TiDB"
  • Leads to a certificate with a duration: Forever
Back