Important Notice: COVID-19 Institute response

Part-time Associate Certificate 6994acert

Become a Database Expert

Fall 2020 Delivery Mode: ONLINE
  • This program will be delivered online for the fall semester.
  • Your education is our priority and we will continue to deliver the applied instruction, collaborative experience, and industry connections that you expect from BCIT.

Applied Database Administration and Design, ADAD associate certificate from BCIT Computing is a sub-set of the CST/PTS Diploma.

ADAD covers the specification, development and design of Database Management Systems, and provides the foundation for several business intelligence, BI tools.

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.

Database administrators set 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 in best practices to implement administrative policies, security measures and develop plans for disaster recovery.

BI tools from SAP and Microsoft provide options in data mining for reporting and querying software. Explore the most popular visual data analytics tools; MS PowerBI and Tableau for decision making and business improvement.

ADAD graduates are able to develop integrated database technologies to industry standards for scalable and secure Information Systems. They are prepared to move on to the Applied Data Analytics Certificate, ADAC.

ADAD provides students with career ready skills

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.


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.

Students limited timelines:

COMP PTS courses have specific prerequisites, and these must be completed in the correct order.

Many required higher-level and elective courses may not be offered each term and some PTS courses are only offered once per year.

Please contact the department for course planning:


Students who require a minimum course load to retain eligibility for financial aid or international student status have no guarantees that PTS courses will be available. There is also no guarantee that the minimum required course credits can be sustained from term to term in Part-time Studies.

Most PTS courses fill quickly so space is not guaranteed and courses may be cancelled before term start if there is insufficient interest. This may impact both the number of courses a student is able to take in any term, and the time it takes to complete a PTS credential.

As a result, students may not be able to obtain the minimum credits they need or want in each term to continue in the program. Computing Part-time Studies were not designed for those attempting to complete a certificate program in a full-time delivery model of less than 2 years.

Students on limited timelines should instead apply to full-time programs at BCIT.

Important Notice: Computing Part-time Studies is course by course registration and was not designed for students on limited timelines. International students and those on funding timelines should instead apply to Full-time programs. Please read the details on the program entry page.

Program declaration

Declaring your Part-time Studies program ensures that BCIT is aware of your intent to complete a program as it is currently outlined and provides you the opportunity to apply for transfer credit.
Learn more about program declaration

To submit your declaration:

  • Answer all questions completely.
  • If required, convert transcripts and documents to PDF files.
  • Have a credit card ready to pay the application fee.
Declare Now

Upon approval, a program plan letter will be sent to you confirming your program of study. Please allow approximately eight weeks for processing.

Note: Please complete COMP 1630 before declaring your intent to complete this program.

Costs & Supplies

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

Please Note: Due to prerequisites and scheduling it is typically not possible to complete this program in less than 5 terms or 18 months.
Students on shorter timelines for funding or international students with study permits less than 2 years should consider other programs.

There are typically only 8 courses required to complete ADAD which can be completed in conjunction with ADAC..

Canadian and PR students should budget $6,000 for tuition and books, International students pay high tuition.

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

The average cost for each COMP PTS is around $500-$600 per course plus books.

Some Part-time Studies students may complete the ADAD over 4 terms or 1.5 years with 2 courses per term. This would equate to an average workload of 25+ hours per week between class time, reading and homework.

Attendance and participation are mandatory, students who skip classes or who do not participate may be dropped from a COMP course.

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

Students must have a personal computer with internet access capable of running MS Windows 10.


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 2156 Introduction to Microsoft Power BI 1.5
  COMP 2252 Crystal Reports 3.0
  COMP 2256 Introduction to Visual Analytics with Tableau 3.0
  COMP 3771 PowerShell Scripting 3.0
  COMP 4677 Microsoft SQL Server Administration 4.0
  COMP 4678 Microsoft SQL Server 2016 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
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

Computer hardware and Internet requirements
COMP courses are now conducted entirely online until further notice. Students must provide a current model PC desktop or laptop with a web cam, microphone and have high speed internet access. Courses will be delivered in real time and may use two way audio and video as well as group work.

Students must be computer literate and be able to log in during regular scheduled class hours in order to participate and complete each COMP course. Please contact the department via email: if you have any questions.

Students may complete ADAD with as few as 8 courses in around 2 years at night and on weekends.

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.

ADAD starts with 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:Project Management, Crystal Reports, Power BI, Visual Analytics with Tableau, PowerShell Scripting, 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.

*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.


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

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

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

  • 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.

  • Students who have abandoned their approved program of study and wish to be reinstated will be required to apply for program approval for a current credential. BCIT cannot guarantee that courses taken prior to this reapplication 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

ADAD students surveyed reported 98% satisfaction with the program and earnings of over $70,000 per year.

Students who completed ADAD have course credit in ADAC.

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 2017-2019 BCIT Outcomes Surveys of 2016-2018 graduates and for Degree 2015-2017 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 it 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

ADAD was created by Kevin Cudihee, Program Head BCIT Computing PTS and Industry Services.

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.

Advisory committee

ADAD courses were developed by Kevin Cudihee in conjunction with subject matter experts: Frank Wegener, Ed Rubuliak, Glen Elliott, Cathy Michitsch, Sean Nelson, Donabel Santos, Mark Bacchus, Marin Kostadinovic and Hessam Teimouri.

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:


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.


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


Contact Us

Information Sessions

Attend an upcoming information session for this program:

Explore all upcoming BCIT info sessions.

Big Info - At-home Edition

Attend our largest virtual info session from wherever you are. October 6-8 4 pm

Register Now

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Search Programs

Start With Just One Course