# Objectives
+ In this chapter, you will learn to:
  + Create and drop database
  + Describe database character sets
  + Create, modify, delete, flashback tables
  + Use table and index related DDL
  + Describe and set column properties, table options
  + Create indexes, primary keys, unique keys, and constraints
  + Cross geolocation regions placement rules
  + Use cached tables
  + Use partitioned table
  + Optimize Analytical Queries with TiFlash
------------------------------------------------------------
[no notes]