Database Architecture Courses and Certifications

Hussein Nasser

Optimizing Communication and Networking in Database Systems - The Backend Engineering Show

Examines how three-tier web architecture, connection pooling, and multiplexing reshape database communication and affect backend resource use and concurrency.

• YouTube
• 41 minutes
• Self-Paced
• Free Video

CMU Database Group

Database Recovery - Lecture 20

An introductory database systems lecture focused on database recovery.

• YouTube
• 1 hour 24 minutes
• Self-Paced
• Free Video

CMU Database Group

Database Logging - Lecture 19

Explores database logging within an introductory database systems course.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Free Video

CMU Database Group

Query Optimizer Implementations - Part 2 - Lecture 17

An advanced look at query optimizer implementations, from top-down and bottom-up search to Cascades-style transformation rules and optimal query plans.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video

CMU Database Group

Database Recovery with ARIES - Lecture 20

Learn database recovery with ARIES in an introductory database systems lecture.

• YouTube
• 1 hour 24 minutes
• Self-Paced
• Free Video

CMU Database Group

Database Logging and Shadow Paging - Lecture 19

An introductory lecture on database logging and shadow paging in database systems.

• YouTube
• 1 hour 22 minutes
• Self-Paced
• Free Video

CMU Database Group

Query Execution and Processing Part 2 - Lecture 5

Explore advanced query execution techniques, including vectorized processing and SIMD operations, for optimizing database system performance.

• YouTube
• 1 hour 25 minutes
• Self-Paced
• Free Video

CMU Database Group

Log-Structured Database Storage - SingleStore Database Talk - #05

Explore log-structured storage systems and their implementation in modern databases, featuring insights from SingleStore's architecture and design principles.

• YouTube
• 1 hour 19 minutes
• Self-Paced
• Free Video

CMU Database Group

Memory Management and Buffer Pools - CMU Intro to Database Systems #04

Explore memory management techniques and buffer pool optimization strategies for efficient database system performance and data storage.

• YouTube
• 1 hour 20 minutes
• Self-Paced
• Free Video

Oracle

First Principles: Inside MySQL HeatWave Lakehouse on OCI

Explore MySQL HeatWave Lakehouse's innovative architecture, enabling efficient processing of massive datasets with advanced features like adaptive sampling, smart scheduling, and automated query optimization.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Uptime, All the Time - Distributed SQL and Cloud Native Databases

Explore distributed SQL databases' architecture, features, and benefits for high availability and business continuity. Learn about data distribution, automated scaling, and location-based performance optimization.

• YouTube
• 55 minutes
• Self-Paced
• Free Video

ChariotSolutions

Choosing a System for Large-Scale Data Analysis - Hot vs Cold Approaches

Compare hot and cold data systems and explore how database architectures, Apache Druid, and query engines shape large-scale analytics.

• YouTube
• 40 minutes
• Self-Paced
• Free Video

SQLBits

Relational or Non-Relational? Choosing the Best Database for the Task

Explore strengths and weaknesses of relational and non-relational databases, with real-world examples to guide your choice for specific data storage needs.

• YouTube
• 19 minutes
• Self-Paced
• Free Video

SQLBits

Relational or Non-Relational? Choosing the Best Database for the Task

Explore strengths and weaknesses of relational and non-relational databases. Learn best use cases and real-world examples to make informed decisions for your data storage needs.

• YouTube
• 19 minutes
• Self-Paced
• Free Video

CMU Database Group

Rebuilding GlareDB from the Ground Up

Dive into the comprehensive rebuilding process of GlareDB, exploring architectural decisions, technical challenges, and innovative solutions in database system development.

• YouTube
• 1 hour 9 minutes
• Self-Paced
• Free Video