Courses may include
These are some of the courses offered in this program. It is not a complete list and courses are subject to change in advance of the academic year.
Recognizing prior learning / transfer credits
If you have previous learning (course, employment, etc...) that's relevant to your program, you may be able to apply to earn credit. Not all programs are eligible. Learn about our recognizing prior learning (RPL) process.
DBAS 2010 - Database Design II
This course extends the learners involvement with database design. The need for database design to be complete and to be able to capture all of the data will be emphasized. Design considerations affecting performance from hardware, networking, security, platform and architectural points of view will be discussed and addressed hands-on. The learner's exposure to a series of both initial design and re-engineering case studies will ensure that they are made aware of the importance of fast, reliable access to data in all organizational areas.
DBAS 2101 - Data Reporting
The course is designed to provide learners with the necessary skill background and understanding to be able to realistically assess data reporting requirements, migrate data from its sources to the reporting utility, and to author, manage and deliver traditional and interactive reports and visualizations. All applied work will be performed using current local industry standard platforms.
DBAS 2103 - Data Provisioning with ETL
The course is designed to familiarize learners with the process and methodologies used to provide data from data sources to a processing environment. Progression of skill is done in the end-to-end context of the ETL process. Learners will identify data sources based on analyzed client requirements, extract those data, perform cleansing, perform any necessary transformations, integrate and load the data to its end platform. Due to the fact that in production programmers may be applying all or any component of the ETL process, a variety of platforms will be used ranging from command line ANSI standard SQL to comprehensive ETL suites such as Informatica. Every platform choice will reflect current local industry standards.
DBAS 2104 - Business Analysis Essentials
This course teaches the fundamental business processes that govern the operation of any business. The focus is on the tools and methodologies used by business analysts to gather information regarding those operational processes and how the gathered information is used to support strategic and tactical decision-making in the business.
This fundamental understanding of the business and analysis is then used by the learners to accurately interpret the detailed business requirements that drive design and implementation of supporting IT products and services. Extensive use is made of real world case studies from the local area, including guest lectures from local business analysts. Tools and software used in the course will be chosen according to current local industry standards.
DBAS 4075 - Introduction to Business Intelligence
This course explains how to create, implement, and manage an enterprise BI solution. Topics covered include modelling, monitoring, and analytics capability. Learners build reports that foster informed business decisions. Solutions implement security and collaboration with communications utilities and mobile devices. Learners will cover preparation of reports using relational and dimensional data, and will use BI tools to perform statistical analysis.
DBAS 5010 - Structured Query Language for Analysts
This course will focus on DML (Data Manipulation Language) where students will build queries to satisfy aggregations, segments, and align to business strategies. Students also cover reporting data structure design, optimization, and maintenance using DDL (Data Definition Language).
DBAS 5015 - Introduction to Data Science
This introductory course will explore the practical methods and techniques of Data Science employed by analysts. Students will use industry standard tools to apply the most common machine learning algorithms used for predictive analytics (operational planning and forecasting).
DBAS 5020 - Applied Data Science
The primary focus of this course is on planning and forecasting, commonly referred to as predictive analytics. Students will apply Data Science methodologies to data sets and identify trends, patterns and abends in the analysis that can be used for better business decisions.
INFT 3000 - Capstone
Learners acquire hands-on experience on a group project applying much of the material learned throughout their program. Throughout this course, learners will apply their skills to prepare and deliver technical documentation and presentations using various media platforms.
INFT 4001 - Special Topics II
This course introduces one or more technology or research topics for discussion and exploration. Topic selection may vary from year to year, driven by the outside influences such as industry input, new technology trends, or learner interests.
INFT 5500 - Work Experience
This course is either a campus-based or external applied learning experience which may consist of work experience, directed studies, industry projects or applied research.
SAFE 1000 - Introduction to WHMIS (Workplace Hazardous Materials Information Systems)
This course offers learners basic overview of WHMIS principles and establishes a solid foundation to support workplace-specific training on the safe storage and handling of controlled/hazardous products. Upon successful completion of the course, students receive basic WHMIS certification.
SAFE 1001 - Introduction to NS OH&S Act
This course offers students an introduction to the Occupational Health & Safety (OH&S) Act of Nova Scotia, which is required by any person employed in a Nova Scotia workplace. This is a generic, introductory course that provides basic knowledge of the Act for students and is considered to be the basis from which more specific training can be given.