Computing Science

CMPUT 291 - Introduction to File and Database Management

Overview

Databases are part of our everyday life. Whether we are accessing our bank accounts, paying bills, searching the Web or calling a call centre, our requests are most likely posted to a database management system.

CMPUT 291 is the first course in the series of undergrad courses in databases offered by the Department of Computing Science of the University of Alberta. It teaches a paradigm shift from "computation" to "information" and covers some of the core concepts on data structuring and querying.

Objectives

After this course, you should be able to:

  • Model and store data within a database management system (DBMS) such as Oracle's
  • Formulate queries in SQL
  • Write applications that store and access data in a DBMS
  • Have a basic understanding of database indexes and the way data is organized and accessed within a DBMS

Course Work

  • Assignments
  • Mini-Project(s)
  • Lecture and lab quizzes
  • Midterm Exam
  • Final Exam