Physical Database Design

Entity-Relationship Model

Relational Model

Relational Algebra

Relational Calculus

Tree-Structured Indexes

File Organizations & Indexing

Hashing

External Sorting

Relational Operators

Query Optimization

Schema Refinement and Normalization

Transaction Management

Concurrency Control

Crash Recovery

Distributed DBMSs

Column Stores

Data Warehousing

Data Mining

15-415/615 Database Applications Carnegie Mellon University Fall 2016 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 topics:

- Introduction to Databases
- Data Models
- Query Language (SQL)
- Database Design
- Query Optimization & Indexing
- Transaction Management
- Advanced Topics 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  Raghu Ramakrishnan, Johannes Gehrke, "[Database Management Systems](http://www.amazon.com/Database-Management-Systems-Raghu-Ramakrishnan/dp/0072465638/ref=ed_oe_h)," McGraw-Hill 2002 (3rd ed).


15-415/615 Database Applications

Database Systems

Physical Database Design

1 courses cover this concept

15-415/615 Database Applications