inline-defaultCreated with Sketch.
inline-defaultCreated with Sketch.
For StudentsUniversitiesProgramsAmbassadors
Our Story
Educatly AI
Efficient Chatbot for Seamless Study Abroad Support
Try Now
inline-defaultCreated with Sketch.

This website uses cookies to ensure you get the best experience on our website.

Cookie Policy
Students
Courses

Applied Database Administration and Design, Associate Certificate, Part-time

BCIT - British Columbia Institute of Technology
Burnaby , Canada
Easy Apply
Students
Tuition Fee
Start Date
Not Available
Medium of studying
Not Available
Duration
Not Available
Program Facts
About Program
About University
Admission Requirements
Gallery
Easy Apply
Program Facts
Program Details
Degree
Courses
Major
Architectural Technology | Computer Science
Discipline
Architecture | Computer Science & IT
Minor
Data Modeling/Warehousing and Database Administration | CAD/CADD Drafting and/or Design Technology
Course Language
English
About Program

Program Overview

The Applied Database Administration and Design (ADAD) Associate Certificate program equips students with the skills to design, administer, and secure databases. Through a combination of required courses and electives, students learn data modeling, SQL programming, data quality improvement, and scripting for automation. The program is delivered in a blended format, with both on-campus and online components, and prepares graduates for careers as database administrators.

Program Outline

Degree Overview:

The Applied Database Administration and Design (ADAD) Associate Certificate program starts with data modelling, SQL programming, business analysis, data quality, and scripting for automation. Learn best practices for administrative policies, access control, and data governance, security, and recovery. Electives include data visualization tools.

Outline:

Required Courses (16.5 credits):

  • Relational Database Design and SQL
  • Business Analysis and Systems Design
  • Introduction to MS Server Administration Part 1
  • Microsoft SQL Server Administration Part 2
  • Data Quality Improvement
  • MS PowerShell Scripting

Complete any 7.5 credits from the following list of electives:

  • IT Project Management Fundamentals
  • Introduction to Microsoft Power BI
  • SAP Crystal Reports
  • Introduction to Visual Analytics with Tableau
  • Microsoft Excel
  • MS Power BI Optimization
  • SQL Server Development
  • MS Azure and SQL Analytics Tools

Assessment:

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.

Teaching:

This program is delivered partly on campus and partly online. 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.

Careers:

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.

SHOW MORE