Computer Systems

​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

​This hands-on advanced course follows COMP 2132 –Web Development with JavaScript and is aimed at students who already possess a solid understanding of web development and who have client-side programming experience. COMP 3015 begins with basic client-server concepts. Participants are then introduced to server-side programming with PHP and a variety of open-source software tools. Topics include: data encoding, regular expressions, input sanitization, dependency management with Composer, and common components to a typical web application. MySQL, password hashing, and TLS are also discussed. Labs and assignments include using: file I/O, password hashing functions, plus uploading images and other files to a server. Participants gain hands-on experience developing and deploying server-side software in an Object- Oriented Programming (OOP) approach Students practice obtaining and processing user input, basic web application security and how to mitigate the dangers of cross site scripting, session hijacking, and SQL injection. COMP 3015 is a required course in the Web and Mobile Application Development (WMA) Associate Certificate, and the CST FLEX Diploma, which have significant coding prerequisites. Note: Applied Web Development (AWD) students without Java or C# programming language experience are advised to complete COMP 3012 -Back-End Web Development with Node.js, prior to this course. Upon completion, successful students will be able to develop commercial quality web applications and move on to COMP 4669 -Advanced Web Applications with PHP.
Prerequisite(s):

• 60% in COMP 2132

This hands-on computer programming software application development course follows on from COMP 2511 and COMP 2601. It assumes students have prior knowledge of both procedural programming with C and understand object-oriented programming fundamentals using Java or C#. COMP 3603 starts with a quick review of the language syntax that is common to C, Java, C# and C++. Students are then introduced to C++ classes, and how inheritance, polymorphism, abstraction and modularization all relate to the C++ language. Participants must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and exercises focus on the coding style and naming conventions used to build and deploy commercial quality C++ applications. Topics include: C++ Stream Input/Output, operator overloading, templates functions and classes, exception handling, and introduction to the Standard Template Library. Multiple inheritance to model complex algorithms is also discussed. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 16 total hours each week; 3 hours of class time, a 1-hour online component and 12+ hours of homework each week. COMP 3603 is the prerequisite for COMP 4603 – Advanced C++Application Development, starting September 2022. Both courses are electives in the Applied Software Development (ASD) Associate Certificate and both are required in the CST/PTS Diploma. Upon completion, successful students will be able to build and deploy well designed, entry-level C++ applications and be prepared to move on to COMP 4603- Advanced C++ Application Development.
Prerequisite(s):

• 60% in COMP 2511 and 60% in COMP 2601

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

• 60% in COMP 1002

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

• 60% in COMP 2825 or 50% in 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):

• 50% in COMP 2121 and (50% in COMP 2522 or 50% in COMP 2526 or 60% in COMP 2601 or 60% in COMP 2613 or 60% in COMP 3601)

​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. This course is offered in the fall (September) and spring (April) terms.
Prerequisite(s):

• 60% in COMP 2831

This hands-on advanced software application development course follows on from COMP 2511 and COMP 3603. It assumes students have solid knowledge of procedural programming with C, understand object-oriented programming and are able to write intermediate-level programs in C++. COMP 4603 starts with a quick review of writing and testing a well formed C++ program. Students are then introduced to best practices, common design patterns and features added to the C++ language up to C++ 20 to develop significant software applications to industry standards. Participants must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and exercises focus on building and deploying advanced C++ software applications for business and commercial use. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 16 total hours each week; 3 hours of synchronous class time, 1+ hour asynchronous activity in the BCIT Learning Hub. Participants should plan for 12+ hours of homework, reading and research each week. COMP 3603 and COMP 4603 are electives in the Applied Software Development (ASD) Associate Certificate and both are required in the CST/PTS Diploma. COMP 4603 – Advanced C++Application Development replaces COMP 2618 and will be offered starting September 2022. Upon completion, successful students will be able to build and deploy advanced C++ software applications to industry standards.
Prerequisite(s):

• 60% in COMP 2511 and 60% in COMP 3603

​​Following on from “Procedural Programming with C" and “Computer Architecture and Organization"; students are introduced to the basic concepts, terminology and leveraging operating systems for concurrent software applications. COMP 4737 replaces COMP 4731 in the CST/PTS Diploma. Participants focus on using concurrent programming: processes and threads, inter-process communication (IPC), synchronization and mutual exclusion, deadlock and starvation with an introduction to memory organization. Theoretical topics include: overall operating system structure, operating systems services, how these services are used, and kernel architecture. Labs and exercises reinforce concepts with examples of using these operating system services within application programs. This course is equivalent to COMP 4736 in the Full-time CST Diploma. Upon successful completion, students will be able analyze, design and implement concurrent software applications. COMP 4737 is required for the Computer Systems (CST/PTS) Diploma and is offered twice per year the Winter (January) and Spring (May) terms.
Prerequisite(s):

• (50% in COMP 2510 or 60% in COMP 2511) and (50% in COMP 2721 or 60% in COMP 2825)

​The course examines ethical and legal issues related to employment as a computing professional, including tensions between personal interests, interests of the company and interests of clients. This course identifies and examines a range of ethical dilemmas likely to be encountered by professionals in the computing industry. Students will be given the theoretical tools to identify and analyze the issues, evaluate them, and propose solutions. Students will develop competence in moral reasoning through examining case studies that describe ethical and legal problems including: Employment (e.g., resume padding, resume fraud, employment contract, conflict of interests, rights and duties of employers and employees, etc.) Remote work (e.g., productivity, trust, opportunities for promotions, privacy, security, etc.) Contracts (e.g., non-disclosure and non-compete agreements, contract law, freedom and autonomy, etc.) Internet fraud (e.g., cybercrime, fraud, hacking, spoofing, phishing, dark patterns, etc.) Property rights (e.g., intellectual property, trade secrets, copyright, patents, open-­­source code, screen scraping, selecting software licenses, etc.) Data (e.g., data storage, data privacy, data residency, data custody, professional negligence, legal data protection, hacking, spoofing, phishing, fiduciary obligations, etc.)​
Prerequisite(s):

• BCIT ENGL 1177, or 6 credits BCIT Communication at 1100-level or above, or 3 credits of a university/college first-year social science or humanities course.

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. Math 1060 plus Math 1061 together are equivalent to Full-Time CST Math 3042. Math 1061 is required for the CST/PTS Diploma and is only offered in the winter (January) and summer (August) terms.​​
Prerequisite(s):

• 60% in MATH 1060

This hands-on introduction to UX/UI is aimed at those who want to experience the development of user interfaces for applications, web sites, mobile applications, and information systems. COMP 1011 follows an iterative and agile approach focusing on User-Centered Design (UCD) as the motivator for product direction. Participants are expected to work within interdisciplinary teams, there will be an emphasis on collaboration, brainstorming, and the continued evolution of an interface concept based on UCD. User Experience (UX) encompasses a wide range of activities including User Interface (UI) design, Information Architecture (IA) and user research. Usability design and testing, tight integration and collaboration with software development processes are included in UX. COMP 1011 is required in the Computer Systems Certificate, CSC and is an elective in several other Computing programs. Upon completion, successful students will be able to incorporate user-centered iterative design principles and processes into a wide variety of IT projects.
Prerequisite(s):

• 60% in COMP 2831 or 60% in COMP 2501 or 60% in COMP 2132

​​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 practice how to implement primary agile methods and within the scrum framework. COMP 2833 assumes that all participants have strong English communication and interpersonal skills. This course helps students prepare to challenge the Professional Scrum Master, PSM certification exam from a third party (for an additional cost). Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. In class exercises include: self-directed teams, writing of user stories, Agile estimating with relative sizing, co-location, metric reporting and test-driven development. Topics include: Scrum, Extreme Programming, Lean/Kanban, Dynamic Systems Development Method, and Feature-Driven Development. Participants will experience the roles of Scrum Master, Scrum Product Owner, and Developer, both real-time in class and also online with a dispersed agile team. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. Students may have an average total time commitment of 13 hours; 3 hours of synchronous class time, a 1-hour online component, plus 9+ hours outside of class each week. COMP 2833 is a required course in the Computer Systems Certificate, CSC and an elective in the Applied Software Development, ASD Associate Certificate. It is a required prerequisite for COMP 2836 -Agile Business Analysis and Project Leadership in the Agile Development Associate Certificate and Computer Systems Technology, CST/PTS Diploma. Upon completion, successful students will have gained significant experience to prepare for the PSM certification exam, and to work on agile teams. Computer Systems Certificate, CSC students should complete COMM 2216 prior to COMP 2833.
Prerequisite(s):

• 60% in COMP 2831

This hands-on course follows on from COMP 1002 -Applied Computer Concepts and is aimed at students who are already able to use a Windows PC and able to manage files on a network, in the cloud. Topics include essential skills for proficiency in MS Word, MS Excel and MS PowerPoint using a student version of MS Office 365, hosted by BCIT. COMP 2010 includes lectures, lab exercises and assignments outside of class in MS Word, MS Excel, and MS PowerPoint. Students will also receive an introduction to simple databases with MS Access and be prepared to move on to the follow-on 6-week courses offered once per year: COMP 2361 MS Word Advanced in October, and COMP 2362 MS Excel Advanced in June. COMP 2010 is required in the Applied Computer Information Systems (ACIS) Associate Certificate. It is an elective in the Technical Writing Associate Certificate and the Computer Systems PTS Diploma from BCIT Computing. Upon successful completion, students will be able to create, edit and manage documents, spreadsheets, and presentations in the cloud.
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):

• 60% in COMP 2132

​Power BI is a Microsoft collection of tools and an analytics service for data visualization and business intelligence reporting. BCIT Computing offers a series of MS Power Bi courses. COMP 2156 is a hands-on intro course designed for database professionals, data analysts, business analysts and managers. It follows on from COMP 2362 or COMP 2364, it assumes that students have an understanding of statistics for data analysis and advanced 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. Participants must provide their own current model PC capable of running Windows 10 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 2156 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and a required course in 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. They will be prepared to move on to the next level COMP 3156 –MS Power BI Optimization and COMP 3157–MS Power BI Advanced Data Visualization.
Prerequisite(s):

• 60% in COMP 2362 or 60% in COMP 2364

​Crystal Reports by SAP is a low-code well established reporting solution used to create reports and dashboards from a wide variety of data sources, with minimal coding for Business Intelligence (BI). Students who know how to use a Windows PC and MS Office are introduced to planning and developing business intelligence reports. COMP 2252 participants will create dynamic reports and dashboards. Labs and exercises apply best practices in: report design, how to extract and manipulate data, and display information in custom formats from many sources. COMP 2252 is an elective in Applied Computer Applications (ACA); Applied Computer Information Systems (ACIS); Applied Database Administration and Design (ADAD) Associate Certificates, as well as the Applied Data Analytics Certificate (ADAC) and the Computer Systems Technology (CST FLEX) Diploma. Please note: This course will be offered in the January (Winter) or September (Fall) terms. By the end of this course, successful students will be able to use Crystal Reports to display and analyze data visually for BI and to make actionable decisions.
Prerequisite(s):

• 60% in COMP 2010 or 60% in COMP 2364

​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. We recommend that students working toward a Computing credential complete COMP 1630 first.
Prerequisite(s):

• COMP 1002

​​This instructor lead, hands-on course continues on from COMP 2010. Students must have prior knowledge and skills at using the basic and intermediate features of MS Excel before starting this Advanced MS Excel course. Participants start at an intermediate level and progress to expert in just 6 lessons while practicing how to create and manage a variety of meaningful spreadsheets. COMP 2362 focuses on the best practices, time saving techniques and how to use MS Excel to create to analyze, communicate and manage information. Lectures, lab exercises in class and assignments outside of class are used for an applied learning experience. Advanced topics include: consolidating data in multiple worksheets templates, dealing with error messages, solver and basic macros. Students who have not completed COMP 2010 should know subtotalling, pivot tables and pivot charts. Participants progress from intermediate to expert in just 6 weeks. This course is an elective in the Applied Computer Information Systems (ACIS) Associate Certificate from BCIT Computing. By the end of this course, successful participants will be expert end users of MS Excel. This course is offered once a year in the Spring (April) term.
Prerequisite(s):

• 60% in COMP 2010

​​​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. This course is also equivalent to ACIT 2620 - Principles of Enterprise Networking, in the full-time CIT Diploma. 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 a practical understanding of the principles of data communications for enterprise networks. This course is offered in the April (spring) and September (fall) terms.
Prerequisite(s):

• 60% in COMP 1002

​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 FLEX 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) or fall (September) terms.​
Prerequisite(s):

• 60% in 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):

• 60% in COMP 2766

​This hands-on course follows on from COMP 2833, and builds on the content of the Scrum Guide. Students who have experience with Agile Methods and the Scrum Framework will use integrated case studies for Agile Business Systems Analysis. COMP 2836 assumes student participation in exercises and simulations within the Scrum and Kanban frameworks. Students must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. ​Topics include: forming self-directed teams, team dynamics and coaching. In class exercises include applying Agile Project Leadership styles through role-play in actual teams. 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. Continuous collaboration with the product owner and the self-directed Agile Project Leaders team is reinforced. ​Students engage in delivering business value to clients with production ready concepts early and throughout the project. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. COMP 2836 is a required course in the Agile Development Associate Certificate and is an elective in the Computer Systems Technology (CST FLEX) Diploma. This course will be offered once per year in the winter (January) term. Upon completion, successful students will have gained significant experience with Agile Analysis methods and Agile Project Leadership techniques.
Prerequisite(s):

• 60% in COMP 2833

​This hands-on web programming course follows on from COMP 1850 or COMP 2132. It 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 an 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 2913 React and Modern JavaScript, plus COMP 3012 Back-End Web Development with Node.js. Upon successful completion students will have experience using these rich advanced JavaScript frameworks to develop data-driven and interactive single-page web applications for all mainstream browsers.
Prerequisite(s):

• 60% in COMP 2132

​This hands-on course follows on from COMP 2132 and replaces COMP 2912. It was designed for students with prior experience developing web pages using HTML5, CSS3 and JavaScript. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Starting with how Node.js fits into client-server software architecture, participants will focus on the Node.js programming model. Labs and exercises cover creating, installing and using node modules. Web frameworks like Express.js and Jest as used to build and test powerful web applications. Students will experience how Node.js is used by enterprise environments and modern web stacks like MEAN and MERN. Topics include: how to build, and deploy a RESTful API following best-practices, and learn error handling strategies. Typescript integration with Node.js as well as how to connect to databases will also be discussed. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 11 hours each week; with 3 hours of class time, and 8 hours of homework. Web developers should also consider multiple advanced JavaScript tools including: COMP 2909 Angular and Vue.js Fundamentals and COMP 3013​ Front-End Web Development with React.js. COMP 3012 is an elective in several BCIT Computing applied associate certificates; Web Development (AWD), Web and Mobile Application Development (WMA), Advanced Java Development (AJD) and Advanced .NET Development; as well as the CST FLEX Diploma. Upon completion, successful students will be able to use Node.js to build robust, scalable, data intensive web applications with user authentication.
Prerequisite(s):

• 60% in COMP 2132

React.js is an open source JavaScript library widely used to create fast, modular web and mobile applications. This hands-on course follows on from COMP 2132 and was designed for students with prior experience developing web pages using HTML5, CSS3 and JavaScript. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Starting with an introduction to React.js concepts, participants concentrate on how React works with browsers and the Document Object Model (DOM). Then students use the modern Hooks API to built clean and testable components. Instructor led labs and exercises focus on how to structure and develop single-page applications using NPM, Webpack and Babel, following current industry standards. Topics include: Routing, Server-Side Rendering, Styling, State Management, and deployment. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 11 hours each week; with 3 hours of class time, and 8 hours of homework. ​Web developers should also consider learning multiple advanced JavaScript tools including: COMP 2909 -Angular and Vue.js Fundamentals and COMP 3012 Back-End Web Development with Node.js. COMP 3013 is an elective in several BCIT Computing applied associate certificates; Web Development (AWD), Web and Mobile Application Development (WMA), Advanced Java Development (AJD) and Advanced .NET Development; as well as the CST/PTS Diploma. Upon completion successful participants will be able to use React to create and deploy dynamic web applications quickly, with more functionality and less code. This course replaces COMP 2913 as of January 2023.
Prerequisite(s):

• 60% in COMP 2132

​Following on from COMP 2156 , and parallel to COMP 3157, this hands-on advanced course was designed for Business Intelligence and Data Analysts. Students who already know how to use Power BI to build and publish reports begin with an in-depth introduction to Star Schema and its relevance to optimal Power BI data modeling. COMP 3156 in-class labs and exercises focus on specific strategies to optimize large complex Power BI data models and how to leverage Power BI Service in the cloud for fast performing reports. Topics include relational data modeling in Power BI, Designing Import, DirectQuery, and Composite Data Models. There is also an in-depth explanation of Power BI Service Performance Monitoring. Tabular Editor and DAX Studio are also discussed. Labs and assignments include managing security permissions, data visibility based on role as and leveraging specialized third-party tools. Tabular Editor and DAX Studio are used to monitor and evaluate data model performance. Participants must provide their own current model PC capable of running Windows 10 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 3156 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and the Applied Data Analytics Certificate (ADAC). By the end of this course, successful students will be able to build advanced, optimized data models and use the Power BI Service cloud environment.
Prerequisite(s):

• 60% in COMP 2156

​Following on from COMP 2156, and parallel to COMP 3156, this hands-on advanced course was designed for Business Intelligence and Data Analysts. Students who already know how to use Power BI to build and publish reports begin with an in-depth introduction to the dashboard development process. COMP 3157 in-class labs and exercises focus on creating advanced user-friendly reports and dashboards. Topics include visualization best practices, misleading data visualization practices to avoid, how to manage dashboard development projects and more. There is also an in-depth explanation of the Guided Analytics Approach and Dashboard UI/UX principles are also discussed. Labs and assignments include creating advanced reports with Power BI Desktop, identifying common data visualization pitfalls and discussing methods to apply visualization best practices. Participants must provide their own current model PC capable of running Windows 10 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 3157 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and the Applied Data Analytics Certificate (ADAC). By the end of this course, successful students will be able to build innovative and accessible dashboards for various stakeholder groups.
Prerequisite(s):

• 60% in COMP 2156

​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 JavaScript and 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 successful participants will be able to design scalable and secure distributed systems on AWS. ​COMP 3215 is offered once per year in January (Winter) term.​​
Prerequisite(s):

• (60% in COMP 2912 or 60% in COMP 3012) or (50% in COMP 2522 or 50% in COMP 2526 or 60% in COMP 2613 or 60% in COMP 2601) or (60% in COMP 2614 or 60% in COMP 3602 or 50% in COMP 3951)

​This fourth-level computer programming course follows on from COMP 2601 and assumes students have prior knowledge of object-oriented programming using Java. COMP 3601 starts with Java Standard Edition (SE) using the Java core APIs and the Eclipse IDE. Students practice the coding style and naming conventions used to build and deploy commercial quality Java applications. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and exercises focus using a variety of skills to debug programs and using design patterns to develop advanced applications in Java. 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. In the second half of COMP 3601 students are transitioned to Java Enterprise Edition (JEE) foundations for an introduction to Java web tier development. Labs and exercises focus on the design and 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. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 14 total hours each week; 3 hours of class time, a 1-hour online component and 10+ hours of homework. COMP 3601 is the prerequisite for COMP 4613 - Advanced Java Web Development offered in September. Both courses are required in the Advanced Java Application Development (AJD) Associate Certificate and are electives the CST/PTS Diploma Upon completion, successful students will be able to build and deploy well designed basic Java Web applications. This course replaces both COMP 2613 and COMP 3656 as of September 2021.
Prerequisite(s):

• 60% in COMP 2601

This fourth-level computer programming course follows on from COMP 2601 and assumes prior knowledge of object-oriented programming using Java. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 3602 starts with an introduction to C# programming with Microsoft Visual Studio and the .NET Framework 4.8 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, deploying a web service, asynchronous programming, working with SQL databases and effective application debugging. Students build graphical user interfaces (GUIs) and design Windows application software. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 12+ total hours each week; 3 hours of class time, a 1-hour online component and 8+ hours of homework. COMP 3602 is the prerequisite for COMP 4602​ .NET Web and Mobile Apps, both courses are required in the Advanced .NET Development (AND) Associate Certificate and are electives the CST/FLEX Diploma. Upon completion, successful students will be able to use C# to build and deploy cross platform software applications with the latest .NET technologies.
Prerequisite(s):

• 60% in COMP 2601

​​​Continuing on from COMP 2613 or COMP 3601, 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. 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 is under review and not currently being offered.
Prerequisite(s):

• COMP 2522 or COMP 2613 or COMP 3601

​This hands-on course follows on from COMP 1002 and COMP 2629. Students, who already understand how to use MS Windows, network data communication, and TCP will work in teams to plan, install and administer Microsoft Windows Server 2019. COMP 3700 is delivered 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 and best practices of administration used in a client /server network environment. Topics include: Design and Implement Active Directory, create and maintain users and groups, roaming profiles, DHCP, VPN, RDS management, storage solutions using RAID, print servers. Group policies, backup management, and disaster recovery are also discussed. There is an overview of troubleshooting, performance monitoring and fine-tuning MS Windows Server for optimal performance. Participants will be prepared to continue to COMP 4704 Applied Network Security. Upon completion, successful students will be able to use built-in troubleshooting tools, monitor performance, and implement a security and recovery plan for Windows Server 2019. Please note: COMP 3700 is only offered once per year in the fall (September) term.
Prerequisite(s):

• 60% in COMP 2629

PowerShell is a popular task automation and configuration framework. PowerShell includes scripting tools to automate and control systems, programs and files to improve productivity and reduce effort in all aspects of Windows computing. COMP 3771 is a hands-on lab course aimed network or database administrators and software developers. PowerShell scripts are used for network or database automation, monitoring and maintenance, and 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):

• 60% in COMP 1516 or 60% in COMP 1630 or 60% in 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):

• 60% in COMP 2501 and 60% in COMP 2831

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

• 60% in COMP 1630

​Continuing on from COMP 1630, this hands-on course is a primer for data warehouse and data analytics with Big Data. Students must already understand industry standards in data modelling, relational database design and creating reports with SQL. Participants must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and assignments use a web browser to access course content. Exercises focus on data ingestion, data extraction, data transformation, accessing/querying data, and data visualization. Students will use a variety of technologies and will learn about different big data systems including AWS Academy Data Analytics. Students conduct a big data analysis with practical, real-world examples and focus on how to analyze vast data sets using a case-study approach. Topics include an overview of different data stores, querying data with visualizations, and a deep-dive of Extract, Transform and Load (ETL) process in the data warehouse. BCIT Computing is an AWS Academy partner; A discount voucher for the AWS Certified Data Analytics–Specialty exam will be provided to those who pass this course. Upon completion, successful students will be able to leverage, and maintain a large-scale data warehouse for Business Intelligence.
Prerequisite(s):

• 60% in 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. This is a bring your own devices (BYOD) course, students must provide their own Mac computer with OS X Catalina or higher, plus a current iOS mobile device, ideally an iPhone. 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, 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. This course will be offered once per year in the spring (April or May) term.
Prerequisite(s):

• (50% in COMP 2522 or 50% in COMP 2526) or (60% in COMP 2613 or 60% in COMP 3601) or (60% in COMP 2614 or 60% in COMP 3602)

This hands-on course was designed for experienced web application developers. Students who are able to write code in a variety of web programming environments are introduced to containerization technologies. COMP 3916 begins with a brief history of virtualization technologies, followed by a discussion of Docker architecture and how to simplify the software delivery process using containers. Students build custom images by pulling and pushing images from the Docker registry and set up automated pipelines to build custom images directly from source control systems like GitHub. Topics include: DevOps enablement by Docker, Docker Swarm orchestration engine, networking containers, and data persistence using volumes. Labs and assignments include composing applications using popular open source software like Python, Node.js, Java and .NET Core to run on containers. Enabling Microservices architecture using containers and cloud providers support for containerization technologies are also discussed. COMP 3916 is a required course in our advanced web development programs; Web and Mobile, Advanced Java, Advanced .NET Application Development, and is an elective the CST/PTS Diploma. Upon completion, successful students will be able to use Docker to package applications for accelerated development and deployment to help enable software delivery at a faster pace.
Prerequisite(s):

• (60% in COMP 2912 or 60% in COMP 3012) or 60% in COMP 3601 or 60% in COMP 3656 or 60% in COMP 3973

​​This hands-on project practicum course includes an online component and allows students to work on projects within guidelines specified by faculty. The projects are drawn from a variety of sources, especially from industrial situations, and may require extensive contact with the business community. Students work in teams and seek advice from a faculty member acting as their project supervisor. COMP 3925 is equivalent to the Full-time CST Diploma projects COMP 3800 and is an elective in the CST/PTS Diploma. Admission is only by Computing PTS department approval. COMP 3925 is offered once a year in the spring/summer term.
Prerequisite(s):

• Completion of the CSC in PTS or first year CST Full-time.

​This hands-on course follows on from building software applications with C#.NET (COMP 2614 or COMP 3602) and web development with HTML5, CSS3, JavaScript and jQuery (COMP 2015 or COMP 2132). COMP 3973 students are introduced to ASP.NET Model View Controller (MVC) framework to build scalable and secure web applications. Labs and exercises reinforce patterns and how to script dynamic MVC websites to industry standards, in an alternate approach to ASP.NET Forms. Participants use both C# and Razor with MVC to develop powerful data driven web applications with AJAX for full control over mark-up. There is a focus on the latest tools and best practices used in ASP.NET. COMP 3973 is a required course in the “Advanced .NET Development", and “Web and Mobile Application Development" Associate Certificates. It is an elective in the CST/PTS Diploma a​nd offered once per year in ​the September ​(Fall) or January (Winter) term. By the end of this course successful participants will be able to design, create and deploy industry standard web applications. COMP 3973 was replaced by COMP 4602 starting January 2023. ​
Prerequisite(s):

• (60% in COMP 2015 or 60% in COMP 2132) and (60% in COMP 2614 or 60% in COMP 3602)

PLEASE NOTE: COMP 4613 will have it's final offering in September 2022. This course follows on from COMP 3601 or COMP 3656 and assumes students capable of writing significant software applications in Java and understand how to build basic Java Web Applications. COMP 4613 continues the exploration of JEE in regard to web applications and Servlet APIs. Students must provide their own current model PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Labs and exercises focus on web application design, organization and deployment using industry standards to develop and deploy advanced Java 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. Participants will create and use data sources, then practice how to encrypt and decrypt sensitive data, while it us in rest or in transit. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 14 total hours each week; 3 hours of class time, a 1-hour online component and 10+ hours of homework. 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 (JEE) Programming.
Prerequisite(s):

• 60% in COMP 3601 or (60% in COMP 2613 and 60% in COMP 3656)

​PLEASE NOTE: COMP 4656 will have its final offering in January 2023. 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.
Prerequisite(s):

• 60% in COMP 4613

​This hands-on course continues on from COMP 3015 –Web Application Development with PHP and is aimed at students who are already able to build significant PHP web applications. COMP 4669, begins with a review of topics covered in COMP 3015, then students are introduced to the Model-View-Controller (MVC) and Active Record patterns. Topics include: RESTful APIs, Caching, Message Queues, and Cross Origin Resource Sharing (CORS). Object-Relational Mapping (ORM) libraries are used in assignments and labs to interact with MySQL databases. WebSockets are also discussed with an emphasis on secure development practices and application performance. Labs and assignments use open source libraries and integrate with application framework and how to safely persist passwords and communicate with third party services. Participants use industry standard PHP frameworks to develop secure and scalable RESTful APIs with JSON responses. Application middleware is also introduced to handle CORS and cookie handling. COMP 4669 is an elective in the Applied Web Development (AWD), the Web and Mobile Application Development (WMA) Associate Certificates, and the CST FLEX Diploma. Note: Web Development students should also consider COMP 3012 -Back-End Web Development with Node.js and COMP 3013 -Front-End Web Development with React.js. Upon completion, successful students will be able to build and deploy front-end, single-page-applications (SPAs) by creating back-end PHP services for commercial quality server-side web applications. COMP 4669 will only be offered in the winter (January) term.
Prerequisite(s):

• 60% in 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):

• 60% in COMP 1630

​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):

• 60% in COMP 1630

​This hands-on course follows on from COMP 1630. Students who already understand relational database design, SQL programming are introduced to SQL Server Reporting Services SSRS. Students must provide their own current model Windows capable PC, i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Please note: BCIT does not provide technical support for student's hardware or operating systems. COMP 4679 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 a brief overview of Microsoft SQL Server Analysis Services which provides additional BI concepts. Labs and exercises show how to use SSRS to extract the data from its multiple collections of applications and data sources, how to deliver and manage reports, to integrate SSRS reports. Participants explore business intelligence platforms and apply best practices to author, deploy and manage reports with SSRS. COMP 4679 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. Upon successful completion of COMP 4679 students will be able to use SSRS to deploy a Reporting Services database, they will be able to extract data from multiple data sources and integrate traditional and interactive SSRS reports. Please note: COMP 4679 will be offered in the Spring (April) and Fall (September) terms.
Prerequisite(s):

• 60% in COMP 1630

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

• 60% in COMP 1630

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

• 60% in COMP 2629 and 60% in COMP 2766 and 60% in COMP 3700 and 60% in COMP 3704

​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):

• No prerequisites are required for this course.