# Course: TiDB Essentials for DBA (TiDB v6.1) [101_v6.1]

## Prerequisites
+ You need to have basic computer, operating system, network and database knowledge. In addition, you should be able to read simple SQL statements.

## Description
+ Designed for developers, DBAs, and architects who will use the TiDB database in their work. The course focuses on the architecture and design principles of the TiDB database, which is the basis for future administer, development, performance tuning and troubleshooting.

## Audience
+ Database beginners who plan to become TiDB experts

## Level
+ Introductory

## Duration
+ 1 day

## Summary
+ Module: TiDB Database Architecture Overview
  + Chapter 01: TiDB Database Architecture Overview
    + Understand the overall architecture of TiDB
    + Describe the key features of TiDB server, TiKV server, and Placement Driver (PD) server
  + Chapter 02: TiDB Server
    + Describe TiDB server's architecture
    + Describe TiDB server's role in TiDB cluster
    + Describe TiDB server's processes
    + Describe TiDB server's server cache
  + Chapter 03: TiKV Server
    + Understand TiKV server's architecture
    + Describe the data persistence and read operations in TiKV
    + Understand how TiKV cluster provides MVCC and distributed transaction support
    + Understand the distributed consistency based on the Raft algorithm
    + Understand TiKV server's Coprocessor
  + Chapter 04: Placement Driver Server 
    + Understand PD server's architecture and features
    + Understand TSO (Timestamp Oracle) concept and it's purpose
    + Understand scheduling process
    + Understand the relationship between labels and high availability
  + Chapter 05: TiDB SQL Execution Process
    + Describe the process of reading and writing data with DML
    + Describe the execution flow of DDL
+ Module: TiDB HTAP
  + Chapter 06: HTAP Overview
    + Understand HTAP (Hybrid Transactional/Analytical Processing) technology
    + Understand the HTAP architecture of TiDB database
    + Understand the HTAP core functions of the TiDB database
  + Chapter 07: TiFlash Overview
    + Describe the architecture of TiFlash
    + Understand the main functions of TiFlash
+ Module: New Features of TiDB v6.0
  + Chapter 08: New Features of TiDB v6.0
    + Understand Placement Rules in SQL
    + Describe small table cache
    + Understand in-memory pessimistic lock
    + Understand Top SQL
    + Understand TiUniManager
+ Module: TiDB Cloud
  + Chapter 09: TiDB Cloud
    + Describe why you should consider the "The Cloud"
    + Describe TiDB Cloud account types
    + Compare and contrast TiDB and TiDB Cloud
    + Get you to create a TiDB Cloud account and try it
  
## References
+ TiDB documentation: https://docs.pingcap.com/tidb