0 or 3 credits
Spring 2026 Lecture Practice Study Observation Distance Learning Upper Division
An in-depth examination of relational database systems including theory and concepts as well as practical issues in relational databases. Modern database technologies such as object-relational and Web-based access to relational databases. Conceptual design and entity relationship modeling, relational algebra and calculus, data definition and manipulation languages using SQL, schema and view management, query processing and optimization, transaction management, security, privacy, integrity management.
Learning Outcomes1Learn data modeling: physical, logical and conceptual data models, the entity-relationship model.
2Study logical and Physical Design and interaction with operating systems, disk Storage, Basic File Structures, Hashing, Indexing.
3Learn the relational database model and implementation and performance issues.
4Understand transaction Processing, concurrency control, atomicity control and recovery control.
5Understand database privacy, integrity, and security.
6Understand data mining, data warehousing, online analytical processing, and information retrieval.
7Understand Cloud computing and Distributed Database Systems architectures, Big Data, Hadoop, MapReduce, and NoSQL.
8Recognize performance issues.
Prerequisites
Restrictions
GPA by professor
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
No grades available
made by Purdue students.