Part-time Associate Certificate 6994acert

Become a Database Expert One Course at a Time

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.

Program Entry

  • COMP 1002 or equivalent knowledge
  • BC High School Grade 12 English and Grade 12 Math, or equivalent knowledge.
Students in this program are required to have English reading, writing and speaking skills.

Specific prerequisites or equivalent knowledge are required for each course.

NOTE:

This program is aimed at mature students with other post secondary education, and work experience looking to validate their knowledge, or those with connections to potential employers.

It is not designed for those students just out of high school with no other education or work experience, those students should consider completing a Diploma or Degree in order to be well positioned in the job market.

Program declaration

Effective January 7th, 2016, Program Declaration requests must be completed online. A declaration fee will be assessed at the time of the request. BCIT will no longer accept paper Program Declaration requests starting January 7th, 2016. Students who submitted paper declaration requests prior to January 7th, 2016 are not required to pay the fee.

Declaring your Part-time Studies program ensures that BCIT is aware of your intent to complete a program as it is currently outlined. BCIT continuously reviews programs and implements changes based on industry and market trends. Program Declaration guarantees that credit for courses which are a part of your program will be honoured despite program requirement changes.

Program Declaration also provides the opportunity to apply for transfer credit.

It is not necessary to declare prior to registering in most part-time studies courses. It is a good idea to complete one or two courses before submitting your program declaration. Check your program's Entry page for specific requirements.

Upon approval, a program plan will be sent to you confirming your program of study.

Declare Now

Please allow approximately 8 weeks for processing.

Note: Please complete COMP 1630 before declaring your intent to complete this program. Your instructor will provide the program declaration form during this first course.

Costs & Supplies

All Computing Part-time Studies programs are course by course registration.

Course tuition in this program may be less than $3,600 depending on electives chosen.

Specific textbooks are required at an additional cost, some courses also have lower cost eBook options.

Students register and pay for available courses online, by clicking on the green block 'Add to Cart'.

Follow the directions to obtain a BCIT student number if you do not already have one.

NOTE:
Please register early to avoid disappointment, our database courses are very popular and fill weeks in advance.

Courses

Program matrix

Check current availability of courses for this program.

1. Required Courses (11.5 credits): Credits
  COMP 1630 Relational Database Design and SQL 5.0
  COMP 2831 Business Analysis and Systems Design 4.0
  COMP 3838 Data Warehouse Foundations for Business Intelligence 1.0
  COMP 3839 Data Quality Improvement 1.5
 
2. Complete any 13.5 credits from the following list of electives: Credits
  COMP 1288 IT Project Management 1.5
  COMP 2252 SAP Crystal Reports 3.0
  COMP 2253 SAP Crystal Reports Advanced 1.0
  COMP 2256 Visual Analytics for Business Intelligence with Tableau 3.0
  COMP 3771 PowerShell Scripting 3.0
  COMP 4661 MySQL Database Server Design and Administration 3.0
  COMP 4670 Oracle 11g Administration Workshop 1 4.0
  COMP 4671 Oracle 11g Administration Workshop 2 4.0
  COMP 4677 Microsoft SQL Server 2012 Administration 4.0
  COMP 4678 Microsoft SQL Server 2012 Development 4.0
  COMP 4679 Business Intelligence with SSRS, SQL Server Reporting Services 4.0
  COMP 4680 Business Intelligence with SSIS, SQL Server Integration Services 4.0
  COMP 4681 Business Intelligence with SSAS, SQL Server Analysis Services 4.0

*Credit will be granted for only one SQL Administration course (COMP 4661 or COMP 4677)

 
Total Credits: 25.0

Check current availability of courses for this program.

Transfer credit

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.

Program Details

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.

Industry certifications*

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.

Grading

The students will be given a grade for each course based on the listed competencies. In most cases each course carries a mark for individual work; several courses require team work, as well as an individual test. Assignments and exams will be used in the evaluation of students.

Program abandonment

  1. Students approved for a part-time studies program are expected to register and complete courses on a continuous basis.

  2. Where a student has not completed a course from their approved program of study over a period of three consecutive academic terms, then that student will be considered to have abandoned the program.

  3. Throughout the duration of the program, a student is permitted a maximum of five academic terms where they are not required to register and complete a course from their approved program of study. Students who exceed the five-term maximum will be considered to have abandoned the program.

  4. Students who have abandoned their approved program of study and wish to be reinstated will be required to submit a new Program Declaration form for a current credential. BCIT cannot guarantee that courses taken prior to this re-application will be credited towards the current credential.

BCIT Policy 5103 - Student Evaluation [PDF] permits a maximum of three attempts to successfully complete each course within a credential.

Graduating & Jobs

Graduate employment outcomes

The BCIT student outcomes reports present summary findings from the annual survey of former students administered by BC Stats one to two years after graduation. These reports combine the last three years of available results for the 2013-2015 BCIT Outcomes Surveys of 2012-2014 graduates and for Degree 2010-2012 graduates. The reports are organized into three-page summaries containing information on graduates' labour market experiences and opinions regarding their education. More detailed information can be accessed at the BC Student Outcomes website.

To view these results, you may need to have the Adobe Acrobat Reader installed in your Web browser.

Apply for graduation

Upon successful completion of all program requirements, complete an Application for BCIT Credential [PDF] and submit to Student Information and Enrolment Services.

Allow approximately six to eight weeks for processing.

All financial obligations to the Institute must be met prior to issuance of any credential.

Faculty, Advisors & Staff

BCIT Computing Part-time Studies database courses are delivered by subject matter experts who work in the field as database design, administration and business intelligence professionals.

Several of our instructors are graduates of BCIT's Computer Systems Technology, CST Diploma and Degree.

Our Database instructors are all computing graduates, with significant work experience in their field.

Advisory committee

This associate certificate was developed in conjunction with subject matter experts by Kevin Cudihee, Program Head for BCIT Computing.

Courses were developed and delivered by Frank Wegener, Ed Rubuliak, Pauline Panek, Cathy Michitsch, Sean Nelson, Donabel Santos, Mark Bacchus and Marin Kostadinovic.

This credential was approved by the Computer Systems Technology, CST Curriculum Committee and School of Computing an Academic Studies Quality Committee, SQC.

Contact Us

Please email BCIT Computing Part-time Studies:

Email: cstpts@bcit.ca

General Inquiries: 604-432-8465

Questions or comments?

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:

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

Subscribe

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.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

How To Apply

Subscribe

Contact Us

Information Sessions

Attend an upcoming information session for this program:

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Search Programs

Start With Just One Course