Book a Demo Start Instantly
Book a Demo Start Instantly
TiDB TiDB
Community EditionEnterprise Subscription
cloud icon_black-01 TiDB Cloud
Get Started

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 rules, 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

Module 2: TiDB Data Manipulation Language (DML) and Transaction Control

  • 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
TiDB Dedicated

TiDB Dedicated

A fully-managed cloud DBaaS for predictable workloads

Sign Up Learn More
TiDB Dedicated

TiDB Serverless

A fully-managed cloud DBaaS for auto-scaling workloads

Try for Free Learn More