Database Systems Courses and Certifications

CMU Database Group

Query Scheduling in Advanced Database Systems - Lecture 7

Explore query scheduling in advanced database systems, covering process models, memory access, partitioning, and execution strategies for optimal performance.

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

CMU Database Group

Distributed Analytical Database Systems - Lecture 23

Explore distributed analytical database systems, focusing on OLAP architectures, query execution, and optimization techniques for large-scale data processing and analysis.

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

CMU Database Group

Distributed Transactional Database Systems - Lecture 22

Explore distributed transactional database systems, covering coordination, commit protocols, fault tolerance, and replication strategies for robust and scalable data management.

• YouTube
• 1 hour 23 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

CMU Database Group

Relational Model and Algebra - CMU Intro to Database Systems - 01

Explore the foundational concepts of relational databases and algebraic operations that form the backbone of modern database systems.

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

Database Management Systems Part 3 : SQL Interview Course

2306 ratings at Udemy

Learn SQL from scratch as SQL is widely used in IT / Computer Science / Software Field

• Udemy
• 9 hours 46 minutes
• Self-Paced
• Paid Course

CMU Database Group

Sorting and Aggregation Algorithms in Database Systems - Lecture 11

Explore sorting and aggregation algorithms in database systems, featuring insights on dbt from Drew Banin. Gain practical knowledge on efficient data processing techniques.

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

Multi-Region, Multi-Primary, and Eventually Consistent Database Systems

Explore a clever implementation of multi-region, multi-primary databases with eventual consistency using service mesh and open policy agent. Learn benefits for financial trading and auctions.

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

CMU Database Group

Concurrency Control Theory in Database Systems - Lecture 16

Dive into database concurrency control theory and explore Firebolt's innovative approach to managing simultaneous transactions in modern database systems, featuring insights from industry experts.

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

CMU Database Group

Query Execution and ClickHouse Database Systems - Part 2

Dive into advanced query execution concepts and ClickHouse database architecture, covering optimization techniques, processing strategies, and real-world database system implementations.

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

CMU Database Group

Query Planning and Optimization in Database Systems - Lecture 15

Dive into advanced database concepts focusing on query planning strategies, optimization techniques, and execution methods for improved database system performance.

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

CMU Database Group

Database Logging and Recovery Systems - Lecture 20

Dive into database logging fundamentals and advanced concepts with expert insights from CMU and Confluent, covering system recovery, durability, and practical implementations.

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

CMU Database Group

Optimistic Concurrency Control in Database Systems - Lecture 18

Delve into optimistic concurrency control mechanisms and timestamp ordering protocols in database systems, featuring a special segment on Weaviate vector database implementation.

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

Big Data Demystified

High Performance, Low Latency Database Architecture - Modern Distributed Systems

Dive into modern distributed database architecture, exploring high performance, consistency, replication, and scaling concepts through practical examples from ScyllaDB and Cassandra implementations.

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

OSACon

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Explore strategies for optimizing concurrent OLAP and OLTP workloads, focusing on ScyllaDB's workload prioritization features to achieve harmonious performance in distributed systems.

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