Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Intro to Database Systems - Fall 2021

Carnegie Mellon University via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Effort

1 day 6 hours
Sessions

Self-Paced
Level

Intermediate

Found in

This course introduces database systems from the relational model and SQL through storage, indexing, query processing and optimization, concurrency control, logging, recovery, and distributed databases.

Syllabus

01 - Course Introduction & Relational Model (CMU Intro to Database Systems / Fall 2021).
02 - Intermediate SQL (CMU Intro to Database Systems / Fall 2021).
03 - Database Storage I (CMU Intro to Database Systems / Fall 2021).
04 - Database Storage II (CMU Intro to Database Systems / Fall 2021).
05 - Buffer Pools (CMU Intro to Database Systems / Fall 2021).
06 - Hash Tables (CMU Intro to Database Systems / Fall 2021).
07 - Tree Indexes (CMU Intro to Database Systems / Fall 2021).
08 - Index Concurrency Control (CMU Intro to Database Systems / Fall 2021).
09 - Sorting & Aggregations (CMU Intro to Database Systems / Fall 2021).
10 - Join Algorithms (CMU Intro to Database Systems / Fall 2021).
11 - Query Execution I (CMU Intro to Database Systems / Fall 2021).
12 - Query Execution II (CMU Intro to Database Systems / Fall 2021).
13 - Query Planning & Optimization I (CMU Intro to Database Systems / Fall 2021).
14 - Query Planning & Optimization II (CMU Intro to Database Systems / Fall 2021).
15 - Concurrency Control Theory (CMU Intro to Database Systems / Fall 2021).
16 - Two-Phase Locking Concurrency Control (CMU Intro to Database Systems / Fall 2021).
17 - Timestamp Ordering Concurrency Control (CMU Intro to Database Systems / Fall 2021).
18 - Multi-Version Concurrency Control (CMU Intro to Database Systems / Fall 2021).
19 - Database Logging (CMU Intro to Database Systems / Fall 2021).
20 - Database Recovery (CMU Intro to Database Systems / Fall 2021).
21 - Introduction to Distributed Databases (CMU Intro to Database Systems / Fall 2021).
22 - Distributed OLTP Databases (CMU Intro to Database Systems / Fall 2021).
23 - Distributed OLAP Databases (CMU Intro to Database Systems / Fall 2021).
25 - Final Review (CMU Intro to Database Systems / Fall 2021).