Course Overview
This is an introductory course on the deveopment and mangement of relational database applications and business analytics. Students will design and implement relational databases using data modelling techniques, normalization, and structured query language (SQL). The course emphasizes hands-on development of database solutions, including querying, data manipulation, and implementation of business workflows using transactions Multi-dimensional data modeling is discussed, and Microsoft Power BI technologies are used to acquire, model, and visualize data.
Prerequisite(s)
Credits
3.0
Domestic fees
$743.23
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
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.
- Generate SQL code to search and manipulate databases.
- Construct and run stored procedures.
- Design and implement database-supported business processes.
- Use Power Query to extract, clean, and transform data from SQL server.
Effective as of Fall 2026
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
Course Offerings
Fall 2026
Below is one offering of BSYS 3105 for the Fall 2026 term.
CRN 52819
Dates
Sep 10 - Nov 26 Loading
- CRN 52819
- $743.23 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Please note that the lecture component for this course is asynchronous, not requiring you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. *** Please note that the exams are in person at the Burnaby campus as follows: Midterm: Thurs, Oct 15 1830 and Final: Thurs, Nov 26 at 1830
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
Winter 2027
Below is one offering of BSYS 3105 for the Winter 2027 term.
CRN 93962
Dates
Jan 04 - Apr 05 Loading
- CRN 93962
- $743.23 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Kousha Hashemi
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- *** Both the midterm and final exams will be held in person at the Burnaby campus as follows: Midterm: Monday, Feb 8 at 1800 & Final: Monday, April 5 1800 This is a synchronous online course, and you will be expected to be available and online on the posted days and times shown on your registration schedule. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies or more if it is a condensed course starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. No class on Monday, February 15 & Monday March 29
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.