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

Courses and Descriptions

DBMS-3006Database Management Systems 3

This course covers administrative aspects of Database Management Systems (DBMSs) and explores central topics in Data Science (DS). The first part of the course will introduce the fundamental installation components of a DBMS. Students will install and configure several DBMSs on traditional private server hardware to gain knowledge of the similarities, differences, and tuning parameters of various vendor software. Students will also provision a cloud-based DBMS service and integrate with a local DBMS to demonstrate a hybrid environment. The second part of the course will examine core concepts of Data Science that include extracting, cleaning, and basic data analysis on a variety of disparate data sources with an end goal of loading the data into a DBMS for further traditional OnLine Transaction Processing (OLTP). By the end of the course, students will be able to install and configure various DBMS software on private server hardware, provision and integrate a cloud-based DBMS service to support hybrid setups, clean and load data from disparate sources into a DBMS, and perform some basic statistical analysis on the data prior to loading.

Prerequisites

Page produced on 2020-10-29 09:06:48
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.