BCIT is planning for a substantial return to on-campus activity for the fall 2021 term as informed by BC Public Health Officer guidelines. Refer to each course listing for details.
Course Details
In an information-based society, understanding data management is vital. The backbone of the Internet, Cloud Computing, and Business Intelligence are relational database management systems. The use and manipulation of data is the key to utilize business information to create a competitive advantage. This course introduces relational database management systems, data modeling, and artificial intelligence. Students will use Microsoft Access, a relational database management system, to create data models and build data applications. An introduction to Artificial Intelligence, Machine Learning, and Deep Learning tools and models will also be included in the course.
Please provide your current e-mail address upon registration. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation System. No class on October 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
This course offering is in progress and full. Please check back next term or subscribe to receive email updates.
No class on October 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
This course offering is in progress. Please check back next term or subscribe to receive email updates.
In Progress
Learning Outcomes
Upon successful completion of this course, the student will be able to:
Explain when and why a database should be created.
Understand and Use database terminology.
Construct a database using a relational database management system.
Design and modify tables.
Explain and illustrate the data modeling process using normalization.
Build table relationships to meet business requirements.
Create single table and multiple-table based forms.
Search, modify, and analyze data using queries.
Create and customize reports to summarize and gain insights into data.
Export/Import data in various formats such as csv and xlsx.
Describe Machine Learning (ML) concepts and algorithms.
Conduct ML experiments using MS Azure cloud platform.
Describe the benefits of Artificial Intelligence (AI) and Machine Learning (ML).
Compare various prediction models such as regression and classification.
Carry out ML experiments using dataset preparation, training, and testing modules.
Effective as of Winter 2021
Related Programs
BSYS 2061 is offered as a part of the following programs:
Interested in being notified about future offerings of BSYS 2061 - Business Data Management with MS Access 2019 for Windows?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.