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

Courses and Descriptions

DBMS-1002Database Management Systems 1

This course explores Database Management Systems used to store information. After an introduction to key database concepts, the student will learn how to develop and read an Entity Relationship Diagram (ERD), used to represent the database graphically.  The majority of the course covers Structured Query Language (SQL).   Data Definition Language (DDL - a subcomponent of SQL) is covered to create the physical database on disk.  Data Manipulation Language (DML - also a subcomponent of SQL) is introduced to allow for manipulation of the data stored in the database. Finally, the Normalization process is discussed and applied to the ERD’s and database tables.
Page produced on 2020-11-25 02:20:54
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.