# Course: TiDB Administration (Code#: 303_v6)

## Prerequisites
+ You have completed the course TiDB Essentials for DBA [TiDB v6.x], or you should be familiar with distributed database operation and administer or equivalent work experience.

## Description
+ This course guides you learn about managing `TiDB`. Understand TiDB's data migration, replication and backup recover method, as well as the scenarios and basic usage of the common ecosystem tools.

## Audience
+ Database Administrators

## Level
+ Intermediate

## Duration
+ 3 days

## Summary
+ Chapter 01: `TiDB` Cluster Deployment
  + Use `TiUP` to deploy `TiDB` cluster
  + Start and Stop `TiDB` cluster
  + Describe the stages of `TiDB` cluster startup
  + Describe `TiDB` cluster configuration and log files
  + Create `TiDB` cluster in the `TiDB Cloud`
+ Chapter 02: Connecting to `TiDB`
  + Understand the `TiDB` compatibility with `MySQL`
  + Describe how to connect to `TiDB` server
+ Chapter 03: Configuring `TiDB`
  + Understand `TiDB` system variables
  + Understand the scope of `TiDB` system variables
  + Understand `TiDB` configuration file parameters
  + Describe how to modify `TiDB` system variables
  + Describe how to modify `TiDB` configuration file parameters
+ Chapter 04: Security and User Management
  + Understand authentication and authorization
  + Understand the levels of access privileges for users
  + Manage `TiDB` user accounts
  + Grant and revoke privileges
  + Use `SQL` statements to manage accounts
+ Chapter 05: `TiDB` Monitoring Tools
  + Describe the monitoring and alerting framework
  + Identify common monitoring metrics 
  + Monitor `TiDB` cluster status on `Grafana` panels
  + Monitor `TiDB` cluster status on `TiDB Dashboard`
+ Chapter 06: `TiDB` Cluster Operational Tasks
  + Rename a `TiDB` cluster
  + Scale out `TiDB` cluster components
  + Scale in `TiDB` cluster components
  + Tear down a `TiDB` cluster
  + Change the timezone of `TiDB` 
+ Chapter 07: Upgrading `TiDB` Cluster (On-premises)
  + Describe the TiDB versioning
  + Patch the TiDB cluster
  + Upgrade the TiDB cluster
+ Chapter 08: Backup Terminology and Strategies
  + Describe `TiDB` backup types
  + Describe `TiDB` backup techniques
  + Compare the various backup techniques
  + Perform backups on `TiDB Cloud` cluster
+ Chapter 09: Exporting Data using `Dumpling`
  + Explain when and how to use `Dumpling`
  + Use `Dumpling` to perform logical backups
+ Chapter 10: Importing Data using `TiDB Lightning`
  + Describe what `TiDB Lightning` is
  + Explain when and how to use `TiDB Lightning`
  + Using `TiDB Lightning` to import data
+ Chapter 11: Using `BR` for Backup and Restore
  + Describe what `BR` is
  + Explain when and how to use `BR`
  + Using `BR` to backup and restore `TiDB` cluster data
+ Chapter 12: Using `sync-diff-inspector` to Validate Data
  +  Describe the key features of `sync-diff-inspector`
  + Explain when and how to use `sync-diff-inspector`
  + Using `sync-diff-inspector` to compare schema and data
+ Chapter 13: Migrating Data from `MySQL-compatible` Databases with `TiDB Data Migration (DM)`
  + Describe the key features of `TiDB Data Migration`
  + Explain when and how to use `TiDB Data Migration`
  + Replicate data from `MySQL-compatible` upstream by using `TiDB Data Migration` cluster
+ Chapter 14: Replicating `TiDB` Change Events Using `TiCDC`
  + Describe the key features of `TiCDC` cluster
  + Explain when and how to use `TiCDC` cluster
  + Using `TiCDC` cluster to fan out database change events to downstreams

## References
+ TiDB documentation: https://docs.pingcap.com/tidb