Learning Outcomes

This page collects together all of the “outcomes” associated with individual modules. Outcomes identify what students will know and be able to do if they master the material.

At the end of this class, the successful student will:

Course-level outcomes

Students mastering the material in this course will achieve the following Student learning outcomes for the ICS undergraduate degree program

Understand how to succeed in ICS 321

Referencing modules: Introduction

Understand what is a database system

Referencing modules: Worlds of Database Systems

Understand the relational model of data

Referencing modules: The relational model of data

Understand query languages for databases

Referencing modules: Algebraic and logical query languages

Be proficient in SQL

Referencing modules: SQL

Be able to write a program that interacts with a DBMS server

Referencing modules: SQL in a server environment

Structure Data using Data Models

Referencing modules: High-level database models

Understand Data Normalization

Referencing modules: Design theory for relational databases

Understand constraints, views, triggers, and indexes in Databases

Referencing modules: Constraints, triggers, view, indexes

Understand query processing in DBMSs

Referencing modules: Query processing

Understand basic transaction processing concepts

Referencing modules: Transaction processing

Understand how data is stored and indexed in a DBMS

Referencing modules: Storage and indexing

Understand how to store & query semi-structured data

Referencing modules: Semi-structured data and XML