Program Overview

Database Management Systems - CMPT 2091

Course Description

Students will be introduced to the core concepts of data systems used in modern organizations, including the relational model; Structured Query Language (SQL); database modelling, design, and administration; database processing applications; and big data concepts and tools.

Course Details

Course Code

CMPT2091

Credits

3

Format and Length

• Lecture: 45 hours
• Lab: 36 hours

Prerequisites and Restrictions

• Prerequisite: A minimum grade of C in CMPT 1011
• Restricted to Machine Learning Analyst, Arts and Sciences Diploma, and Open Studies

Delivery Methods

• In person
• Hyflex

This course is delivered in a classroom setting with face-to-face instruction at regularly scheduled times.

Term and Schedule

Edmonton

• Fall: Sep. 2 - Dec. 12, 2025
  • Mon, Wed: 05:00 - 06:30 pm
  • Class: 40376
  • Section: A02
  • Open Studies: No
• Winter: Jan. 5 - Apr. 17, 2026
  • Tue, Thu: 06:00 - 07:30 pm
  • Class: 10320
  • Section: A01
  • Open Studies: No

Additional Information

• For each course session or class time, you can choose to attend in person, online in real-time, or watch a previously recorded session.
• This course can be taken through Open Studies or through one of our many programs.