Home / Course catalog / TiDB Workshop for MySQL Users (TiDB S... (201.3_en)

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: TiDB Specific Features
  • Presentation: TiDB Specific Features
  • 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: CLUSTERED and NONCLUSTERED Primary Key
  • Exercises 5-1: Using AUTO_INCREMENT in TiDB
  • Exercises 5-2: Using AUTO_RANDOM in TiDB
  • Exercises 6: Global Temporary Table
  • Exercises 7: Online DDL
  • Exercises 8-1: Partitioned Table
  • Exercises 8-2: Implementing Hot and Cold Data Storage Tiering
  • Exercises 9: TiFlash for Analytical Queries
  • Exercises 10: Configuring TiDB Server System Variables
  • Exercises 11: Resource Control and Database Consolidation (v7.1)
  • Session 2: Transaction Control
  • Presentation: Transaction Control
  • Exercises 12: Transaction Isolation Levels in TiDB
  • Exercises 13-1: Pessimistic Transaction Lock
  • Exercises 13-2: 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 5-1: Using AUTO_INCREMENT in TiDB, Exercises 5-2: Using AUTO_RANDOM in TiDB, Exercises 6: Global Temporary Table, Exercises 7: Online DDL, Exercises 4: CLUSTERED and NONCLUSTERED Primary Key, Exercises 8-2: Implementing Hot and Cold Data Storage Tiering, Exercises 8-1: Partitioned Table, Exercises 9: TiFlash for Analytical Queries, Exercises 13-1: Pessimistic Transaction Lock, Exercises 13-2: Optimistic Transaction Lock, Exercises 11: Resource Control and Database Consolidation (v7.1), Exercises 12: Transaction Isolation Levels in TiDB"
  • Leads to a certificate with a duration: Forever