Course Websites
CS 411 - Database Systems
Last offered Spring 2025
Official Description
Related Faculty
Course Director
Text(s)
Database Systems: The Complete Book, 2nd Edition, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom
Learning Goals
Analyze real-world data management scenarios and design appropriate data schemas (1), (2), (3), (4), (5), (6)
Formulate SQL queries to access a relational database system (1), (2), (5), (6)
Design and develop data management applications using relational database systems (1), (2), (3), (4), (5), (6)
Analyze and apply data indexing techniques for speeding up query processing (1), (2), (5), (6)
Analyze and apply query optimization techniques for optimizing query execution (1), (2), (5), (6)
Analyze and apply transaction processing techniques for executing transactions in relational database systems (1), (2), (5), (6)
Topic List
Data modeling principles and E-R Diagram Techniques
Relational Algebra
SQL Query Language
Data Storage and Indexing
Query Execution and Optimization
Concurrency Control & Failure recovery
Required, Elective, or Selected Elective
Selected Elective.
Schedule and Instructors
Title | Section | CRN | Type | Hours | Times | Days | Location | Instructor |
---|---|---|---|---|---|---|---|---|
Database Systems | CSP | 69453 | PKG | 3 | 1230 - 1345 | R | ARR Illini Center | Kevin Chenchuan Chang |
Database Systems | CSP | 69453 | PKG | 3 | - | Kevin Chenchuan Chang | ||
Database Systems | DSO | 67992 | ONL | 4 | - | Kevin Chenchuan Chang | ||
Database Systems | MC4 | 69362 | PKG | 4 | 1230 - 1345 | R | ARR Illini Center | Kevin Chenchuan Chang |
Database Systems | MC4 | 69362 | PKG | 4 | - | Kevin Chenchuan Chang | ||
Database Systems | N3 | 31352 | LCD | 3 | 1230 - 1345 | T R | 0027/1025 Campus Instructional Facility | Abdussalam Alawini |
Database Systems | N4 | 31355 | LCD | 3 | 1230 - 1345 | T R | 0027/1025 Campus Instructional Facility | Abdussalam Alawini |