Computer Science
>
>

15-415/615 Database Applications

Fall 2016

Carnegie Mellon University

This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.

Course Page

Overview

Course topics:

  • Introduction to Databases
  • Data Models
  • Query Language (SQL)
  • Database Design
  • Query Optimization & Indexing
  • Transaction Management
  • Advanced Topics

Prerequisites

No data.

Learning objectives

Students will learn the fundamentals of database management systems.

  • When to use them
  • How to model data with them
  • How to store and retrieve information
  • How to search quickly for information
  • System internals & key algorithms

Textbooks and other notes

Raghu Ramakrishnan, Johannes Gehrke, "Database Management Systems," McGraw-Hill 2002 (3rd ed).

Other courses in Database Systems

Courseware availability

Slides available at Syllabus

No videos available

Assignments and solutions available at Assignments

Other resources available at Assignments

Covered concepts