Introduction

This course provides the TiDB unique features you can leverage for your applications, such as AUTO_RANDOM, AUTO_INCREMENT special considerations, global temporary tables, how to work with TiFlash to enable data agility, and placement policies, etc.

Free online learning is coming soon!

Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.

Contact Sales

Summary

  • Audience: SQL developers
  • Level: Intermediate
  • Duration: 1 day
  • Prerequisites: Experienced with SQL queries and basic knowledge with DML and DDL on MySQL compatible RDBMS.
  • TiDB Version: v6.x

Course Outline

  • Create and drop database
  • Describe database charactersets
  • Create, modify, delete, flashback tables
  • Use table and index related DDL
  • Describe and set column properties, table options
  • Create indexes, primary keys (clustered and non-clustered), unique keys, and constraints
  • Use cached tables
  • Use partitioned table
  • Use placement policy
  • Optimize analytical queries with TiFlash
  • Add new data to a table using INSERT and REPLACE
  • Use UPDATE to modify data
  • Avoid duplicate records
  • Delete rows using DELETE
  • Control transactions
  • Use pessimistic and optimistic locking
  • Describe SQL injections and prepared statements

Build out a custom training plan?  Contact Sales

Module 1: TiDB Data Definition Language (DDL)

  • Create and drop database
  • Describe database charactersets
  • Create, modify, delete, flashback tables
  • Use table and index related DDL
  • Describe and set column properties, table options
  • Create indexes, primary keys (clustered and non-clustered), unique keys, and constraints
  • Use cached tables
  • Use partitioned table
  • Use placement policy
  • Optimize analytical queries with TiFlash
TiDB Cloud logo-white

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-white

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise