CMU Intro to Database Systems Course

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

These courses are focused on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). Case studies on open-source and commercial database systems will be used to illustrate these techniques and trade-offs. The course is appropriate for students with strong systems programming skills.  There are 26 videos associated with this course which was originally offered in Fall 2018 as Course 15 445/645 at Carnegie Mellon University.  

Authoring Person(s) Name: 
Andy Pavlo
Authoring Organization(s) Name: 
CMU Database Group
License - link to legal statement specifying the copyright status of the learning resource: 
Standard YouTube License
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
More info about
Keywords - short phrases describing what the learning resource is about: 
Data coding
Data handling
Data management planning tools
Database design
Database models
Standard Query Language (SQL)
Published / Broadcast: 
Wednesday, August 29, 2018
Publisher - organization credited with publishing or broadcasting the learning resource: 
Carnegie Mellon University
Version - revision or edition number or date associated with a learning resource: 
Last updated on December 6, 2018
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Presentation - representation of the particular way in which an author shows, describes or explains one or more concepts, e.g., a set of Powerpoint slides.
Contact Person(s): 
Andy Pavlo
Contact Organization(s): 
CMU Database Group
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Course - series of units and lessons used to teach the skills and knowledge required by its curriculum.
Target Audience - intended audience for which the learning resource was created: 
Graduate student
Undergraduate student
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 Week