# Course 3: TiDB Workshop for MySQL Users (Code#: 201.3)

## Prerequisites
+ Experienced with SQL queries and basic knowledge with DML and DDL on MySQL compatible RDBMS.

## Description
+ This workshop describes TiDB unique features, such as resource control, database consolidation, flashback tables, cached tables, and TiFlash. It can also serve as a valuable shortcut for experienced MySQL users to understand the unique features of TiDB and TiDB Cloud, with a series of hands-on exercises.

## Audience
+ Architects, Developers and DBAs

## Level
+ Intermediate

## Duration
+ 3 hours

## Summary
+ 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
  + Use global temporary table
  + 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
  + Understand online DDL
  + Understand hot and cold storage tiering
  + Understand resource control and database consolidation
+ TiDB Data Manipulation Language (DML) and Transaction Control
  + Use AUTO_INCREMENT and AUTO_RANDOM
  + Import data into TiDB using TiDV Lightning
  + 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 lock
  + Describe SQL injections and prepared statements