Learn industry standards for data modelling, database design and tools for business intelligence.
This associate certificate from BCIT Computing covers the specification, development and design of Database Management Systems, DBMS which provide the foundation for business intelligence tools.
This program offers core courses from the CST Diploma plus a variety of industry electives including visual analytics and business intelligence.
Students may complete this BCIT credential program with as few as seven courses in less than two years at night and on weekends.
Database designers must understand relational database theory, data modelling, industry standards, SQL programming and administration.
They may also work in teams to design enterprise wide, scalable information technology solutions for the public and private sectors.A database administrator sets polices for users and has a responsibility to ensure that the entire information system is protected from any loss, compromise or failure.
Hands-on labs and exercises guide students to design, develop and install database servers, they learn how to implement administrative policies, security measures and develop plans for disaster recovery.
Business intelligence tools provide options in data mining for reporting and querying software. Topics include how to extract, sort, summarize and present data.
Explore the latest tools used to create digital dashboards to provide visual data analytics for decision making and business improvement.
Graduates of this program are able to develop integrated database and business intelligence technologies to industry standards for scalable and secure Information Technology solutions.
Do you have credits from another BC/Yukon post-secondary school? Do you want to know if they transfer to courses here at BCIT? Check out BCIT's Transfer Equivalency Database to find out.
The foundations of this program include group work, plus how to communicate technical system specifications in writing and make oral presentations in a team environment.
New and more electives:
After completing the core courses in Relational Database Design with SQL, Business Analysis and Systems Design and Data Warehouse Foundations for Business Intelligence, students have a variety of elective choices based on current technologies.
A series of follow-on elective courses provide options to understand multiple
relational database and reporting technologies. These include:
IT Project Management, Crystal Reports for Business Intelligence, Visual Analytics for Business Intelligence with Tableau, Windows Shell Scripting, MySQL, Oracle, plus five different Microsoft SQL Server related business intelligence options.
Several of these elective 'COMP' courses help students prepare to challenge current industry/vendor credentials.
BCIT Computing is connected to industry and is part of MSDNAA, Microsoft Developer Network Academic Alliance.
We provide specific Microsoft server software for registered students to install the on their personal machines for use in coursework. Database COMP courses include some preparation for related Microsoft exams.
As a member of the Oracle Workforce Development Program, we use Oracle University course materials which fulfill the 'Instructor Lead Training' requirement for Oracle 11g certification.
We are also pleased to support Open Source and offer MySQL Server certification preparation.
*Industry exams are independent from BCIT credentials. These exams may be purchased for additional costs, from various third parties.
Students will also require additional preparation and studying in order to pass these industry certification exams.
Please ensure you have reviewed the detailed information on this site, using the navigation to the right, before submitting the form below.
As well, if you meet any of the following criteria, please follow the links for more information, instead of sending the form:
Sign up to receive updates, invitations to events, and information about BCIT and your program.
We promise not to spam you, we won’t share your personal information, and you can unsubscribe at any time.
Programs and courses are subject to change without notice.