Database Engineering
4.0
(1)
17 learners
What you'll learn
This course includes
- 15.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 54 lessons • 15.5 hours of video
Database Engineering
54 lessons
• 15.5 hours
Database Engineering
54 lessons
• 15.5 hours
- How nested loop, hash, and merge joins work. 11:08
- How PostgreSQL parses the query and constructs the Parse Tree? 08:05
- PostgreSQL connection management and per-client process model explained 08:34
- Everything you need to know about CockroachDB w/ Ben Darnell | Ep 6 01:30:03
- What exactly is the HTTP protocol and how to write a new one from scratch? 14:30
- How indexes work in Distributed Databases, their trade-offs, and challenges 16:21
- Understanding Database Trade-offs - The RUM Conjecture - Paper Explained 08:17
- Picking the right string column datatype - CHAR vs VARCHAR vs TEXT 09:43
- The compression algorithm that powers all Time-series Databases 13:24
- How databases store and transmit integers efficiently using varint encoding 15:02
- How JunoDB is designed to be a highly secure database 12:12
- How JunoDB is designed to achieve six 9's of availability 13:31
- How JunoDB is designed to scale horizontally 16:24
- High level architecture and System Design of JunoDB 13:40
- Overview of JunoDB - an open source KV store by PayPal 17:38
- Datetime vs Timestamp datatype in databases - Which one is better and when? 13:10
- Understanding Phantom Reads Problem with hands on examples 12:38
- Why do databases store data in B+ trees? 29:43
- What are Embedded Databases and why do they exist? 15:57
- How does the database guarantee reliability using write-ahead logging? 22:06
- How do indexes make databases read faster? 23:25
- How to handle database outages? 30:38
- How PostgreSQL generates all possible query execution plans before choosing the best one. 08:33
- Architecture deep-dive of a Real-time Analytics Database | Rockset Internals 08:46
- How Converged Indexes makes Rockset super-efficient in all kinds of queries | Rockset Internals 11:02
- How Rockset executes query and scales the query compute horizontally on demand | Rockset Internals 09:55
- How Rockset achieves zero data latency and workload isolation at scale 13:07
- DragonflyDB Architecture Overview, Internals, and Trade-offs - hitting 6.43 million ops/sec 08:31
- How DragonflyDB implements "distributed" transactions in a shared-nothing setup 10:09
- Why DragonflyDB uses B+ Trees to implement Sorted Set instead of Skiplist like Redis? 09:13
- DragonflyDB does not use HashTables but DashTables to hold the data - a deep dive 13:40
- How BitBucket reduced master database load by 50% and also solved Read your Write consistency 18:45
- What are Reactive Databases and why DiceDB exists? 09:57
- What the heck is Storage-Compute Separation? | Aurora Paper Deep Dive - Section 1 17:09
- How Amazon Aurora Achieves Durability with Quorum Writes | Aurora Paper Deep Dive - Section 2 19:20
- How GitHub Sharded Their Databases Without Downtime and Broke Their Monolith 20:05
- How MySQL's Midpoint Insertion Strategy Prevents Cache Pollution 10:47
- When DB consumes more memory than it should, malloc might be the problem 13:28
- How OpenAI Handles 800 Million ChatGPT Users on a Single PostgreSQL Primary 13:56
- How Stripe Migrates Millions of Records and Schema with Zero Downtime and No Data Inconsistency 12:54
- How Stripe Scales MongoDB to 5 million Queries Per Second 19:18
- Why and How Is Single-Threaded Redis Fast and Can Handle Multiple Connections? | Redis Internals 22:04
- Writing a Simple TCP Echo Server - Step 0 to Build Your Own Redis | Redis Internals 16:25
- Wire Protocols, Why Are They Needed, and Redis' Wire Protocol - RESP | Redis Internals 15:49
- Implementing Redis' Wire Protocol - RESP | Redis Internals 14:38
- Implementing Redis' PING Command | Redis Internals 19:29
- Event Loops Internals And How Redis Handles Multiple Connects on a Single Thread | Redis Internals 21:15
- Implementing Event Loops | Redis Internals 26:29
- Implementing GET, SET, and TTL Commands in Redis | Redis Internals 22:09
- Implementing DEL, EXPIRE, and Cleanup in Redis | Redis Internals 27:23
- Key Eviction Strategies in Redis and Implementing Simple First Eviction | Redis Internals 20:24
- Implementing Command Pipelining | Redis Internals 22:00
- Implementing AOF Persistence | Redis Internals 21:05
- Object, Encodings, and Implementing INCR | Redis Internals 24:48
Take this course with you
Download the app to continue lessons from your phone anytime.
