Welcome! This class focuses on the fundamental knowledge and theory of database and database management systems.
Announcement
- 2025-09-05 (Friday)
- Links to week 1’s video recordings and slides have all been updated to the Course Calendar page.
- Archive
Basic Information
Course Schedule
Course Calendar
Assignments
Assignment 0: Honor Code (Due: Wed, 09/10)
- Assignment 1: Apply SQL on real-world datasets (Due: Wed, 10/15)
- Assignment 2: TBD
Final Project Milestones
- Project - Part 1: Group formation & Ideation (Due: Wed, 09/17)
- Project - Part 2: TBD
- Project - Part 3: Final Submission (Due: Wed, 12/14)
Course Staff
- Instructor: Professor Dennis Wang (Computer Science)
- TAs: To be announced
Syllabus
Policies and background for CSCS10022, Introduction to Database Systems, (114-1 / Fall 2025). All syllabus content is subject to change, particularly prior to the start of the semester.
Course Description
Databases are at the core of modern application development. With structural data being the cornerstone across almost every domain of human activity, including financial transaction, scientific work, and digital public infrastructure, it is crucial to have database management systems that are carefully designed to be built and populated with data for different scenarios.
In this course, we will cover topics that are essential to database, including:
- Theory of relational data design (data models, relational models, entity-relationship (E-R) Modeling)
- Query languages (SQL, stored procedures)
- Efficient storage of data (database design, normalization, constraints, integrity)
- Indexing and performance (order preserving trees, hash tables, vector indexes, query processing and optimization)
For the detailed list of topics and schedule, please see the course calendar.