Skip to content
Hana L. Goshu
Teaching

Course materials

Database Systems

CS2030, Fall 2026

The design, implementation, and use of database systems, from the relational model and SQL through database design, storage, query processing, and transactions to the data systems behind AI applications.
  • Hana L. Goshu
  • Department of Artificial Intelligence, Shaggar Institute of Technology
  • Fall 2026, 11 weeks
  • Google Colab with SQLite
Weekly notebooksLive questionsTA access

Notebooks

Weekly notebooks

Each week has one notebook for both lectures, with the demonstrations from class and the exercises for the lab.

Week1
Latest
  1. Lecture 1Introduction to Database Systems
  2. Lecture 2The Relational Model and Relational Algebra
4 demonstrations13 exercises
Open in ColabDownload

Course plan

The term at a glance

The notebook of each week is released on Friday at 6:00 pm, after the second lecture of the week. Topics of later weeks may still change.

  1. 1

    Week 1

    • Lecture 1: Introduction to Database Systems
    • Lecture 2: The Relational Model and Relational Algebra
    Notebook ready
  2. 2

    Week 2

    • Lecture 3: SQL Basics and Table Definitions
    • Lecture 4: Joins and Aggregation
    Opens Friday 23 October at 6:00 pm
  3. 3

    Week 3

    • Lecture 5: Subqueries, Set Operations, and Views
    • Lecture 6: Transactions, Constraints, and Access
    Upcoming
  4. 4

    Week 4

    • Lecture 7: SQL from Python and Database Routines
    • Lecture 8: Recursive Queries and Data Analysis
    Upcoming

  5. Midterm exam I

  6. 5

    Week 5

    • Lecture 9: The E-R Model and Database Design
    Upcoming
  7. 6

    Week 6

    • Lecture 10: E-R Models to Tables and Extended Design
    • Lecture 11: Functional Dependencies and Normalization
    Upcoming
  8. 7

    Week 7

    • Lecture 12: Decomposition and Higher Normal Forms
    • Lecture 13: Storage, Files, Buffers, and Indexes
    Upcoming
  9. 8

    Week 8

    • Lecture 14: Query Processing and Optimization
    • Lecture 15: Transactions and Concurrency Control
    Upcoming

  10. Midterm exam II

  11. 9

    Week 9

    • Lecture 16: Recovery and Distributed Data
    Upcoming
  12. 10

    Week 10

    • Lecture 17: Complex Data and Knowledge Graphs
    • Lecture 18: NoSQL, Big Data, and Analytics
    Upcoming
  13. 11

    Week 11

    • Lecture 19: Vector Search, RAG, and Data Ethics
    Upcoming

  14. Final exam

Teaching assistants

Answer notebooks for the TAs

Complete answers and steps for every exercise, protected by the TA password.

TA access