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