15-615 Database Applications

12 units, Carnegie Mellon University

This course covers the fundamental topics for Database Management Systems Database System Architectural Principles ACID properties data abstraction external, conceptual, and internal schemata data independence data definition and data manipulation languages, Data models entityrelationship and relational data models data structures, integrity constraints, and operations for each data model relational query languages SQL, algebra, calculus, Theory of database design functional dependencies normal forms dependency preservation information loss, Query Optimization equivalence of expressions, algebraic manipulation optimization of selections and joins, Storage Strategies indices, Btrees, hashing, Query Processing execution of sort, join, and aggregation operators, and Transaction Processing recovery and concurrency control.

Prerequisites: none listed

Courseweave needs JavaScript to show sections, workloads and planning tools.