Computer Systems

This practical course is for BCIT Computing and Business students who want to learn about laws and policies applicable to the Internet and information technology, as well as intellectual property rights. Topics covered in this course include the following: copyright, patents, trade secret, trademarks, domain names, cybercrime, privacy, e-commerce and online contracts, and online advertising.

​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

​C++ is one of the most popular programming languages used in industry today to create professional application software and video games. C++ continually evolves and is designed to work along side other programming languages. This hands-on intermediate level course assumes a prior knowledge of object-oriented programming and follows on from COMP 1451. Students must already understand object-oriented programming (OOP) before starting this course. Participants start their examination of C++ by comparing previously learned OOP characteristics and mapping these to C++. This course will cover C++11 features as they apply to the learning outcomes. Topics include: Classes, Control Statements, Arrays, Pointers, Stream I/O and the C++ string class. Since the C language is a subset of C++, students will be also earning some first level C programming which is continued in COMP 2717. Delivery is face-to face for 3 hours each week plus an online and homework component. Typical students will require about 10 hours per week to study the material and work on assignments outside of class. Upon successful completion, participants will be able to continue to learn C++ programming with the second half of this material in COMP 2618. PLEASE NOTE: COMP 2617 is being offered for the last time in April 2021, it will be replaced in September 2021.
Prerequisite(s): COMP 1451 with 60% or better, or equivalent understanding of object-oriented programming.

This hands-on intermediate level course assumes students have completed COMP 2617 C++ Application Development Part 1 with a minimum of 60%. Students immediately move into more advanced C++11 features. Topics include: operator overloading; template classes; exception handling; the string class and stream processing; the Standard Template Library; file processing; and namespaces. Additional miscellaneous advanced C++ topics will also be covered. Delivery is face-to face for 3 hours each week plus an online and homework component. Typical students will require about 10 hours per week to study the material and work on assignments outside of class. Upon successful completion, participants will be able to write, test and debug C++ programs to industry standards and be able to develop significant software applications.
Prerequisite(s): COMP 2617 completion with 60% or better.

This hands-on course follows on from COMP 1850 and (COMP 2015 or COMP 2132) and is aimed at students who already possess a working understanding of web scripting with HTML5, CSS3, and JavaScript. Beginning with basic client/server concepts, students are introduced to server-side scripting, PHP theory, basic syntax and the difference between synchronous/asynchronous calls for responding to AJAX requests. There is a review of basic front end development concepts and JavaScript. Students who want to learn more about advanced JavaScript are also encouraged to complete: COMP 2909 -Angular and Vue.js Fundamentals, COMP 2912- Node.js Fundamentals and COMP 2913 -React and Modern JavaScript. COMP 3015 participants are provided with a front-end web application to connect to the back-end to serve the front end applications. Topics include: caching, Content Delivery Network (CDN), and external libraries to understand how to deal with these topics in the back end. Additional topics include: MySQL, password hashing and SSL/TLS. HTTP vs HTTPS, HTTP status codes, verbs, headers, cookies, and sessions as also discussed. Labs and exercises include different encoding types for transport between browser and server application, basic web application security and the dangers of cross site scripting, session hijacking. Participants gain experience with the major functions of server-side scripting, client/server architecture and a variety of open-source software tools. This course is required in several programs including Applied Web Development (AWD) plus the CST/PTS Diploma. It is also the prerequisite for COMP 4669 Advanced Web Applications. Upon successful completion of COMP 3015 students will able to write browser independent server-side scripts and develop a web application.
Prerequisite(s): COMP 1850 and (COMP 2015 or COMP 2132)

IT security is growing area with several domains including both information security and network security. This course replaces COMP 3705 which covered both information security and network security. COMP 3704 will provide a more in depth overview of key topics in information security only and is one of the prerequisites for COMP 4704 Applied Network Security. IT professionals across multiple sectors from software development, database, web, mobile and networks will benefit from the material covered.  This hands-on course is led by local industry experts who will share their knowledge and best practices for securing computer systems. Students will complete labs and exercises to experience applied IT security and gain a practical knowledge. Topics will include: security awareness, risk mitigation and control administration, data and application security, cryptography, attack techniques, penetration testing, vulnerability assessment, incident response, disaster recovery, and forensic analysis. In addition, information handling best practices, privacy and regulatory issues are discussed. Upon completion of this course, successful participants will be aware of best practices in IT security and how to implement secure information systems. Network related aspects of IT security are covered in the follow-on course, COMP 4704 “Applied Network Security".
Prerequisite(s): COMP 1002 or equivalent knowledge.

Following on from COMP 2825 Computer Architecture, students are introduced to the basic concepts and terminology related to data communications, networking and network topologies. COMP 3725 replaces COMP 3721 in the CST/PTS Diploma and is equivalent to the full-time CST Diploma course. Students will learn about the TCP/IP protocol suite and the principles of protocols at the physical, data link, network and transport layers, the characteristics of transmission media, analog/digital transmission, multiplexing/switching techniques, basic error detection and correction, elementary data link protocols, flow control and an introduction to routing and congestion control issues. Multiple access protocols, the UDP and TCP protocols, networking and internetworking devices, LANs and WANs will also be discussed. The course has a strong emphasis on data communications at the physical layer and the assignments will reinforce the fundamental concepts and analysis techniques. Upon successful completion, students will be familiar with network protocol implementation using a layered approach and apply basic data communication theory to the design and analysis of networks.
Prerequisite(s): COMP 2825 or COMP 2721

In this hands-on course, Java programming students who have also taken Discrete Math will develop their ability to analyze and design computer algorithms. In particular, learners will analyze the time and space complexity of programs, solve nontrivial programming problems using algorithmic techniques, and prove that their solution is correct. The emphasis will be on developing the practical skills of analysis and design. Topics include: evaluating time and space complexity and designing solutions by using appropriate data structures or applying techniques such as recursion, parsing and graph algorithms.
Prerequisite(s): COMP 2121 and (COMP 2522 or COMP 2526 or COMP 2613)

This hands-on course follows on from COMP 2831 Business Analysis and Systems Design it replaces COMP 3831. Object-oriented software design includes Object-Oriented Analysis and Design (OOAD). COMP 3832 is aimed at systems analysts, designers and developers who already know how to write code and understand the Software development Life Cycle (SDLC). Exercises and lab work allow students to perform an Object-Oriented Analysis (OOA) based on given requirements. After first identifying business classes students then produce a business model which will be transformed into a design model through Object-Oriented Design (OOD). Topics include: design patterns, anti-patterns, refactoring and General Responsibility Assignment Software Patterns (GRASP). An Agile iterative approach will be followed throughout the OOAD process. Labs include the use of a CASE tool to draw the Unified Modeling Language (UML) diagrams necessary to support the OOAD activities. Upon completion successful students will be able to demonstrate the ability to analyze, design and construct software applications to industry standards.
Prerequisite(s): COMP 2831 and the ability to write executable code in a programming language.

​This course introduces the theory and concepts of operating systems to CST Diploma students who already understand both C Programming and Computer Architecture. COMP 4731 begins with an examination of operating systems structure and services. Lectures, exercises and homework focus on how these services are used and implemented for processor management. Topics include: processes and threads, kernel architecture, inter-process communication, synchronization and mutual exclusion, deadlock and starvation, memory organization and management, virtual memory, processor scheduling, input/output management, disk scheduling, and file management. Labs and assignments use examples to illustrate operating systems concepts used in UNIX,/Linux and Windows. COMP 4731 is required for CST/PTS Diploma completion and is equivalent to COMP 4735 in the full-time CST Diploma. Upon successful completion students will have an understanding of how operating systems work and how to write concurrent code for software applications.
Prerequisite(s): (COMP 2510 or COMP 2511) and (COMP 2721 or COMP 2825)

This hands-on course introduces descriptive statistics, basic inferential statistics, linear regression, and probability concepts and calculations. Emphasis throughout the course will be placed on using statistical methods for the exploration and analysis of data sets. This introduction will enable students to use statistics for data analysis, will prepare them for “Data Analytics/Mining,” and covers topics appropriate for anyone seeking a first statistics course. Labs and exercises employ standard graphical methods to represent statistical data. Hypothesis tests, including ANOVA, are used to test for significant differences between multiple groups. Students will be introduced to the open source R Programming language, a statistical analysis tool used to extract meaningful information from a variety of scientific, industrial and commercial data sets. Upon successful completion, students will be able to carry out calculations, perform statistical decision making and solve problems with involving collected data. This course prepares the student to move on to MATH 3060 and is a required course for the Applied Data Analytics Certificate offered by BCIT Computing.
Prerequisite(s): Math 12 Pre-Calculus or equivalent

​This course allows students to learn, practice and demonstrate competency in knowledge of computer statistical simulation methods that are not covered in Math 1060. This course is taken after successfully completing Math 1060.
Prerequisite(s): MATH 1060

User Experience (UX) encompasses a wide range of activities including User Interface (UI) design, Information Architecture (IA) and field research. Usability design and testing, tight integration and collaboration with software development processes are included in UX. This hands-on course is an introduction to UX/UI for those who are creating user interfaces for web sites, mobile applications, and information systems, as well as those who want a better understanding of the role of UX/UI. Students will follow an iterative and agile approach focusing on User-Centered Design (UCD) as the motivator for product direction. Skills learned in this course will apply to web and mobile applications as well as IT systems interface development. Participants will be expected to work within interdisciplinary teams, with emphasis on collaboration, brainstorming, and continued evolution of an interface concept based on UCD. Upon completion, successful students will be able to incorporate user-centered iterative design principles and processes into a wide variety of IT projects. Some students may want to complete COMP 1910 – Introduction to 3D Simulations and VR/AR concurrently with COMP 1011.
Prerequisite(s): COMP 1002 or equivalent knowledge of using a Windows PC and file management.

​This hands-on course follows on from COMP 2831 and begins with an in-depth overview of the goals of Agile, followed by hands-on Scrum implementations. Students learn to implement primary agile methods and the scrum framework. Topics include: Scrum, Extreme Programming, Lean/Kanban, Dynamic Systems Development Method, and Feature-Driven Development. COMP 2833 assumes that all participants have very strong English communication skills. In class exercises cover agile practices including self-directed teams, writing of user stories, agile estimating with relative sizing, co-location, metric reporting and test driven development. Participants discover how to implement Scrum and how to scale large multiple team projects, measuring progress at both a micro and macro level to go through release planning. Working in groups all students are required to participate in an actual project consisting of building a real product from initiation to a team implementation. Students will practice Scrum Planning Sessions, Sprint Planning Meetings, daily Scrum Meetings, Sprint Reviews, Backlog Grooming Sessions, and Sprint Retrospectives. Each student will experience the roles of Scrum Master, Scrum Product Owner, and "The Scrum Team" both in class face to face and online with a dispersed agile team. COMP 2833 students will be prepared to move on to the follow on COMP 2836 Agile Business Analysis and Project Leadership in the Agile Development Associate Certificate and the CST/PTS Diploma. Upon successful completion participants will be able to form agile teams that complete projects in less time and under budget compared to traditional methods.
Prerequisite(s): ​COMP 2831; Note: Computer Systems Certificate, CSC students must also complete COMM 2216 or (COMM 2002/2003) prior to COMP 2833.

Acquiring effective communication and presentation skills will help advance your career and bring positive attention to your projects and ideas. In this course, you will review sample speeches, perform audience and purpose analysis for your own project, rehearse effective public speaking techniques, and deliver your final presentation to a wider audience. Students can present on a school project from one of their technical courses, an entrepreneurial idea, or a current work project.
Prerequisite(s): A post-secondary Communication or English course or equivalent.

​This hands-on course is aimed at software developers with no graphics or 3D modelling experience. Students who already know how to create software applications will learn how to create 3D models, then add texture maps and make them interactive online. At the end of this course there is an brief introduction to creating virtual reality simulations. Two open source tools are used; Blender 3D, and Gimp, plus the industry standard Unity Game Engine. Blender is used to create, manipulate and modify 3D models;Gimp is used create seamless texture maps; and the Unity Engine is used to set up an interactive scene. Each student must provide their own 16 GB USB memory stick to save their work. Labs and exercises focus on how to create a 3D model in Blender, and then how to use scripts in Unity to interact with these models in a browser. The main focus of this course is to create a 3D simulation to later be used in a brief introduction to Virtual Reality (VR). Students create an account to download the Vuforia extension for Unity in order to develop a simple mixed reality demo. By the end of this course participants will use a Microsoft HoloLens and other VR tools to experiment with creating a simple VR demo. COMP 1910 is an elective in the CST/PTS Diploma and aimed at software developers. Upon successful completion, students will be able to create a basic 3D simulation to use in a brief introduction to Virtual Reality. Students in the VR/AR Statement of Completion may want to complete COMP 1011 UX/UI Fundamentals concurrently.
Prerequisite(s): COMP 2613 or COMP 2614 or equivalent experience developing software applications.

This hands-on course follows on from COMP 1850 Applied Web Development Level 1. Students who already understand HTML and CSS will explore web development in more depth with new topics and techniques. Participants will gain a deeper understanding of the latest technologies including HTML5 and CSS3 for developing web sites and applications. There is a focus on responsive design and mobile presentation through the use of Media Queries. Adding behavior to web sites using JavaScript frameworks such as jQuery is introduced. Labs and exercises focus on industry standard web development methodology. Students gain experience creating templates for content management systems and presentation. Additional topics will include: leveraging Server Side Includes (SSI) for re-usable code, source control for managing your code, and web-based fonts for professional typography. COMP 1950 is a required course for the BCIT Computing Advanced Web Technologies associate certificates in Applied Web Development, AWD and Web and Mobile Application Development, WMA, as well as an elective in the CST Diploma. By the end of this course successful students will be able to build dynamic and semantically marked-up content providing Search Engine Optimized (SEO) pages.​ PLEASE NOTE: COMP 1950 was replaced with COMP 2132 as of September 2020.​
Prerequisite(s): COMP 1850 or equivalent HTML5 and CSS3 knowledge.

​This instructor lead, hands-on applied course follows on from COMP 1002. Students are expected to be able to use a Windows 10 PC and manage files on a network. COMP 2010 includes lectures, lab exercises and significant assignments outside of class that are designed to impart proficiency in MS Word, MS Excel, MS PowerPoint, and MS Access. Topics include essential skills, from the fundamentals through to intermediate levels of Word and Excel in the latest version of Microsoft Office. COMP 2010 is required in the Applied Computer Information Systems (ACIS) Associate Certificate and is an elective in the Computer Systems PTS Diploma from BCIT Computing. Participants will be prepared to move on to COMP 2361 MS Word Advanced and COMP 2362 MS Excel Advanced. Upon successful completion, students will be able to create, edit and manage documents, spreadsheets, presentations, and simple databases.
Prerequisite(s): COMP 1002

​COMP 2052 provides an introduction to mobile application development using tools and scripting languages rather than object-oriented programing languages. This hands-on course follows on from COMP 1850 and (COMP 2015 or COMP 2132) and assumes students already understand how to develop and deploy web sites with HMTL5, CSS3 and JavaScript. Participants do not need to be object-oriented programmers however they should have significant experience using mobile apps. Students will design and develop web-based, native and hybrid mobile applications using jQuery Mobile, Android Studio, Apache Cordova, and other tools. Labs and exercises focus on how to implement entry level, mobile applications for Android and other mobile web platforms. Topics include a comparison of native, hybrid and web based mobile technologies. Starting with the fundamentals of web-based mobile applications, Android Studio and Apache Cordova are used to implement web-based, native, and cross-platform mobile solutions. COMP 2052 is an elective in the CST/PTS Diploma, the Web and Mobile Development (AMD) and Applied Web Development (AWD) associate certificates from BCIT Computing. Upon successful completion, students will be able to choose from a variety of tool sets for platform independent mobile and web application development. This course will only be offered once per year in the April term.
Prerequisite(s): COMP 1850 and (COMP 2015 or COMP 2132), or equivalent knowledge of HTML5, CSS3, JavaScript and jQuery.

Crystal Reports is a cost effective business intelligence application provided by SAP for small businesses. It has a very large install base and it is used to design and generate reports from a wide variety of data sources. Students are first introduced how to plan Crystal Reports designs and then how to develop basic business intelligence reports. After the mid-term they learn to apply best practices for enhanced report design. Participants learn how extract and manipulate data, saving time to develop automated and custom reports. By the end of this course, successful participants will know how to use Crystal Reports to produce a variety of different charts and multiple ways to depict data. COMP 2252 is an elective in the Applied Computer Applications (ACA), and the Applied Database Administration and Design (ADAD) Associate Certificates, as well as the Applied Data Analytics Certificate (ADAC) and the CST/PTS Diploma. Please note: COMP 2252 will only be offered in the January and September terms.
Prerequisite(s): COMP 1002 and COMP 2010; or equivalent understanding of MS Windows and Office.

Power BI is a Microsoft collection of tools and an analytics service for data visualization and business intelligence reporting. This hands-on course was designed for database professionals, data analysts, business analysts and managers. It follows on from COMP 2362, it assumes that students have an understanding of statistics for data analysis and advance 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. COMP 2156 is an elective in several BCIT Computing credentials including 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.
Prerequisite(s): COMP 2362 Microsoft Excel Advanced or equivalent knowledge.

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.
Prerequisite(s): COMP 1002 or equivalent knowledge, plus a working knowledge of MS Excel. We recommend that students working toward a Computing credential complete COMP 1630 first.

​​This hands-on intermediate level Java course assumes significant prior knowledge of object oriented programming as taught in COMP 1451 and COMP 2526. Students who have a solid introduction to programming will learn Java application development with the Java Standard Edition SDK using the Java framework core APIs and the Eclipse IDE. Topics include: packages, inner classes, file i/o, an overview of database connectivity, an introduction to concurrency, user interfaces, model-view-controller and other design patterns, and networks. Lectures and code examples are reinforced with hands-on labs, assignments, and mandatory online work outside of class using the BCIT Learning Hub. COMP 2613 is an elective in the Applied Software Development, ASD Associate Certificate and the Computer Systems Technology, CST/PTS Diploma. Successful participants will be able to use the Java standard coding style and naming conventions to build and deploy commercial quality Java applications. By the end of this course students are prepared to move on to COMP 3656 Advanced Java Application Development. PLEASE NOTE: COMP 2613 is being offered for the last time in April 2021, it will be replaced in September 2021.
Prerequisite(s): COMP 1451 or COMP 2526

​This hands-on course builds upon COMP 1451 or equivalent knowledge of object oriented programming. Students who already understand OOP learn to build graphical user interfaces (GUIs) and design Windows application software. The focus of this course is an introduction to C# programming with Microsoft Visual Studio and the .NET Framework 4.7 for Windows application development. Labs and assignments are designed to reinforce Microsoft industry standards and best practices. Topics include: Windows Forms and controls, event-driven programming and effective application debugging. Students will be prepared to move on to more advanced C# in COMP 3618 Advanced .NET Application Development and COMP 3973 Web Application in ASP.NET MVC Core. Upon successful completion, participants will be able to use C# to create executable Console and Windows Form applications with the latest .NET technologies. PLEASE NOTE: COMP 2614 is being offered for the last time in April 2021, it will be replaced in September 2021.
Prerequisite(s): COMP 1451 or equivalent knowledge of Object Oriented Programming.

Following on from COMP 1002 students are introduced to the fundamental concepts and terminology related to data communications and enterprise networks. COMP 2629 is required for Applied Network Administration and Design, ANAD and is also an elective in the CST/PTS Diploma for those who want COMP 4704 Applied Network Security. Students are introduced to the basic (design, implementation and management) concepts and terminology related to data communications and networking. The OSI model as well as the TCP/IP protocol suite at the physical, data link, network and transport layers are used throughout the course to demonstrate concepts and implementation. Topics include: network topology, protocols, transmission media, switching techniques, access control and addressing for wired and wireless networks. There is also an overview of network security and network management principles. Participants will investigate how requirements relate to network design and network administration. They will also study how computers exchange data over LANs and WANs. Labs and exercises will examine network protocol implementation as well as show how to troubleshoot and improve network design. Upon successful completion, students will be prepared to start COMP 3700 MS Windows Server Administration. They will have acquired a practical understanding of data communications, networking and design of enterprise networks.
Prerequisite(s): COMP 1002 or equivalent knowledge plus Grade 12 Math.

​This hands-on course follows on from COMP 1002 and assumes proficiency with a PC and file management. Students are introduced to command line Linux concepts using the GNU/Linux operating system on the Intel platform. Participants will install the Linux operating system, partition a disk, create and mount a file system, and configure the boot loader and services. COMP 2766 labs and exercises focus on how to navigate the file system, manipulate files and directories, and set permissions. Participants will manage processes, users, groups and passwords in a Linux environment and learn to edit text files using vi editor. They will also practice how to redirect input, output, manage error messages, plus use shell metacharacters. Topics include: login procedures, the Linux/Unix shell, the file system, and directory management, text editing and process control. Linux system security concepts are also discussed. COMP 2766 provides a working knowledge of how to install, set up and configure Linux. It is an elective in applied Network Administration and Design, ANAD Associate Certificate and the CST/PTS Diploma. Upon successful completion, students will have a basic foundation of the Linux environment and be prepared for the follow on COMP 2767 Linux Administration. Please note COMP 2766 is only offered in the winter (January) and fall (September) terms.
Prerequisite(s): COMP 1002

​This course follows from COMP 2766 and is designed for students who already have a solid foundation in command line Linux. Participants start by customizing and fine tuning an automated CentOS distribution based on Red Hat Enterprise Linux. Students then learn to perform more advanced Linux administrative tasks. Through hands-on exercises and labs, students will monitor the system, troubleshoot common problems, secure the system, and maintain the entire system. Topics include: Apache, OpenSSH, DHCP, FACLs, scripting, RPM/YUM, iptables, and basic troubleshooting for Linux Administrators. Students will configure a web server, schedule tasks, install and maintain software, and troubleshoot common problems encountered by Linux system administrators. Additional topics include how to configure and analyze logs, impose filesystem quotas, implement kernel level firewalling, and configure filesystem access control lists. This course is an elective in the Applied Network Administration and Design (ANAD) Associate Certificate and the CST/PTS Diploma. COMP 2766 and COMP 2767 together are equivalent to ACIT 2420 in the CIT Diploma. Upon completion of this course, successful participants will be aware of best practices in Linux Administration. Note: This course is offered in the April term.
Prerequisite(s): COMP 2766 - Introduction to Linux or equivalent knowledge of command line Linux.

This hands-on course replaces COMP 2834 and COMP 2835 and follows on from COMP 2833 – Agile Methods and the Scrum Framework in the Agile Associate Certificate. Starting with hands-on exercises and simulations, students learn to use integrated case studies for Agile Business Systems Analysis. The Scrum and Kanban frameworks in Agile are further examined and practiced. Participants then apply Agile Project Leadership styles through role-play in actual teams. The dynamics of a self-directed team from the forming and then to the continued coaching of that team are examined. Students will facilitate and prepare a Project Business Case and a Project Statement of Work (Project Charter) using an Agile Project “Liftoff” process. There is a focus on the process of decomposing User Story Epics into “slices” of functionality for each short development iteration. Developing user stories using the "just enough" approach is introduced. User Stories are mapped to an overall plan for the project using the "inspect and adapt" approach. Students practice delivering business value to clients with production ready concepts early and throughout the project. Continuous collaboration with the product owner and the self-directed Agile Project Leaders team is reinforced. Participants learn to embrace the continual flow of changing requirements as well as how to scale the agile techniques to apply Scrum to large-scale and geographically distributed projects. Upon successful completion of COMP 2836 students will be able to use Agile Analysis methods and Agile Project Leadership techniques to solve business problems and to work within the boundaries of traditional organizations.
Prerequisite(s): COMP 2833 Agile Methods and the Scrum Framework must be completed prior to starting COMP 2836.

This hands-on course follows on from COMP 1850 and (COMP 2015 or COMP 2132) and is aimed at students who already understand how to build web pages with HMTL, CSS, JavaScript and jQuery. Angular is a popular JavaScript-based, open-source front-end application framework designed to address the challenges of developing modularized single-page applications. Vue.js is a newer open-source framework based on JavaScript that was designed for building user interfaces. Vue.js functions like Angular to rapidly modularize application development. Participants first learn Angular development fundamentals and then practice building components, modules, and services for data-driven, client-side web applications. Exercises also include: routing, asynchronous JSON transfer, and validation. These features are then implemented using Vue.js. Automated testing and redux architecture are also introduced using Angular. As well, there is a brief introduction to using Angular with the Apache Cordova framework for platform independent mobile development for Android and iOS. Web students may also want to complete COMP 2912 Node.js Fundamentals and COMP 2913 React and Modern JavaScript. Upon successful completion students will have experience using these rich JavaScript frameworks to develop data-driven and interactive single-page web applications for all mainstream browsers. ​
Prerequisite(s): COMP 1850 and (COMP 2015 or COMP 2132) or equivalent knowledge of HTML5, CSS3, JavaScript and jQuery.

Node.js is a server-side JavaScript runtime enironment used to build network applications, and to create dynamtic web page content that generates data for interactive web pages. This hands-on course follows on from COMP 2015 or COMP 2132. It is designed for students who already understand how to build web pages with HMTL5, CSS3 and who also have significant JavaScript experience. Node.js uses an event driven, asynchronous I/O programing model to build web applications using JavaScript. Participants learn the Node.js programming model via labs and exercises. Topics include: Node's asynchronous programming model, Express web framework, accessing MongoDB, using Node Package Manager to install and manage node modules. Web developers should understand multiple advanced JavaSctipt tools including: COMP 2909 -Angular and Vue.js Fundamentals or COMP 2913 -React and Modern JavaScript. COMP 2912 is an elective in BCIT Computing's Applied Web Development (AWD) and the associate certificates; Web and Mobile, Advanced Java, and Advanced .NET Application Development, as well as the CST/PTS Diploma. Uopn on completion students will be able to use Node.js to build scalable, data intensive JavaScript web applications and be prepared to move on to COMP 3916 Docker for DevOps.
Prerequisite(s): COMP 1850 and (COMP 2015 or COMP 2132) or equivalent knowledge of HTML5, CSS3, JavaScript and jQuery

React is an open source JavaScript library for building user interfaces for web and mobile applications. This challenging, hands-on course follows on from COMP 1850 and (COMP 2015 or COMP 2132) and is aimed at students who already understand how to build web pages with HMTL5, CSS3 and who are proficient with JavaScript. The main goal of using React is to create fast, and modular applications. Students begin with an introduction to the basic concepts of React and how it works with the browser Document Object Model (DOM). Other topics include JavaScript ES6, JSX, and React Router. Instructor led labs and exercises focus on how to structure and develop single-page applications following current industry standards. Web students may also want to complete COMP 2909 Angular and Vue.js oir COMP 2912 Node.js Fundamentals. Upon completion successful participants will be able to build fast and feature-rich web applications using React and modern JavaScript.​
Prerequisite(s): COMP 1850 and (COMP 2015 or COMP 2132) or equivalent knowledge of HTML5, CSS3, JavaScript and jQuery. ​

​This hands-on course shows students how to build secure and reliable applications leveraging Amazon Web Services or the AWS Cloud. It is aimed at software developers and assumes that the participants are familiar with general networking concepts, application design, programming, multi-tier architectures and cloud computing concepts. Students begin with a self-study of AWS Certified Cloud Practitioner Essentials and how to utilize the AWS Cloud. They become familiar with standard industry solutions and designing new solutions using a wide variety of AWS services. COMP 3215 is a BYOD (bring your own device) course. Students must provide their own Windows 10, Mac or Linux dual core laptop with a minimum of 8GB RAM to participate in this course. Labs and assignments use a web browser to access course content. Some exercises require the installation and usage of command line tools. BCIT Computing is an AWS Academy partner; COMP 3215 is an elective in several BCIT Computing PTS programs including the: Advanced Java Development, Advanced .NET Development Associate Certificates and the CST/PTS Diploma. Upon course completion sucessful participants will be able to design scalable and secure distributed systems on AWS.
Prerequisite(s): ​COMP 2132, or COMP 2912, or COMP 2613, or COMP 2614; COMP 2831 is recommended but not required.

​This hands on follows on from COMP 2614 and replaces COMP 3608. It is aimed at .NET programmers who already understand how to write code and develop applications with C# in the .NET environment. Students gain practical skills using Microsoft Visual Studio to develop Extensible Application Markup Language (XAML) code. Labs and exercises focus on building Windows Presentation Foundation (WPF) and Universal Windows Platform (UWP) applications. .NET developers are introduced to the Model–View–Viewmodel (MVVM) software architectural pattern. Popular frameworks such as Prism and Caliburn Micro to build data-driven Line-of- Business applications with WPF/ UWP are also discussed. Lectures and assignments examine how to best utilize WPF /UWP for porting over existing Windows Forms to these newer frameworks. COMP 3609 is a required course for the Advanced .NET Development Associate Certificate and an elective in the CST/PTS Diploma and is complementary to COMP 3618 - Advanced .NET Application Development. Upon successful completion of this course, students will be able to design and develop modern apps with UWP and publish them to the Microsoft Store. This course will only be offered once per year in the September term.
Prerequisite(s): COMP 1850, COMP 2015 and COMP 2614 or equivalent knowledge.

​Continuing on from COMP 2613 this hands-on course is designed for those who already understand how to use Java to develop applications to industry standards. Students who are experienced Java programmers are introduced to the Kotlin programming language to develop, debug and deploy Android applications. This is a BYOD course not in a computer lab. Students must provide their own Windows, Mac or Linux laptop to participate in this course. See the current Android Studio hardware requirements. https://developer.android.com/studio/ Please note: BCIT does provide technical support for student's hardware or operating systems. Labs and assignments explore and use Android Studio, SDK tools - avd, adb etc., to build and deploy Android applications on the emulator(s). Topics include: Designing user interfaces with Layouts, Fragments and Activities. Students learn to manage Android Resources, work with Manifest files, persist data, create Services, leverage multi-threading constructs and make use of REST endpoints. Other topics of discussion include Location Based Services, network connectivity, accessing cloud services and data. This course is an elective in the CST/PTS Diploma. Upon completion, students may continue on to advanced courses and programs, COMP 3617 is a required course for the Web and Mobile Application Development Associate Certificate and an elective in the Advanced Java Development Associate Certificate. By the end of this course successful participants will complete a final project which includes using Java to design, build, and package and deploy an Android application to a mobile device. COMP 3617 will be offered once a year in the fall (September) term.
Prerequisite(s): ​COMP 2613 – Java Application Development or equivalent knowledge of developing applications in Java Standard Edition (JSE).

This hands-on course continues from COMP 2614 and prepares those who are already C# programmers for advanced C# application development. Students who also have HTML5, CSS3, JavaScript and jQuery will build on their C# experience to create Enterprise level desktop and N-Tier software applications. Participants learn various software architectural patterns including "designing applications with the Service Oriented Architecture" and "Scaling applications with Microservices and NServiceBUS 6". Topics include: A review of ADO.NET and then a focus on Entity Framework (Code First, Model First, and Database First), Repository Pattern, Object Serialization and Deserialization, Discussions include: Services (WCF, WEB API, and Microservices), Asynchronous Programming with async/await, C# Design Pattern Strategies, Dependency Injection and MEF. Labs and assignments reinforce best practices in the use of architectural patterns. Students may also be interested in COMP 3973- ASP.NET Core MVC. Upon successful completion, participants will be able to create commercial quality software applications using the latest Microsoft technologies. This course is an elective in the CST/PTS Diploma and is offered once per year in January.
Prerequisite(s): COMP 1850, COMP 2015 and COMP 2614 or equivalent knowledge.

This hands-on course introduces the foundation of Java Enterprise Edition (JEE) web tier development. Continuing on from COMP 2613 this course was designed specifically for experienced Java Standard Edition (JSE) application developers. Students will receive a review of the Software Development Life Cycle (SDLC) followed by best practices and using industry standard techniques on how to build, deploy and distribute Java web applications into application servers. Topics include: Maven, Servlet and Java Server Pages (JSP). Additional topics include configuration of Java containers like Apache Tomcat or Jboss. Assignments, labs and exercises focus on design and creation of Java web apps on application servers and include a mandatory online component. Successful participants will practice how to build and deploy well designed basic Java Web applications to industry standards. Upon completion, students may register for COMP 4613 - Advanced Java Web Development offered in September. Both of these courses are required in the Advanced Java Application Development (AJD) Associate Certificate and are electives the CST/PTS Diploma. COMP 3656 will only be offered once per year in the spring term.
Prerequisite(s): COMP 2613 – Java Application Development or equivalent knowledge of developing applications in Java Standard Edition (JSE).

This hands-on course follows on from COMP 2629. Students, who already understand network design and TCP learn to work in teams to plan, install and administer the Microsoft Windows Server 2016 in a virtual environment using VMWARE. Students are required to provide their own SSD drive with 120 GB capacity for back-up each week. Participants will gain experience of administration practices used in a client /server network environment. Topics include: Design and Implement Active Directory, creating and maintaining users and groups, roaming profiles, DHCP, DNS, VPN, Terminal Services management, storage solutions using RAID, print servers, group policies, backup management, and an disaster recovery management. File management techniques using Dynamic Disks and RAID will also be discussed. There is an overview of troubleshooting, performance monitoring and the fine-tuning a MS Windows Server 2016 for optimal performance. This course also provides some preparation for the MCSE exam 70-741; however additional self-study is required before writing the certification exam. Participants will be prepared to continue on to COMP 4704 Applied Network Security prior to COMP 4912 Applied Virtual Networks. Upon successful completion of COMP 3700 Microsoft Windows Server Administration, students will be able to use built-in troubleshooting tools, monitor performance, and implement a security and recovery plan for Windows Server 2016. COMP 3700 will be offered every other term.
Prerequisite(s): COMP 1002 - Applied Computer Concepts and COMP 2629 - Enterprise Networking Fundamentals, or equivalent knowledge

Windows PowerShell is a popular task automation and configuration framework from Microsoft built on .NET. PowerShell includes scripting tools to automate and control systems, programs and files to improve productivity and reduce effort in all aspects of Windows computing. This hands-on lab course is aimed network or database administrators and software developers. PowerShell scripts are used for network or database automation, monitoring and maintenance. PowerShell scripts 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. Successful participants will be able to automate many tasks with PowerShell and reduce effort by creating scripts that can run interactively or automatically. This course is an elective in the Applied Network or Applied Database Administration and Design Associate Certificates, plus the CST Diploma from Computing Part-time Studies. COMP 3771 is offered in April and September.
Prerequisite(s): COMP 1451 or COMP 1630 or COMP 3700

Following on from COMP 2831 - Business Analysis and Systems Design, this hands-on course introduces the concepts, tools and processes needed to be perform Quality Assurance (QA) and software testing. Students with some programming background are shown best practices and will focus on creating and executing test plans using test cases and test scripts. They will practice how to record and report results, as well as document identified issues. Exercises and labs will include using popular open source QA software testing and tracking tools. Topics include: Black Box, White Box and Grey Box testing techniques and all aspects of QA planning and execution. Automated testing topics include constructing a framework, scripting techniques, generating test data, test architecture, pre/post-processing, test maintenance, and job specific metrics. Successful participants will be able to understand effective software testing methods, create a Quality Assurance plan and a test plan as well as be able to monitor test processes, evaluate test results and conduct automated testing to industry standards.
Prerequisite(s): COMP 1409 and COMP 2831 or equivalent post-secondary computing education.

Continuing on from COMP 1630 this workshop is a primer on business intelligence, data warehouse and data analytics for those moving on to higher level courses. Students must already understand industry standards in data modeling, relational database design and creating reports with SQL. This weekend workshop provides an overview of data warehouse planning and design for those moving on to the specific Business Intelligence Analytic tools covered in: COMP 4679, COMP 4680 and COMP 4681. Topics include: an overview of business intelligence the role of Extract, Transform and Load (ETL) in the data warehouse, the typical data warehouse lifecycle, plus an introduction to dimensional modeling for data warehousing. Labs focus on ETL, data quality considerations, and dimensional modeling concepts including the star and snowflake schemas. Successful participants will have an understanding of Business Intelligence concepts and industry standards in data design for data structures for information systems.
Prerequisite(s): COMP 1630 or equivalent knowledge of data modeling and SQL.

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, COMP 4680 and COMP 4681.
Prerequisite(s): COMP 1630

​This hands-on application development course was designed for experienced object oriented programmers. Students must have prior experience developing a software application, they are also required to work in teams and participate in online activities. The focus of COMP 3912 is on the user interface components of current popular iOS business applications. In order to follow this course participants need to be avid users of iPhones. Students must also provide their own 2018 or newer MacBook Pro with OS X Mojave or higher in this BYOD course. BCIT Computing students who do not currently own a current MacBook are entitled to purchase one from Apple Canada at a student discount. Participants have access to Apple resources for the development and testing of iOS applications during this course. Students design and develop apps for the current iOS platform to Apple standards. Starting with an intensive overview of the Swift programming language and the Model View Controller (MVC) design pattern, students are introduced to the iOS development platform via in class labs and exercises. Topics include; Xcode, Cocoa Touch API, Swift, SwiftUI, troubleshooting and debugging, Git source control basics, memory management, user input and gesture recognition. Additional topics include: Auto Layout, data persistence including Core Data, NSUserDefaults and Plists. Testing, networking, SpriteKit, Core Location and multi-threading are also discussed. Upon successful completion of COMP 3912 students will be able to design and build a commercial quality iOS application for iPhone.
Prerequisite(s): ​COMP 2613 or COMP 2614 or equivalent ability to develop a complete software application using Object Oriented Programming languages and tools. Note: Students must be avid iOS app users of and provide their own iPhone and MacBook to use in class.

Docker is the industry standard containerization platform that enables standard packaging of applications for development and deployment. This hands-on course was designed for students who are already web application developers who want their choice of tools, application stacks and deployment environments. Participants who are able to write code in a variety of web programming environments are introduced to container technologies. COMP 3916 begins with an introduction to the Linux operating system, then the installation of Docker followed by architecture discussions and more efficient use of system resources. Students are shown how to run containers and build custom images by pulling and pushing images from the Docker registry. Labs and assignments include composing applications using popular open source software like Python, Node.js, Java and .NET Core to run on containers. Topics include: DevOps, Docker Swarm orchestration engine, networking containers, and data persistence using volumes. Docker on Windows and cloud providers support for containerization technologies are also discussed. Microservices concepts are also introduced in the context of containers. COMP 3916 is an elective in the BCIT computing advanced associate certificates; Web and Mobile, Advanced Java, and Advanced .NET Application Development, as well as the CST/PTS Diploma. Upon completion students will be able to use Docker to accelerate workflow and enable faster software delivery.
Prerequisite(s): COMP 2912 or COMP 3656 or COMP 3973

ASP.NET MVC (Model View Controller) allows students to build scalable and secure web applications to industry standards. Following on from COMP 2015 and COMP 2614 , web developers who already understand HTML5, CSS3, JavaScript and jQuery build on their experience with C# in the .NET Framework in this hands on course. Participants use patterns to script dynamic MVC websites in an alternate approach to ASP.NET Forms. Students learn to use both C# and Razor with the ASP.NET MVC framework to develop powerful data driven web applications with HTML5, jQuery and AJAX for full control over mark-up. Homework, exercises and labs focus on best practices in ASP.NET MVC. COMP 3973 is an elective in “Web and Mobile Application Development” and the CST/PTS Diploma. Students may also be interested in COMP 3618- Advanced C# Application Development. By the end of this course successful participants will be able to design, create and deploy sophisticated web applications with the latest ASP MVC tools. This course is offered once per year in September.
Prerequisite(s): COMP 1850 and COMP 2015 and COMP 2614

This hands-on course was retired, it continued from COMP 2614 and prepared students who are already .NET programmers (C# or VB.NET) to develop new cloud based applications with Microsoft Azure. Topics included: Windows Azure Architecture and Administration, local storage, storage emulators, deploying a service application, deploying a web application, and SQL Azure. Labs and exercises focus on Service Oriented Architecture (SOA) and how to leverage Windows Azure for cloud computing. Windows Azure Mobile Services for iOS and Android was also discussed along with the differences between SQL Azure and Azure Storage. Upon successful completion, participants were able to develop new cloud based applications or port existing applications to Windows Azure using Visual Studio. This course was an elective in the Advanced .NET Associate certficate and it last ran in January 2017.

This hands-on course continues on from COMP 3613. It assumes students are capable of writing software applications in Java. Students continue to explore Java EE in regard to Web Application and Servlet APIs with a focus on web application design. They practice organization and deployment which also helps to prepare them to move on to COMP 4656. Labs and exercises focus on industry standards to develop and deploy web applications using build tools such as Maven. Topics include: Web tier programming with variety of Java technologies such as JSP, JSTL, JSP EL, JSP custom tags, DisplayTag and popular Java web development frameworks such as PrimeFaces and Vaadin. Upon successful completion students will have a better understanding of Java Web App Development and are prepared move on to COMP 4656 Java Enterprise Edition Programming. COMP 4613 is offered once per year in September.
Prerequisite(s): COMP 2613 and COMP 3613 or equivalent knowledge.

​Continuing on from COMP 4613, this hands-on course focuses on development of Java Enterprise applications. Participants must already understand JDBC, Java Servlets, JSP, JSTL, XML and XML schemas. This capstone project is the final course in the Advanced Java Development Associate Certificate and is designed for experienced Java web developers who want to enhance their skills further by learning how to design and develop large scale enterprise applications. Students begin with an introduction to the Java EE application model, which defines the architecture for implementing services as distributed multi-tier application. Labs, exercises and assignments focus on creating web applications and web services using variety of industry standards and design patterns. There is a mandatory online component via D2L along with 3 hours class time each week. Topics include: Java Persistence API with Hibernate implementation, binding between XML and Java objects using JAXB API, RESTful and SOAP Web Services, Enterprise Beans and the Java Messaging Service API. By the end of the course, successful participants will have the skills to build multi-tier Java web applications by employing a variety of JEE libraries and integration techniques to industry standards. COMP 4656 will be offered once a year in the winter (January) term.
Prerequisite(s): COMP 4613

This hands-on course follows on from COMP 3015 – Introduction to PHP. Students focus on using MySQL and phpMyAdmin as the relational database management system (RDBMS) with PHP as the web scripting language. Students with a prior knowledge of PHP will learn to design and manage MySQL databases, as well as perform requisite database related operations using SQL queries and PHP MySQL API. Fundamental concepts, such as transactional operations and SQL-related programmability are covered as well as using MySQL as the data layer for PHP-based Content Management Systems (CMS). This course offers an introduction to the use of MySQL for custom WordPress applications and plugins. Labs and exercises allow to effectively use the MySQL in PHP applications and to select appropriate approach to resolve practical data usage. Upon successful completion students will be able to use PHP with MySQL to develop data driven web applications to industry standards, and solve practical data usage problems.
Prerequisite(s): COMP 3015 Introduction to PHP or equivalent knowledge.

This hands on course continues on from COMP 3015 – Introduction to Web Applications with PHP. Students focus on Object Oriented Programming (OOP) with PHP to develop complex commercial quality web applications. Starting with the PHP in the command line interface (CLI), labs and exercises use open source libraries and integrate with application frameworks and for safely persisting passwords. The model-view-controller (MVC) pattern, the most popular pattern for advanced web applications currently in use is introduced.. Application Program Interface (API) services, OAuth open standard for consumer implementations and Cross Origin Resource Sharing (CORS) is discussed and used in assignments. JavaScript Object Notation (JSON) middle-ware is also introduced to see how front end applications communicate with back end applications. A bonus project is also available for those students who wish to work with ReactJS in a front end framework built in JavaScript. COMP 4669 is an elective Applied Web Development (AWD) and the CST/PTS Diploma. It is also required in the Web and Mobile Application Development (WMA) Associate Certificate. Upon successful completion students will learn to power a front-end Single-page-application (SPA) by creating a back-end PHP service to create an advanced web application. COMP 4669 will only be offered in the winter (January) term.
Prerequisite(s): COMP 3015

​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. Please note: COMP 4677 will be offered in the winter (January) and spring (April) terms.
Prerequisite(s): COMP 1630 or equivalent knowledge.

​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 in the winter (January) and fall (September) terms.
Prerequisite(s): COMP 1630 or equivalent knowledge.

​Following on from COMP 1630 and COMP 3838, this course is for students who already understand relational database design, data modelling, SQL programming and data warehouse foundations for business intelligence. Participants are provided with an in-depth understanding of authoring, managing and delivering traditional and interactive reports using Microsoft SQL Server 2016 Reporting Services (SSRS). 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 an overview of Microsoft SQL Server 2016 Analysis and Integration Services, which provides additional business intelligence architecture concepts and some preparation towards the Microsoft certification exams. Successful participants will learn to extract the data from its multiple collections of applications and data sources, how to deliver and manage reports, to integrate SSRS reports and apply best practices for reports authoring, deployment and management. Please note: COMP 4679 will be offered in the Spring (April) and Fall (September) terms.
Prerequisite(s): COMP 1630 and COMP 3838

This advanced course follows on from COMP 4677 and is designed for those who already understand relational database design, data modelling, SQL programming and MS SQL Server Administration but have little or no extract, transform, and load (ETL) experience. The course will cover ETL fundamentals, SQL Server Integration Services (SSIS) tools, and SSIS package development. Students will use Business Intelligence Development Studio (BIDS) in the lectures and labs to work with control flows, data flows, variables, package configuration and deployment, security, troubleshooting, logging and tuning. Students will also be introduced to ETL for the data warehouse. This course also helps to prepare for the SSIS component of the Microsoft Certified Technology Specialist (MCTS): Business Intelligence Developer, which is available through third parties for additional fees. Successful participants will gain a deeper understanding of ETL and Business Intelligence using Microsoft tools. COMP 4680 is currently under review and is not being offered at this time.
Prerequisite(s): COMP 4677

This hands-on course follows on from COMP 1630 and COMP 3838. 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): COMP 1630 and COMP 3838

Network security relates to how data is accessed and protected by the underlying networks and systems infrastructure. This hand-on course is aimed at network security practitioners and follows along from COMP 3704 "Applied IT Security Fundamentals". COMP 3704 and COMP 4704together replace COMP 3705 for more in depth coverage of topics in both IT Security and Network Security. Participants must have a prior understanding of networking as well as related protocols and technologies, Linux, Windows Server and IT Security fundamentals before registering in COMP 4704. Guided by local industry network security practitioners, students will complete labs and exercises to gain knowledge of best practices used in network security. Topics include: monitoring and diagnosing networks, understanding network devices and infrastructure, access control, authentication, authorization, malware, vulnerabilities and threats. Protecting wireless networks and securing the cloud are also discussed. Upon successful completion of this course students will be able use best practices and current tools to analyze network traffic and study attacks, understand how to protect networks against intrusions and denial of service attacks, and design and maintain secure computer networks. This course will be offered in the September term.
Prerequisite(s): COMP 2629 and COMP 2766 and COMP 3700 and COMP 3704