Modules Topics covered in this class.

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.

1. Introduction

How ICS 321 is organized.

2. Worlds of Database Systems

Introduction to database systems.

3. The relational model of data

Relations, tables, schemas, sets, cardinality.

4. Algebraic and logical query languages

Understanding query languages.

5. SQL

Introduction to Structured Query Language.

6. SQL in a server environment

Introduction to SQL on servers.

7. Midterm

Demonstrate your ability to integrate all of the material in this course so far.

8. High-level database models

Introduction to database modeling.

9. Design theory for relational databases

Introduction to normal forms.

10. Constraints, triggers, view, indexes

Introduction to constraints, triggers, views, and indexes.

11. Transaction processing

Introduction to ACID, concurrency control.

12. Storage and indexing

Using main, flash, disk, and tape storage and associated indexing strategies: B+ trees, hash-based, clustering

13. Query processing

Query execution plans, plan enumeration, cost estimation, query optimization.

14. Semi-structured data and XML

Schema variability, XML

15. Project

Create your own DBMS-backed web application.