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 policies for users and have 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
- 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: firstname.lastname@example.org
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 Flexible Learning.
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 Flexible Learning 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 Flexible Learning is a 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.
All Computing Flexible Learning 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.
Computer hardware and Internet requirements
Students must provide a current model PC desktop or laptop with a webcam, microphone and have high-speed internet access. COMP courses may use two-way audio and video as well as group work outside of class.
Participants must be computer literate in order to participate and complete each COMP course. Please contact the department via email: email@example.com if you have any questions.
ADAD may be completed with as few as 8 courses, however delivery was designed for 1-2 courses per term. Due to prerequisites and scheduling it is typically not possible to complete this part-time program in less than 3 terms, at night and on weekends.
Note: Part-time Studies was not designed for full-time delivery or for those on funding timelines.
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 databases 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.
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.
ADAD students surveyed have reported very high satisfaction with the program.
Please check the graduation reports and BC Student Outcomes for details.
Students who completed ADAD have partial course credit in ADAC.
Graduate outcome survey highlight
100% of grads found the program useful for getting their job [PDF]
ADAD was created by Kevin Cudihee, Program Head of BCIT Computing Flexible Learning and Industry Services.
BCIT Computing Flexible Learning database courses are delivered by subject matter experts who work in the field as database design, administration and business intelligence professionals.
ADAD courses were developed by Kevin Cudihee in conjunction with subject matter experts: Frank Wegener, Alexander Volkov, Ed Rubuliak, Glen Elliott, Gordon Hamilton, Cathy Michitsch, Donabel Santos, Ahmad Chamy, Masoud Fereidonian, and Marin Kostadinovic.
This credential was approved by the Computer Systems Technology, CST Curriculum Committee, and School of Computing and Academic Studies Quality Committee, SQC.
Please email BCIT Computing Flexible Learning:
General Inquiries: 604-432-8465
Questions or comments?
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.