FULL-TIME | WINNIPEG LOCATIONS BUSGF-DP Business Information Technology

Courses and Descriptions

DBMS-2006Database Management Systems 2

This course builds on the material covered in the Introduction to DBMS course. The course covers advanced topics including how to import data into a database table, export table data to operating system files, automating the execution of SQL scripts using DOS batch files, format output to into readable reports, perform advanced object creation and maintenance, control user accounts and manage user privileges. Students spend considerable time learning and practicing PL/SQL, an embedded procedural language. They will design, test, and debug user stored procedures and cursors; as well as use exceptions effectively. They develop a solid knowledge of the Oracle system catalogue. The importance of transaction processing is covered. Students will learn how to implement transaction processing in on-line tools, within PL/SQL code and user written applications.

Prerequisites

Page produced on 2020-11-25 02:46:59
Red River College endeavours to provide the most current version of all program and course information on this website. Please be advised that classes may be scheduled between 8:00 a.m. and 10:00 p.m. The College reserves the right to modify or cancel any course, program, process, or procedure without notice or prejudice. Fees may change without notice.