Applied Database Administration and Design

Associate Certificate Part-time School of Computing and Academic Studies

Declare Now Contact Us

Related programs

Data Analytics and Business Intelligence

Info sessions

Attend an upcoming information session for this program:

March 23rd at 5:30pm

Explore all upcoming BCIT info sessions.

Blog

“Every organization that I know – big or small, from social non-profits to manufacturing – runs on data, and studies have shown that 20-35% of the average organization’s operating revenue is lost every year due to poor data quality. The cleaner the data, the better your modeling will be, and the better your bottom line.”

Gordon Hamilton, Instructor and Senior Data Quality Specialist, EA

Overview

Validate your Database Administration skills with ADAD.

Applied Database Administration and Design (ADAD) associate certificate from BCIT Computing is a sub-set of the CST FLEX Diploma.

ADAD covers the specification, development and design of Database Management Systems (DBMS), the skills for Database Administration (DBA) roles and introduces Data Visualization and 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 (DBAs) set policies for users and have a responsibility to ensure that the entire information system is protected from any loss, compromise or failure. They also control access to data systems by managing user accounts, and who may access what data with the ability to read or write that data.

Hands-on labs and exercises guide students in best practices to implement administrative policies, security measures and develop plans for disaster recovery.

Electives include BI tools with options in data mining for reporting and querying software, plus 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. Some students who have worked in DBA roles may want consider completing the Applied Data Analytics Certificate (ADAC) which is focused on statistical data analysis, related tools and systems.

ADAD provides students with career-ready DBA skills

Entrance Requirements

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.

Students limited timelines:

COMP FLEX 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 courses are only offered once per year.

Please contact the department for course planning: cstflex@bcit.ca

IMPORTANT NOTICE:

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

Most COMP and MATH 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 Flexible Learning 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.

International applicants

This program is not available to international students. View available programs

Program declaration

Declaring your Flexible Learning (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.

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.

Learn more about program declaration

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

Costs & Supplies

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 7 courses required to complete ADAD, several of which also provide the database foundations for the Applied Data Analytics Certificate (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.

NOTE: 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 high-speed internet access capable of running MS Windows 11.

Courses

Program matrix

Check current availability of courses for this program.

1. Required Courses (17.5 credits):			Credits
	COMP 1630	Relational Database Design and SQL This intensive, hands-on course is the prerequisite for all advanced database courses in BCIT Computing programs. COMP 1630 is equivalent to the Full-time CST and CIT Diploma database courses and provides an introduction to relational database design concepts and industry standards. Students learn the tools and processes for data modeling in Relational Database Management Systems (RDBMS) in a Windows PC lab environment. They also focus on the Structured Query Language, SQL to define and manipulate data. Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation. Advanced topics include: an introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. Current trends in database such as replication, object-relational DBMS, data warehousing, OLAP- online analytical processing and database uses web technology are discussed. Students in COMP 1630 are required to attend one face to face meeting each week, participate in group work, and an online component, plus complete reading and assignments outside of class. Upon successful completion, participants will be able to design and implement a database application and be prepared to move on to higher level database courses including: Data Warehouse, Data Quality, MySQL, MS Business Intelligence, MS SQL Server and Oracle. Prerequisite(s): COMP 1002 course outline	5.0
	COMP 2831	Business Analysis and Systems Design Business Analysis and Systems Design is the study of concepts, processes and tools that professionals use to plan and develop information systems to industry standards. Computer Systems Certificate, CSC students must complete COMM 1103 or COMM 1106 prior to COMP 2831. This course assumes that all participants have strong English communication and interpersonal skills. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Beginning with an introduction to the Software Development Life Cycle (SDLC), students work in teams to initiate the system process, analyze problems, discover requirements and create a logical design. Participants will work in groups to ask implicit questions in order to make better decisions. They will then document detailed communication plans prior to developing an information system. COMP 2831 provides the foundation for all BCIT Computing development credentials. Topics include: techniques used in the discovery of business requirements, traditional approaches to data and process modelling. There is an overview of Object-Oriented Modelling techniques using the Unified Modelling Language (UML) as well as an introduction to Project Management. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. Students may have an average total time commitment of 13+ hours per week; 3 hours of synchronous class time, a 1-hour online component, plus 9+ hours of homework each week. Participants work in groups, to provide detailed written materials and to make presentations of their designs. Upon completion, successful students will be able to use industry standard tools and methods to analyze, design, document, present, implement information systems and move on to COMP 2833 Agile Methods and the Scrum Framework. Prerequisite(s): 60% in COMP 2501 or 60% in COMP 1630 course outline	4.0
	COMP 3771	MS PowerShell Scripting Microsoft PowerShell is a popular task automation and configuration framework. PowerShell includes scripting tools to automate and control systems, programs and files to improve productivity and reduce effort in all aspects of Windows computing. COMP 3771 is a hands-on lab course aimed network or database administrators and software developers. PowerShell scripts are used for network or database automation, monitoring and maintenance, and can also automate tasks for testing software programs and rapid application development. Starting with a basic introduction to scripting with the Command Prompt window, the course then focuses on how to use MS PowerShell with Windows. There will be a brief overview of using Azure resources in PowerShell. COMP 3771 is an elective in the Applied Network Administration and Design, and Applied Database Administration and Design Associate Certificates, plus the CST FLEX Diploma. Students must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Successful participants will be able to automate many tasks with Microsoft PowerShell and reduce repetitive tasks by creating scripts that can run interactively or automatically. This course is offered in April (spring/summer) and September (fall) terms. Prerequisite(s): 60% in COMP 1516 or 60% in COMP 1630 or 60% in COMP 3700 course outline	3.0
	COMP 3839	Data Quality Improvement Continuing on from COMP 1630 this course is aimed at students who already understand relational database, data modeling and the importance of improving Data Quality (DQ). Survey topics include the business impact of DQ, data profiling techniques, DQ capability/maturity models, Data Governance, DQ improvement roadmaps and approaches to gaining executive support for the DQ improvement program. In class labs, homework assignments and a project focus on how to use Data Quality techniques and tools. Successful participants learn how to apply a data quality framework to data migration projects and are better prepared to move on to the specific Business Intelligence Analytic tools covered in: COMP 4679 and COMP 4681. Prerequisite(s): 60% in COMP 1630 course outline	1.5
	COMP 4677	Microsoft SQL Server Administration Following on from COMP 1630, students who already understand data modeling, relational database design and SQL are provided with an in-depth understanding of designing MS SQL Server 2016 databases. This hand-on course is SQL Server 2016 specific, so those who have taken MS SQL 2000/2005/2008/2012 will also benefit and be able to better plan migration to SQL Server 2016. Topics include: architecture, installing and configuring SQL Server, physical database design, creation, maintenance, security, and high availability solutions. Exercises and labs focus on creating, deploying, optimizing and maintaining enterprise SQL Server 2016 databases to help students obtain an understanding from a database administrator perspective. Successful participants will learn to install and configure SQL Server 2016, to plan and set policies for system access, end-users, back-ups, disaster recovery, and to troubleshoot and to manage database security. Prerequisite(s): 60% in COMP 1630 course outline	4.0

2. Complete any 4.5 credits from the following list of electives:			Credits
	COMP 1288	IT Project Management Fundamentals This hands-on course is aimed at BCIT Computing students who want to develop and implement an IT project plan. Students focus on Project Management best practices and decisions which apply across the IT sector including software development, building web sites and data analytics systems. COMP 1288 begins with a definition of Project Management fundamentals and terminology. Topics include: stakeholders, scope, deliverables, phases, milestones, deadlines, scheduling, estimates and budgets. Labs and exercises are designed to create project plans that identify and manage risk and take into account quality measures. There is a basic introduction to Microsoft Project software. Participants apply strategies to communicate project progress to stakeholders to keep IT projects on time and on budget. COMP 1288 is an elective in the Applied Computer Information Systems, ACIS and Agile Development Associate Certificates, it is required for the CST/PTS Diploma. Upon successful completion students will have an introduction to project management concepts and be able to conduct a post project evaluation. Prerequisite(s): COMP 1002 course outline	1.5
	COMP 2010	MS Office Applications This hands-on course follows on from COMP 1002 -Applied Computer Concepts and is aimed at students who are already able to use a Windows PC and able to manage files on a network, in the cloud. Topics include essential skills for proficiency in MS Word, MS Excel and MS PowerPoint using a student version of MS Office 365, hosted by BCIT. COMP 2010 includes lectures, lab exercises and assignments outside of class in MS Word, MS Excel, and MS PowerPoint. Students will also receive an introduction to simple databases with MS Access and be prepared to move on to the follow-on 6-week courses offered once per year: COMP 2361 MS Word Advanced in October, and COMP 2362 MS Excel Advanced in June. COMP 2010 is required in the Applied Computer Information Systems (ACIS) Associate Certificate. It is an elective in the Technical Writing Associate Certificate and the Computer Systems PTS Diploma from BCIT Computing. Upon successful completion, students will be able to create, edit and manage documents, spreadsheets, and presentations in the cloud. Prerequisite(s): COMP 1002 course outline	3.0
	COMP 2156	Introduction to Microsoft Power BI Power BI is a Microsoft collection of tools and an analytics service for data visualization and business intelligence reporting. BCIT Computing offers a series of MS Power Bi courses. COMP 2156 is a hands-on intro course designed for database professionals, data analysts, business analysts and managers. It follows on from COMP 2362 or COMP 2364, it assumes that students have an understanding of statistics for data analysis and advanced functions of MS Excel. Students begin with a brief introduction to the building blocks of Microsoft Power BI and its related services. They are shown how to get a variety of data into the Power BI Desktop from multiple sources. In class labs and exercises focus on how to model, explore, clean and transform simple data for business reports. Topics include: Data Analysis Expressions, DAX, relationships and Data Visualization. Labs and assignments are designed to provide best practices that can be transferred to the workplace. Participants must provide their own current model PC capable of running Windows 10 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 2156 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and a required course in the Applied Data Analytics Certificate (ADAC). By the end of this course successful students will be able use the Power BI unified analytics platform to build and publish high quality dashboards to the web. They will be prepared to move on to the next level COMP 3156 –MS Power BI Optimization and COMP 3157–MS Power BI Advanced Data Visualization. Prerequisite(s): 60% in COMP 2362 or 60% in COMP 2364 course outline	1.5
	COMP 2252	SAP Crystal Reports Crystal Reports by SAP is a low-code well established reporting solution used to create reports and dashboards from a wide variety of data sources, with minimal coding for Business Intelligence (BI). Students who know how to use a Windows PC and MS Office are introduced to planning and developing business intelligence reports. COMP 2252 participants will create dynamic reports and dashboards. Labs and exercises apply best practices in: report design, how to extract and manipulate data, and display information in custom formats from many sources. COMP 2252 is an elective in Applied Computer Applications (ACA); Applied Computer Information Systems (ACIS); Applied Database Administration and Design (ADAD) Associate Certificates, as well as the Applied Data Analytics Certificate (ADAC) and the Computer Systems Technology (CST FLEX) Diploma. Please note: This course will be offered in the January (Winter) or September (Fall) terms. By the end of this course, successful students will be able to use Crystal Reports to display and analyze data visually for BI and to make actionable decisions. Prerequisite(s): 60% in COMP 2010 or 60% in COMP 2364 course outline	3.0
	COMP 2256	Introduction to Visual Analytics with Tableau This hands-on course is designed for database professionals, data analysts, business analysts and managers, who want to analyze and visualize data from a variety of sources. Students begin with a foundation in data visualization techniques and principles. Effective data analysis techniques, and industry standard best practices are discussed. Through hands-on labs, assignments, projects and group work, participants learn how to build insightful and interactive dashboards. Participants learn to present compelling visuals via lab exercises and assignments. Tableau dashboard performance considerations are discussed. Students registered in COMP 2256 will receive a student license for Tableau software for their home machines for the duration of the course and have access to a Tableau subject matter expert with industry experience. This course is an elective in five School of Computing and Academic Studies credential programs; Computer Systems Technology Diploma (CST/PTS), Applied Computer Information Systems (ACIS), Applied Computer Applications (ACA), Applied Database Administration and Design (ADAD) and Technical Writing. COMP 2256 is a requirement for the Applied Data Analytics Certificate (ADAC). A project presentation is required and designed to help the students become better communicators. By the end of this course successful participants will be able to produce highly interactive graphs, reports and dashboards that access and visualize data from a multiple sources. We recommend that students working toward a Computing credential complete COMP 1630 first. Prerequisite(s): COMP 1002 course outline	3.0
	COMP 2361	Microsoft Word Advanced This instructor lead, hands-on course continues on from COMP 2010. Students must have prior knowledge and skills at using the basic and intermediate features of MS Word before starting this Advanced MS Word course. Participants start at an intermediate level and progress to expert in just 6 lessons while practicing how to manage a variety of documents. COMP 2361 focuses on the best practices, time saving techniques and how to use MS Word to create professional documents. Lectures, lab exercises in class and assignments outside of class are used for an applied learning experience. Advanced topics include: automating a table of contents; building an index; tracking changes; mail merging; developing templates and forms; automating tasks with building blocks and macros. COMP 2361 is an elective in Applied Computer Information Systems (ACIS) Associate Certificate. By the end of this course, successful students will be expert end users of MS Word. COMP 2361 will only be offered in the September (fall) term. Prerequisite(s): 60% in COMP 2010 course outline	1.5
	COMP 2362	Microsoft Excel Advanced This instructor lead, hands-on course continues on from COMP 2010. Students must have prior knowledge and skills at using the basic and intermediate features of MS Excel before starting this Advanced MS Excel course. Participants start at an intermediate level and progress to expert in just 6 lessons while practicing how to create and manage a variety of meaningful spreadsheets. COMP 2362 focuses on the best practices, time saving techniques and how to use MS Excel to create to analyze, communicate and manage information. Lectures, lab exercises in class and assignments outside of class are used for an applied learning experience. Advanced topics include: consolidating data in multiple worksheets templates, dealing with error messages, solver and basic macros. Students who have not completed COMP 2010 should know subtotalling, pivot tables and pivot charts. Participants progress from intermediate to expert in just 6 weeks. This course is an elective in the Applied Computer Information Systems (ACIS) Associate Certificate from BCIT Computing. By the end of this course, successful participants will be expert end users of MS Excel. This course is offered once a year in the Spring (April) term. Prerequisite(s): 60% in COMP 2010 course outline	1.5
	COMP 3156	MS Power BI Optimization Following on from COMP 2156 , and parallel to COMP 3157, this hands-on advanced course was designed for Business Intelligence and Data Analysts. Students who already know how to use Power BI to build and publish reports begin with an in-depth introduction to Star Schema and its relevance to optimal Power BI data modeling. COMP 3156 in-class labs and exercises focus on specific strategies to optimize large complex Power BI data models and how to leverage Power BI Service in the cloud for fast performing reports. Topics include relational data modeling in Power BI, Designing Import, DirectQuery, and Composite Data Models. There is also an in-depth explanation of Power BI Service Performance Monitoring. Tabular Editor and DAX Studio are also discussed. Labs and assignments include managing security permissions, data visibility based on role as and leveraging specialized third-party tools. Tabular Editor and DAX Studio are used to monitor and evaluate data model performance. Participants must provide their own current model PC capable of running Windows 10 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 3156 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and the Applied Data Analytics Certificate (ADAC). By the end of this course, successful students will be able to build advanced, optimized data models and use the Power BI Service cloud environment. Prerequisite(s): 60% in COMP 2156 course outline	1.5
	COMP 4678	Microsoft SQL Server 2016 Development Following on from COMP 1630, students who already understand data modeling, relational database design and SQL are provided with an in-depth understanding of designing and implementing MS SQL 2016 Server databases advanced T-SQL and scripting methods. There is an overview of BI tools (MS SQL Server Reporting Services, MS SQL Server Integration Services) and comparisons between different editions of MS SQL Server. Topics include: architecture, new SQL 2016 components, T-SQL review, new T-SQL constructs for SQL Server 2016, programmable objects, security for the database developer and performance tuning procedures. Exercises and labs help students obtain a thorough understanding of Microsoft SQL Server 2016 from a database developer perspective, with a focus on how to create views, stored procedures and triggers. Successful participants will be able use procedural code in TSQL and .NET to develop and manage the data layer for software applications. Please note: COMP 4678 will be offered for the last time in the spring (April) 2023 term. Prerequisite(s): 60% in COMP 1630 course outline	4.0
	COMP 4679	SQL Server Reporting Services, SSRS for Business Intelligence This hands-on course follows on from COMP 1630. Students who already understand relational database design, SQL programming are introduced to SQL Server Reporting Services SSRS. Students must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Please note: BCIT does not provide technical support for student's hardware or operating systems. COMP 4679 topics include how to install, configure and manage SSRS; author reports using SQL Server Data Tools (SSDT), and apply multiple levels of report security. Students receive a brief overview of Microsoft SQL Server Analysis Services which provides additional BI concepts. Labs and exercises show how to use SSRS to extract the data from its multiple collections of applications and data sources, how to deliver and manage reports, to integrate SSRS reports. Participants explore business intelligence platforms and apply best practices to author, deploy and manage reports with SSRS. COMP 4679 is an elective in the Applied Database Administration and Design, ADAD Associate Certificate; the Applied Data Analytics Certificate, ADAC and the Computer Systems Technology, CST/PTS Diploma. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Students should also plan for 9+ hours reading and homework each week. Upon successful completion of COMP 4679 students will be able to use SSRS to deploy a Reporting Services database, they will be able to extract data from multiple data sources and integrate traditional and interactive SSRS reports. Please note: COMP 4679 will be offered in the Spring (April) and Fall (September) terms. Prerequisite(s): 60% in COMP 1630 course outline	4.0
	COMP 4681	SQL Server Analysis Services, SSAS This hands-on course follows on from COMP 1630. Students who already understand relational database design, SQL programming and data warehouse foundations are introduced to SSIS. COMP 4681 is a blended BYOD course, participants must provide their own Windows 10 dual core laptop with a minimum of 8GB RAM to participate in this course. Please note: BCIT does not provide technical support for student's hardware or operating systems. Topics include: how to install, configure and manage SSAS; designing multidimensional Business Intelligence Semantic Model (BISM), accessing different data sources, creating multidimensional databases, data mining, interacting with cube data using Multidimensional Expressions (MDX) queries from MS Excel. Labs and exercises show how to use SSAS to design, create and manage multidimensional structures containing data from other sources. Participants are shown how to create and maintain an Analysis Services database. MS Excel and MS SQL Reporting Services are used to present data from SSAS. COMP 4681 is an elective in the Applied Database Administration and Design, ADAD Associate Certificate; the Applied Data Analytics Certificate, ADAC and the Computer Systems Technology, CST/PTS Diploma. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Students should also plan for 9+ hours reading and homework each week. Please note: COMP 4681 will be offered in the winter (January) and fall (September) terms. Upon successful completion of COMP 4681 students will be able to use SSAS to deploy an Analysis Services database with multiple levels of security for data mining, they will be able to extract data from collections of multiple data sources and applications. Prerequisite(s): 60% in COMP 1630 course outline	4.0
Note: If you previously completed COMP 3838, it may be used as an elective.

Total Credits:			22.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

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: cstflex@bcit.ca if you have any questions.

ADAD may be completed with as few as 7 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: Flexible Learning via 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, Data Quality Improvement, MS PowerShell and MS SQL Server Admin. Students have a variety of elective choices in relational databases and reporting technologies. These include: Project Management, SAP Crystal Reports, Power BI, Visual Analytics with Tableau, PowerShell Scripting, plus Microsoft SQL Server related 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.

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 delivery

Blended: This program is delivered partly on campus and partly online.

Please check the individual course schedule pages. Some COMP courses are delivered entirely online and others are entirely on campus. Several course sections in ADAD have a blended delivery with synchronous on campus classes, and others have synchronous online classes, while both options may include required asynchronous online components.

Program location

Courses may be offered at the following locations:

Burnaby Campus
3700 Willingdon Avenue
Burnaby, BC

Downtown Campus
555 Seymour Street
Vancouver, BC

Online Learning

Program abandonment

Students approved for a flexible learning (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 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]

Graduate employment outcomes

The BCIT student outcomes report presents 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 2020-2022 BCIT Outcomes Surveys of 2019-2021 graduates and for Degree 2017-2019 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.

Applied Database Administration and Design

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

Advisory committee

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.

Contact Us

Please email BCIT Computing Flexible Learning:

Email: cstflex@bcit.ca

General Inquiries: 604-432-8465

Questions or comments?

Programs and courses are subject to change without notice.