Course Overview
This is an introductory course on the development and management of relational database applications and business analytics. This course covers all of the phases of the enterprise database web application life cycle, and builds a hands-on system development using Database Management Systems. Appropriate technologies are used to build user interfaces for the database applications. Multi-dimensional data modeling is discussed, and Microsoft Power BI technologies are used to acquire, model, and visualize data.
Prerequisite(s)
Credits
3.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Design databases using MS SQL server.
- Develop data models using database normalization rules.
- Construct and run stored procedures using programming languages.
- Generate SQL code to search and manipulate databases.
- Design and build applications to automate business processes.
- Plan end-to-end business processes such as sales and purchasing.
- Develop interfaces to edit and display information.
- Acquire, Model, and Visualize data using Microsoft Power BI technologies.
Effective as of Fall 2025
Related Programs
Information Technology 1 (BSYS 3105) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Business + Media
- Business Information Technology Management (Enterprise Systems Management Option)
Diploma Full-time
- Business Intelligence
Associate Certificate Part-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.