From the course: Designing Highly Scalable and Highly Available SQL Databases

Challenges to scaling relational databases

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Challenges to scaling relational databases

“

- [Dan Sullivan] Welcome to this course on designing highly scalable and highly available relational databases. The first step in any database design is to understand requirements, particularly those related to specific functions, but also nonfunctional requirements like scalability and availability. Now, after we learn about requirements gathering and assessment, we'll learn how to turn those into data architectures and data models. Next we'll examine in detail, the problem of data ingestion at scale. And we're going to describe patterns to support a variety of ingestion patterns from high speed streaming to bulk loading. Now database design is highly influenced by query patterns. So we'll discuss optimization techniques for both transaction processing and analytical databases. We'll conclude with a review of supporting practices like monitoring, logging, and data life cycle management. By the end of this course, you will have a broad and well-grounded overview of the essential elements of designing and implementing highly scalable and highly available relational databases. So let's get started.

Contents