This page presents the “modules”, or the topics that are covered in this course.
Click on the tile associated with a module to go to a page containing that module’s contents.
How ICS 321 is organized.
Introduction to database systems.
Relations, tables, schemas, sets, cardinality.
Understanding query languages.
Introduction to Structured Query Language.
Introduction to SQL on servers.
Demonstrate your ability to integrate all of the material in this course so far.
Introduction to database modeling.
Introduction to normal forms.
Introduction to constraints, triggers, views, and indexes.
Introduction to ACID, concurrency control.
Using main, flash, disk, and tape storage and associated indexing strategies: B+ trees, hash-based, clustering
Query execution plans, plan enumeration, cost estimation, query optimization.
Schema variability, XML
Create your own DBMS-backed web application.
Demonstrate your ability to integrate all of the material in this course.