This course on Intro to Database Systems covers topics such as the relational data model, relational algebra, advanced SQL, functional dependencies, normal forms, database storage, buffer pools, hash tables, query processing, sorting, joins, query optimization, concurrency control theory, distributed OLTP and OLAP systems, among others. The course aims to teach students the fundamentals of database systems, various database tools and techniques, and how to optimize queries for efficient data retrieval. The teaching method includes lectures, discussions, and hands-on assignments. This course is intended for students and professionals interested in gaining a comprehensive understanding of database systems and enhancing their skills in database management and optimization.
Overview
Syllabus
CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2017).
CMU Database Systems - 02 Relational Algebra (Fall 2017).
CMU Database Systems - 03 Advanced SQL (Fall 2017).
CMU Database Systems - 04 Functional Dependencies (Fall 2017).
CMU Database Systems - 05 Normal Forms (Fall 2017).
CMU Database Systems - 06 Database Storage (Fall 2017).
CMU Database Systems - 07 Buffer Pools (Fall 2017).
CMU Database Systems - 08 Hash Tables (Fall 2017).
CMU Database Systems - 09 Order-Preserving Trees (Fall 2017).
CMU Database Systems - 10 Query Processing (Fall 2017).
CMU Database Systems - 11 Sorting & Joins (Fall 2017).
CMU Database Systems - 12 Hash Joins & Aggregations (Fall 2017).
CMU Database Systems - 13 Query Optimization (Fall 2017).
CMU Database Systems - 14 Parallel Execution (Fall 2017).
CMU Database Systems - 15 Embedded Database Logic (Fall 2017).
CMU Database Systems - 16 Concurrency Control Theory (Fall 2017).
CMU Database Systems - 17 Two-Phase Locking (Fall 2017).
CMU Database Systems - 18 Index Concurrency Control (Fall 2017).
CMU Database Systems - 19 Timestamp Ordering Concurrency Control (Fall 2017).
CMU Database Systems - 20 Multi-Version Concurrency Control (Fall 2017).
CMU Database Systems - 21 Logging Schemes (Fall 2017).
CMU Database Systems - 22 Database Recovery (Fall 2017).
CMU Database Systems - 23 Distributed OLTP Systems (Fall 2017).
CMU Database Systems - 24 Distributed OLAP Systems (Fall 2017).
CMU Database Systems - 25 Barry Morris [NuoDB] (Fall 2017).
Taught by
CMU Database group
