Topics

This introductory course covers relational databases in detail, and touches on some “advanced” material like non-relational representations and data mining. Other optional material is listed at the bottom.

Relational Databases (required of all students)

  • Querying Relational Databases
    • Relational Algebra
    • SQL (in some depth)
  • Contraints
    • Attribute and tuple constraints
    • Referential Integrity
    • General constraints (assertions)
  • Triggers
  • Universal Modeling Language (for conceptual database design)
  • Relational Design Theory
    • Functional Dependencies
    • Normal Forms
    • Design by Decomposition
  • Views
  • Indexing
  • Transactions
  • Non-relational
    • JSON
  • Data mining (e.g., association rules)

Optional Material (see the bottom of Schedule)

  • Multivalued Dependencies
  • Online Analytical Processing
  • Recursion in SQL
  • Authorization in SQL

I encourage you to pursue these optional topics. We have no second course in database where you might formally study non-SQL database schemes and other advanced database topics such as data mining, so I have included some rudimentary additional material on these topics in this course.