Designing Highly Scalable and Highly Available SQL Databases [Released: 1/14/2025]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 22m | 322 MB
Instructor: Dan Sullivan
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 22m | 322 MB
Instructor: Dan Sullivan
Relational databases are often used to manage large scale volumes of data so developers and data modelers need to understand scalable architecture and data modeling patterns.
In this course, Dan Sullivan—a data architect, data modeler and data scientist with decades of experience —begins with scalability requirements, particularly business requirements, data volumes and data growth. Next, the course moves on to examine database architecture and data modeling patterns followed by an in depth look at supporting scalable data ingestion. Querying, of course, is a crucial component of any database architecture. Learn about the differences between transactional and analytical queries and how we can use database resources like indexes and materialized views for improving performance. The course concludes with a discussion of DevOps for scalable relational databases so we can keep our databases performant and operating as expected.