Applied Database Administration and Design, Associate Certificate, Part-time
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.
BCIT - British Columbia Institute of Technology
Overview:
BCIT is a public post-secondary institution in British Columbia, Canada, offering practical, flexible, and applied education. It distinguishes itself from traditional colleges and universities by focusing on hands-on learning with instructors who have direct experience in their fields.
Services Offered:
BCIT provides a wide range of services to its students, including:
Academic & Learning Services:
Academic advising, tutoring, writing support, and library resources.Campus Amenities:
Cafeterias, fitness facilities, student lounges, and other amenities.Financial Aid & Awards:
Scholarships, bursaries, and other financial assistance programs.Health & Wellness:
Counseling, health services, and wellness programs.Safety & Security:
Campus security services and safety protocols.Student Life & Housing:
Student clubs, events, and housing options.Technology:
Access to computer labs, software, and online learning platforms.Workplace & Career Opportunities:
Career counseling, job placement services, and internship opportunities.Indigenous Initiatives:
Support services and programs for Indigenous students.International Students:
Support services and programs for international students.Student Association:
Student-run organization representing student interests.Student Life and Campus Experience:
BCIT offers a vibrant campus life with opportunities for students to engage in various activities, including:
Clubs and Organizations:
Joining clubs and organizations related to their interests.Events:
Attending campus events, workshops, and social gatherings.Volunteering:
Contributing to the community through volunteer opportunities.Mentorship:
Connecting with mentors and peers for guidance and support.Key Reasons to Study There:
Practical, Hands-on Learning:
Focus on applied learning with industry-relevant skills.Experienced Instructors:
Instructors with direct experience in their fields.Flexible Learning Options:
Full-time, part-time, and online programs.Strong Industry Connections:
Close ties with industry partners for internships and job opportunities.Career-Focused Programs:
Programs designed to prepare students for specific careers.Vibrant Campus Community:
Opportunities for student engagement and social interaction.Academic Programs:
BCIT offers a wide range of academic programs across various disciplines, including:
Applied & Natural Sciences:
Business, media, computing, and IT.Engineering:
Various engineering disciplines.Health Sciences:
Healthcare and medical programs.Trades & Apprenticeships:
Skilled trades and apprenticeship programs.Flexible Learning:
Online and part-time programs.Microcredentials:
Short-term, specialized programs for skill development.Other:
BCIT is committed to sustainability and social responsibility, with initiatives focused on environmental protection and community engagement. The institution also acknowledges the unceded traditional territories of the Coast Salish Nations.
Entry 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.
