Intermediate

1. 01Faster queriesTransactions, locks and query plans: make the database fast without breaking correctness.0/12 done

   Learn · 0/4

   • Transactions and isolation levels

     9 min · 3-question quiz

   • Optimistic and pessimistic locking

     6 min · 3-question quiz

   • Query optimisation, EXPLAIN and connection pooling

     12 min · 3-question quiz

   • Changing a live database: online indexes and schema changes

     11 min · 3-question quiz

   Practise · 0/1

   • Keyset pagination

     Runs in your browser

   Explore · 0/2

   • Transaction isolation

     Interactive simulation

   • Pagination

     Interactive simulation

   Watch · 0/3

   • 
     ACID Properties in Databases With Examples

     ByteByteGo · 5 min

   • 
     Distributed Transactions Explained: 2 Phase Commit vs Saga Pattern

     Hello Interview · 15 min

   • 
     Do you know Distributed transactions?

     Tech Dummies - Narendra Lakshmana Gowda · 31 min

   Read · 0/2

   • PostgreSQL: Using EXPLAIN

     PostgreSQL

   • PostgreSQL: Introduction to MVCC

     PostgreSQL

   0% done. At 80% this step counts as mastered.

2. 02ReplicationCopy data for availability and read throughput.0/10 done
3. 03ShardingPartition data when one node is not enough.0/12 done
4. 04MessagingDecouple producers and consumers with queues and logs.0/15 done
5. 05MicroservicesService boundaries, gateways and communication.0/10 done
6. 06Protecting servicesThrottle abusive traffic and secure APIs.0/13 done
7. 07Secure by designNetworks, browsers and APIs: the attacks you will face and the defences that stop them.0/11 done
8. 08Reliability and observabilityKnow when something is wrong, find out why, and fix it without making it worse.0/10 done

Master all 8 steps to earn the Scale Engineer badge and a grade. A step counts as mastered when you have done 80% of it. Lessons you finish, labs you pass and videos you watch on the site tick themselves.