Intermediate Database Programming

DMIT2019

  • Requisites: This course is available to students in the Digital Media and IT program. Prerequisites: CPSC1012 and DMIT1508.
  • Course Equivalencies:
  • Open Studies: Not Available
  • Credits: 4.50

This course will build upon the foundational database skills taught in DMIT1508 and will explore database programming using the most popular relational database in the world – Oracle. Students will utilise Oracle’s procedural language (PL/SQL) to develop modular, efficient, and maintainable database functions, procedures, packages, and triggers to solve complex business data problems. The students will also construct business application(s) using Oracle Forms, which is Oracle’s user interface to access an Oracle Database in an efficient and tightly coupled manner. While Oracle Forms may be a mature application development technology, it remains widely used by many organizations in Alberta and around the world.

View Course Outline

Upcoming Sessions

Class Section Dates
30324 OE01 May. 05 - Aug. 15, 2025
Delivery Status
Evening, Online Open
Meeting Times:
  • May. 5 to 16 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • May. 19 to 30 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • Jun. 2 to 13 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • Jun. 16 to 27 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • Jun. 30 to Jul. 11 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • Jul. 14 to 25 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM
  • Jul. 28 to Aug. 15 - Monday, Wednesday, Friday: 5:00 PM - 6:50 PM

All times shown are in MT

Notes: All of your course activity is done online and there is no requirement to be on campus.
Your classes are scheduled for certain dates and times.
All of the course components are taught by your instructor.
A waitlist is available for this section. Students may be auto-enroled from the waitlist if (1) space becomes available before the last date/time to enrol, and (2) that they currently satisfy all requirements for enrolment. Being on the waitlist does not guarantee enrolment in the section
This section is reserved for DMIT students in the COMPUTER SOFTWARE DEVELOPMENT - Evening Online Delivery concentration. Students in other DMIT concentrations are not able to enroll into this section prior to March 1, 2025. Enrollment will open to other concentrations after that date.