Applied Database Administration and Design

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.