Description
“Postgres Sharding: Complete Hands-On with Docker and Python” is a training course on sharding techniques, published by the online academy Udemy. You will explore the fundamentals of database sharding, understand how data can be distributed across multiple database instances, and discover strategies to enhance performance and scalability in data-intensive applications. You will learn how to configure PostgreSQL environments using Docker, connect database instances to Python applications, and implement practical sharding approaches for distributing queries and managing data efficiently. The course also covers key concepts such as selecting a shard key, data partitioning, query routing, and the challenges of maintaining consistency in distributed databases.
Through hands-on implementation and experimentation, you will gain insights into designing scalable database architectures and understand the trade-offs involved in managing distributed data. Whether you are a backend developer, a database engineer, or a software professional working with high-volume applications, this course offers a practical introduction to sharding in PostgreSQL and scalable database design. Throughout the course, you will determine when sharding is truly necessary, select an appropriate shard key, build a shard router in Python, migrate millions of records, test the database under heavy load, troubleshoot common sharding issues, utilize tools like PgBouncer and consistent hashing, and manage distributed data using Citus. This course provides a deep, practical understanding of how these concepts are applied in real-world scenarios, preparing you to professionally address system design questions and build scalable databases.
What you will learn in Postgres Sharding: Complete Hands-On with Docker and Python:
- Decide when a slow PostgreSQL database needs sharding, and when an index, a cache, a replica or partitioning is enough.
- Choose a shard key from real queries, and measure how evenly it spreads the data.
- Write a shard router in Python and move a million customers and 8.5 million orders into four shards.
- Load test a database with 64 concurrent checkout servers and read throughput and p95 latency correctly.
- Fix the classic sharding problems: fan-out queries, hot rows, connection limits and adding a shard.
- and …
Course specifications
Publisher: Udemy
Instructors: Roni Das
Language: English
Level: Introductory to Advanced
Number of Lessons: 16
Duration: 2 hours and 34 minutes
Course topics
Postgres Sharding: Complete Hands-On with Docker and Python Prerequisites
A laptop with Docker Desktop installed and running (Mac, or Windows with WSL 2), about 8 GB of memory for Docker and 10 GB of free disk
VS Code, or any code editor you like
Basic comfort with a terminal. You do not need to install Python: every file runs inside a container
Some SQL helps, but every statement is explained as we write it
Pictures
Postgres Sharding: Complete Hands-On with Docker and Python introduction video
Installation guide
After Extract, watch with your favorite Player.
English subtitle
Quality: 1080p
Downloadly link
Rapidgator link
File password (s): www.downloadly.ir
Size
1 GB