Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Backend flows explained deeply
·
Module 5
Database Internals: How Data is Stored and Retrieved
1
Disk Storage: Pages and Rows
Explain how a relational database stores data on disk using pages and rows.
2
B-Tree Indexing: Under the Hood
Describe how B-tree indexes work internally to speed up lookups, insertions, and deletions.
3
B-tree vs. Hash Indexes: When to Use Which
Compare B-tree indexes with hash indexes and explain when each is appropriate.
4
ACID Properties of Database Transactions
Define the ACID properties and explain what each guarantees for a database transaction.
5
Understanding Transaction Isolation Levels
Describe transaction isolation levels (e.g., Read Committed, Serializable) and their trade-offs.
6
Understanding Connection Pooling for Backend Performance
Explain what connection pooling is and why it is critical for backend performance.
7
Mastering PostgreSQL EXPLAIN
Use `EXPLAIN` in PostgreSQL to read and interpret a query execution plan.
8
Analyzing Execution Plans for Slow Queries
Identify common causes of slow queries (e.g., full table scans, N+1 problems) from an execution plan.
Previous module
Web Servers and Application Runtimes
Next module
Advanced Database Patterns and Optimization