# PingCAP Certified SQL Developer Exam Guide (E201_V6)

## Introduction
+ The PingCAP Certified SQL Developer (PCSD_v6) exam is designed to assess the skills and knowledge of developers in using the unique features of TiDB, creating highly available and elastic applications with TiDB, and following best practices when working with the database. 

## Response Types
+ There are two types of questions on the exam:
  + Multiple choice: Has one correct response and one or more incorrect responses. 
  + Multiple response: Has two or more correct responses out of all response options.

## Exam Results
+ The PingCAP Certified SQL Developer exam consists of 60 questions and requires a score of 60% or higher to pass. The exam has a time limit of 75 minutes.

## Outline
| Knowledge Area                                           | % of Exam |
| :------------------------------------------------------- | :-------- |
| Domain 1: TiDB Architecture                              | 15%       |
| Domain 2: TiDB SQL Application                           | 30%       |
| Domain 3: TiDB Specific Features and Transaction Control | 30%       |
| Domain 4: Best Practices for Developing on TiDB          | 25%       |

## Domain Details
+ Domain 1: TiDB Architecture
  + Describe the TiDB Cluster Architecture
  + Identify the TiDB Server Features
  + Identify the PD Features
  + Identify the TiKV Features
  + Identify the TiFlash Features
  + Describe what HTAP is

+ Domain 2: TiDB SQL Application
  + Querying Data in TiDB
  + Data Types and Expressions
  + Functions and Expressions
  + Joins
  + Subqueries

+ Domain 3: TiDB Specific Features and Transaction Control
  + Use AUTO_RANDOM
  + Use AUTO_INCREMENT
  + Use Placement Policy
  + Use Temporary Table
  + Use Cached Table

+ Domain 4: Best Practices for Developing on TiDB
  + Understand Best Practices in Designing Tables
  + Understand Best Practices in Writing SQL