Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【经验分享】认证总结 tidb pcta
|
username: 云散月明
Certificate
Exam Syllabus
| Course Module | Content List |
|---|---|
| TiDB Database Architecture | Principles of distributed databases; distributed SQL engine; distributed storage system; HTAP database based on distributed architecture; typical application scenarios and user cases of TiDB |
| TiDB Cluster Management | TiDB Cluster deployment; TiDB connection management; TiDB configuration; user management and security; TiDB file and log management; TiDB monitoring; TiDB Cluster upgrade |
| TiDB Backup and Recovery | Backup and recovery strategies; using the BR tool for backup and recovery |
| TiDB Data Migration | Data export tool Dumpling; data import tool TiDB Lightning; data migration tool TiDB Data Migration (DM) |
| TiDB Data Synchronization and Replication | Data synchronization tool TiDB Binlog; data synchronization tool TiCDC |
Personal Study Plan
-
Study the course “Getting Started with TiDB”
-
Study the course “TiDB System Management Basics [TiDB v5]”
-
Use “Online Exam Process Experience” to familiarize yourself with the exam process
-
Learn from the exam preparation experiences of predecessors
-
Take the exam
-
Obtain the certificate
1. Study the course “Getting Started with TiDB”
This course is remarkable, it feels like a scientist inspiring his students to think proactively: what kind of database do we need, how to build a distributed storage system and SQL engine, etc.
Highly recommend starting with this course.
After completing the course, there is a final exam. Please take this exam seriously. Take it multiple times, thoroughly understand the mistakes, fill in the gaps, and strive for a perfect score.
2. Study the course “TiDB System Management Basics [TiDB v5]”
This course matches the exam syllabus and needs to be fully studied as it is all key points for the exam. This is not an exaggeration, it really is all key points.
Prepare two markdown notes, one for knowledge points and the other for practical operations. Taking notes while studying will take a long time, so be mentally prepared.
Although this course does not seem to have a final exam, the PCTA certification itself is the final exam. Therefore, understand the summaries and exercises at the end of each video course, set up your own cluster environment for practical exercises, and follow the instructor’s operations. “Learning from books is shallow; you must practice to truly understand.”
3. Use “Online Exam Process Experience” to familiarize yourself with the exam process
Check if the browser and camera are working properly, prepare the exam environment, and familiarize yourself with the exam process in advance.
4. Learn from the exam preparation experiences of predecessors
The predecessors plant trees, and the later generations enjoy the shade. Study well and strive to pass in one go.
Here are four links I collected during my preparation.
-
Experience Sharing: PCTA/PCTP 3.0 Exam Review on March 28, 2021
-
Knowledge Points Required for PCTA Certification | Must Read Before the Exam
5. Exam
The exam consists of 60 questions, covering a wide range of topics, 30 single-choice + 30 multiple-choice, full score is 60, passing score is 36. I passed on my first attempt with a score of 45.
6. Obtain the Certificate
The community awarded a badge
|
username: 
|
username: 
|
username: 