参加此课程

For All Roles: Architect/AppDev/DBA

MySQL 用户 TiDB 基础实操 (201.3_zh)


描述
本课程提供了可用于应用程序的 TiDB 独特功能，如方便的 AUTO_RANDOM、使用 AUTO_INCREMENT 的注意事项、全局临时表、如何使用 TiFlash 启用 HTAP 、以及使用放置策略(Placement Rules in SQL)实现数据的冷热隔离等。
内容
  • Welcome Letter
  • Welcome Letter for TiDB 特有功能与事务控制
  • Hands-on Exercises
  • Exercises 1: Creating a TiDB Cluster
  • Exercises 2: Importing CSV File Using TiDB Lightning
  • Exercises 3: Flashback
  • 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 Non-Clustered Primary Key
  • Exercises 9: Hot and Cold Data Separation by Placement Rules in SQL
  • Exercises 10: Partitioned Table
  • Exercises 11: The Columnar Storage Engine - TiFlash
  • Exercises 12: Pessimistic Transaction Lock
  • Exercises 13: Isolation Levels in TiDB
  • Exercises 14: Resource Control (v7.0.0) and Database Consolidation
  • Exercises 15: Isolation Levels in TiDB
  • Exercises 16: Optimistic Transaction Lock
  • Appendix Sessions
  • Session 1: 数据库与字符集
  • Session 2: Table DDL
  • Session 3: 预备知识检查
  • Session 4: 闪回表
  • Session 5: AUTO_INCREMENT
  • Session 6: AUTO_RANDOM
  • Session 7: SHARD_ROW_ID_BITS
  • Session 8: 全局临时表
  • Session 9: 在线 DDL
  • Session 10: 聚簇主键与非聚簇主键
  • Session 11: 外键
  • Session 12: Index DDL
  • Session 13: 缓存表与分区表
  • Session 14: Placement Policy
  • Session 15: 利用 TiFlash 提升分析型查询效率
  • Session 16: DML
  • Session 17: 事务控制
  • Session 18: 事务隔离等级
  • Session 19: 预编译语句
  • Appendix : Course Presentation
  • 课程反馈及建议
  • TiDB 特有功能与事务控制 课程反馈及建议
完成规则
  • 您必须完成单元的“Exercises 1: Creating a TiDB Cluster, Exercises 2: Importing CSV File Using TiDB Lightning, Exercises 3: Flashback, 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 Non-Clustered Primary Key, Exercises 9: Hot and Cold Data Separation by Placement Rules in SQL, Exercises 10: Partitioned Table, Exercises 11: The Columnar Storage Engine - TiFlash, Exercises 12: Pessimistic Transaction Lock, Exercises 16: Optimistic Transaction Lock, Exercises 14: Resource Control (v7.0.0) and Database Consolidation, Exercises 15: Isolation Levels in TiDB”
  • 产生的证书有效期为：永远
返回