This course explores the law pertaining to the Internet including copyright, trademark, online business method patents, domain names, online contracts, and jurisdictional issues. Liability issues related to linking, meta-tags, framing, and advertising and marketing will be examined. The course will focus on recent legal developments in various jurisdictions including Europe, the United States and Canada. Knowledge of law relating to the Internet and e-commerce will be conveyed in a lecture and workshop setting involving exercises, role-plays and case studies.

This is part 2 of a hands-on, intensive intermediate level course. This course requires that the student has successfully completed Comp 2617 C++ For Object Oriented Programmers, Part 1. The course will continue at the same pace and level of difficulty as Comp 2617. Topics include: operator overloading; template classes; exception handling; the string class and stream processing; the Standard Template Library; file processing; namespaces and some miscellaneous advanced topics. Prerequisites: COMP 2617

This new course replaces both COMP 2658 and COMP 2665 and covers the basics of designing, supporting and managing computer networks. Learn all about network data communications systems, concepts and terminology. Understand communications systems, business networking requirements based on the Internet, and the hardware and software needed. Students will work in groups to design networks, understand LAN cabling issues, addressing, connectivity options, network monitoring and how to make use of troubleshooting techniques.Topics include; data communication, network protocols, protocol implementations, LAN switching, virtual LANs and wireless networking. Upon successful completion, participants will understand how to interconnect computers, have a basic understanding of LAN theory, network design and be prepared to move on to COMP 3821, Enterprise Network Design. As an added benefit, some topics in this course will help in the preparation for the CompTIA Network+ exam. This course consists of one face to face meeting each week, group work, a significant online component and home work. Prerequisites: COMP 1002

This hands-on course will introduce students to Extensible Markup Language (XML) and how to incorporate XML into web-based applications. XML is a standard for structuring, and storing web information. Topics include XML syntax, DTD and XML Schema validation, namespaces, XSLT, XPath, and web technologies such as RSS, Atom and XML-RPC. Labs cover various parser technologies, declarative XML UI languages, data-modelling with XML, and using XML in AJAX-enabled web applications. Successful completion of course includes how to develop XML formats and be able to apply XML technologies to various web based applications. Prerequisite: COMP 1850 or equivalent HTML experience.

This hands-on course follows on from COMP 3821. Students work in teams to plan, install and administer a Microsoft Windows Server 2008, as part of a Windows server environment on PC network. Participants will gain an understanding of the best practices used in network server administration. Topics include: creating and maintaining users and groups, roaming profiles, DHCP, DNS, Virtual Private Network (VPN), Terminal Services, disk management, backups, print servers, group policies and Active Directory in the MS Windows Server 2008 environment. There is an overview of troubleshooting, performance monitoring and the fine-tuning of MS Windows Server 2008 for optimum performance. In addition this course provides some preparation for the MCSE exam 70-646. Upon successful completion students will be prepared to continue on to COMP 3701 Active Directory and COMP 3705 Applied Network Security. Prerequisite: COMP 3821 Enterprise Network Design with TCP.

This hands-on course follows on from COMP 3821 and introduces network security to those who already understand LAN design and TCP/IP networks. Students work in a lab environment to learn the concepts and technologies required to design and maintain secure computer networks. Topics include: risk analysis and security policy development, network protocols, architecture security, types of attacks and hacker techniques, authentication and encryption, Viruses, Worms and Trojans, and e-commerce security. There is an overview of firewalls; plus VPNs and IDS which are covered in greater depth in COMP 4707 -Applied Intrusion Detection Systems (IDS) and COMP 4708 -Applied Virtual Private Networks (VPN). Participants will use best practises and available tools to analyse traffic, and study attacks, plus understand how to protect networks against intrusions and denial of service situations. As a side benefit, many of the Security+ domains are covered for preparation towards the CompTIA Security+ certification. Prerequisites: COMP 2765 and COMP 3700 and COMP 3821

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. Prerequisites: COMP 2121 and (COMP 2611 or COMP 2613)

This hands-on course covers the theory, design and implementation of large scale and enterprise size networks. The functions and limitations of network layer protocols and design issues of the TCP/IP Network Layer protocol are discussed. This course focuses on the TCP/IP protocol; students learn how computers exchange data over the Internet and how network communication relates to network configuration and administration. Topics include: Selection criteria required to create, expand or improve a network, implementation of the TCP/IP protocol suite within a network and surrounding routing issues. Students will work in groups to study the theory and design of router operation, network performance, scalability and basic router security issues. Upon successful completion, participants will have an in-depth knowledge of TCP/IP, network masking; and how to plan and build a routed network. This course consists of one face to face meeting each week, group work, a significant online component and home work. Prerequisites: (COMP 2658 and COMP 2665) or COMP 2654

Objected Oriented Analysis and Design (OOAD) is the software engineering approach to modeling systems as groups of interacting objects. This advanced course for software analysts, designers and developers follows on from COMP 2830 and is aimed at those who already understand the Software development Life Cycle (SDLC). Through exercises and group work, students first perform Object Oriented Analysis (OOA) to produce a conceptual model of existing information. Starting with a detailed analysis and decomposition of requirements, case studies are used to identify actors and primary use cases for documentation. The next phase is Object Oriented Design (OOD), students learn how to identify classes and build the domain model which is a detailed description of how the system is built. Round trip engineering, reverse engineering and code generation are practised in labs, where the design is converted to functional code. The concepts of phases, iterations, activities and artifacts are emphasized throughout the course. Participants also gain hands-on experience using a case tool, Rational Rose Modeler, to draw most of the Unified Modeling Language (UML) diagrams necessary to support the OOAD activities. Topics include: design patterns, anti-patterns and General Responsibility Assignment Software Patterns (GRASP). Labs include the use of the Unified Process (UP) which is an extensible framework for iterative and incremental software development process, and the basis of all the modern 'Agile methodologies'. Students are introduced to automated software testing to create and execute test scripts in the lab with Rational Robot. This course consists of one face to face meeting each week, group work, an online component and home work outside of class. Successful participants will have gained the ability to analyse, design  and construct sophisticated software applications to industry standards. Prerequisite: COMP 2830 and ability to write executable code in an object oriented programming language.

This course replaces COMP 3730 and COMP 4730 and covers the concepts of operating systems. The course is designed for CST Diploma students who understand both C and Java programming. The main focus is on the structure and services of operating systems and how these services are used and implemented. Topics include: processor management, processes and threads, inter-process communication, synchronization, memory management, input/output and file management. Labs will include hands-on system programming in Unix/Linux. Prerequisites: COMP 2510 or COMP 3425

This course presents the study of factors that either influence or are influenced by people at work. Focuses on macro factors such as organizational structure, technology and environment; group factors such as group dynamics, leadership, conflict, change and decision-making; and individual factors such as personality, attitudes, perception and motivation.

Teaches the Simply Accounting for Windows integrated package to those with some knowledge of computing and accounting. Covers setting up a complete set of books including G/L, accounts receivable, accounts payable, inventory and payroll. Prerequisite: COMP 1002 and FMGT 1100 or equivalent knowledge of MS Windows and accounting principles.

This hands-on course teaches Project Managers how to use the MS Project application software package. There is an overview of common methodologies, however this course is aimed at those who already know project management (PM) concepts. Project Managers learn to develop plans and manage resources in order to deliver projects on time and on budget. Case studies are used to practice PM skills by developing plans and schedules over various phases of their projects in the MS Project application. Topics include: how to create schedules, assign resources, analyse workloads and detail tasks and materials required. Students will work in teams to complete a project plan from start to finish and understand how to track deliverables. They will learn to input and access project information, set milestones, track progress and make trade off decisions between cost, schedule and scope. Those taking this course for credit will have access to download MS Project 2010 Professional software for use at home during this course. BCIT School of Computing is a member of the Microsoft Developer Network Academic Alliance, MSDNAA. Successful participants are encouraged to learn more about industry standards and Project Management Institute (PMI) certifications. Prerequisites: COMP 1002

This hands-on, introductory course is for information technology students who want to learn how to develop and implement an IT project plan. Project Management (PM) discipline, best practices and decisions apply to various IT sectors including: Web Development, Databases and Networking. Topics include: identifying project stakeholders and defining roles and responsibilities of the team, defining scope, devising risks and quality plans, mapping-out a schedule, determining a budget and defining a communication strategy. Participants use MS Project 2010 and learn techniques to help them deliver IT projects on time, on budget and within the original project scope. Students receive an overview of common PM concepts and MS Project software. They are prepared to move on to COMP 1285 Using MS Project which goes into much greater depth in the use of the MS Project application. Successful participants are encouraged to learn more about industry standards and Project Management Institute (PMI) certifications. Prerequisites: COMP 1002

This hands-on course introduces server-side scripting using PHP (PHP: Hypertext Preprocessor) an open-source, platform-independent, web scripting language. After learning the basic PHP theory and syntax, topics include: textfile manipulation, cookies, regular expressions, sessions, graphics, and database interactions. By the end of this course, students have learned the major functions of PHP server-side scripting and how to freely obtain a wide variety of open-source software tools and code libraries. Prerequisite: COMP 1850 or equivalent HTML experience.

This course follows on from COMP 1850 in more depth and introduces new topics and techniques for developing effective web sites. Students will gain a deeper understanding of HTML and CSS. Additional JavaScript topics prior to COMP 1911 are also covered. Focusing on the most current versions of HTML, CSS and JavaScript, students will learn to combine these to create SEO-friendly content that utilizes stylesheets for presentation and JavaScript for behaviour. Topics will include: Current and emerging trends in HTML, detailed use of CSS for layout and presentation, introduction to JavaScript frameworks such as jQuery, leveraging Server Side Includes (SSI) for re-usable code, creating templates for Content Management System. COMP 1950 is a required course for the Applied Web Development Associate Certificate and is an elective in Web Application Software Development, as well as the CST Diploma. Students receive hands-on exposure to industry-standard web development methodology and will be able to design and build intermediate level websites. Prerequisites: COMP 1850 or equivalent HTML and CSS knowledge.

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 2010 and the .NET Framework 4 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. Upon successful completion, participants will be able to create executable Windows Form applications with the latest .NET technologies and be prepared to move on to more advanced .NET application development in COMP 3608 and COMP 3618. Prerequisite: COMP 1451 or equivalent knowledge of Object Oriented Programming.

This intensive, hands-on workshop is for programmers who already understand how to write code in the .NET environment. Students gain practical skills using the Windows Presentation Foundation (WPF) to develop advanced graphical user interfaces (GUI). WPF is a set of libraries in .NET which allows programmers to create, display, and manipulate, 2D and 3D images, video and audio media in a Windows environment. WPF topics include: Grid, UniformGrid, StackPanel, WrapPanel, DockPanel, and Canvas. The Extensible Application Markup Language (XAML) standard is also covered. With WPF it is possible to create dynamic user interfaces and visual effects not possible with Windows Forms. Upon successful completion of this workshop, participants will understand the use of WPF and be able to create advanced user interfaces for their .NET applications. Prerequisite: COMP 2614 or COMP 2690 or equivalent knowledge of C# or VB.NET

First level in a series of core Linux/Unix courses, designed to cover basic Linux/Unix concepts using the GNU/Linux operating system on the Intel platform. Topics include login procedures, the Linux/Unix shell, file and directory management, text editing, printing, e-mail, pipes and process control. Provides a solid foundation in a Linux/Unix environment. Prerequisites: COMP 1002

This course is the second level in a series of core Linux/Unix courses, and introduces system administration using the GNU/Linux operating system. Topics include custom installation, file system, software, service, and local account management under Linux/Unix. Fundamental system administration principles and basic security concepts are also covered. Prerequisites: COMP 2765

This course is the third level in a series of core Linux/Unix courses, which builds on the fundamentals covered in the previous courses to automate tasks and develop administrative tools using shell scripts. Shells covered include Bourne, Korn, and C shells, with emphasis on the Bourne shell. Topics include structured shell scripts, and an overview of sed, awk, and Perl. Please note: *This course will be offered once each year in the fall term.* Prerequisites: COMP 2770

Agile methods are the future for flexible Information Systems development, Agile is more about individuals and interaction over processes and tools, This hands-on course follows on from COMP 2831 and begins with an in-depth understanding of the goals of Agile, followed by hands-on Scrum implementations. Students implement a full spectrum of the primary agile methods and frameworks including Scrum, Extreme Programming, Lean/Kanban, Dynamic Systems Development Method, and Feature-Driven Development. Working in teams they experience key agile practices including self directed teams, writing of user stories, agile estimating with relative sizing, co-location, metric reporting, and test driven development. Scrum use and implementation follows with students learning how to scale Scrum to large multiple team projects, how to measure progress empirically at both a micro and macro level, and release planning. Students work in groups and participate in a real project consisting of building an actual product from initiation to a team implementation, using Sprint Planning Meetings, daily Scrum Meetings, Sprint Reviews, and Sprint Retrospectives. The class members will experience the roles of Scrum Master, Scrum Product Owner, and "The Scrum Team". Successful participants will be able to function within an agile team environment using the agile methods and practices required to successfully deliver a software product. Prerequisite: COMP 2830 or COMP 2831 or equivalent experience with traditional analysis tools and methods.

This hands-on course continues from COMP 1920 and teaches students how to write reusable classes and object-oriented scripts. The main focus is on advanced database programming techniques (using MySQL as well as other database management systems), session handling, and security issues. Topics include : Open-source PHP libraries (e.g. PEAR) and extensions (e.g. PECL) are used to add complex functionality to sites including encryption, compression, rss feeds, templating, hashing, and multiple file format creation (.doc, .pdf, .rtf, .zip, .xls). Students work together in groups to build scripts and libraries for membership signups and shopping-carts for online database transactions. Participants learn the PHP command line interface (no Web server required),and compare PHP to other scripting languages such as Perl. Prerequisites: COMP 1920

This hands-on course continues from COMP 2613, and prepares students for Java Web Development. It is aimed at experienced Java programmers who want to gain a deeper understanding of programming for Java desktop as well receive an introduction to Java web application development. Students are introduced to Java EE starting with an examination of Servlet API and Servlet life cycle. Topics include: Further examination of JDBC, JavaBean Design, Networking with Sockets, Multithreading, and Security for Encryption. This course together with COMP 2613 helps prepare for the Oracle Certified Professional Java SE Programmer exam. Certification exams are available from third parties, will require more self-study and are not the main goal of this course. Successful participants in this course will be able to design, build and deploy advanced Java desktop applications to industry standards, plus have an overview of Java web applications in order to move on to COMP 4613, Java Web Application Development. Prerequisite: COMP 2613 or ability to write intermediate level Java code.

This hands-on course builds upon COMP 2614 or equivalent knowledge of C# programming. Students who already understand C# gain practical skills using Microsoft Visual Studio 2010 and the .NET Framework 4 to create Enterprise level desktop and N-Tier software applications. There is a focus on Microsoft industry standards using Windows Communication Foundation (WCF) services unified model and other .NET tools to design commercial-level software applications. Topics include: Object serialization, database programming with ADO.NET, multithreading, asynchronous programming techniques, COM Interop, XML.NET document object model, XML.NET query language, XML.NET navigation, reflection, delegates and .NET services fundamentals. Upon successful completion, participants will be able to create commercial N-Tier software applications using the latest .NET technologies. Prerequisites: COMP 2614

This fast track, six-week course follows on from COMP 3821 and is aimed that students who already understand LAN theory, data communication, large scale network design and TCP. Participants focus on a Network Administrators perspective to design and set-up wireless networking systems. Beginning with a study of wireless LAN hardware and software components, the focus is on wireless network planning, WAN Design models, installation and management. Topics include: radio frequency (RF) technologies, spread spectrum technologies, antenna concepts, 802.11x wireless regulations, standards and organizations, 802.11x protocols and devices, network architecture and implementation. Wireless LAN security, WEP, WPA, WPA2, TKIP, FSK implementation and troubleshooting will be discussed. Successful participants will be prepared to write the Certified Wireless Network Administration (CWNA), PW0-104 Exam which is part of the CWNP, Certified Wireless Network Professional series. These exams are available through third parties for additional fees. Students learn use tools to perform site surveys and implement a wireless network design in the lab. Prerequisites: COMP 3821

Shell scripting is a powerful way to automate and control systems, programs and files. This hands-on course is aimed at two main audiences; 1) Administrators of Networks and Databases will learn how to create and use scripts to automate, monitor tasks and perform routine maintenance. 2) Software developers will learn to use scripts for building, updating and testing programs with objects, for more rapid application development. Scripts may be applied to solve problems and reduce effort, in all aspects of Windows computing. Topics cover the three major shell scripting technologies in Windows: Command Line, Windows Script Host, and Windows Powershell, with primary emphasis on the latter. Participants will learn how to reduce effort through automation by creating both scheduled and interactive scripts. Prerequisites: COMP 1409 or COMP 1630 or COMP 3700

This hands-on course is built on top of COMP 2870 and is focused on advanced concepts used to develop and maintain ASP.NET applications. Students who already understand ASP.NET and C#.NET will gain a deeper understanding of the latest .NET 4.0 technologies for web development through labs and exercises. Topics include: jQuery, Entity Framework, Web Parts, Custom Server Controls, Personalization, Caching, ASP.NET AJAX, WCF, Silverlight, RIA Services and ASP.NET MVC. By the end of this course, successful participants will be able to create and deploy scalable web applications and also be prepared to move on to COMP 3971 Silverlight Development with ASP.NET. Prerequisites: COMP 2870

This hands-on course has replaced COMP 3906 and COMP 4906, it is designed for experienced object oriented programmers who already know how to write significant code in an OO language. Student will be required to provide any one of their own iPhone/iPad/iTouch devices, plus an Intel based MacBook with OS X Snow Leopard or higher. BCIT students who do not currently have an Intel based MacBook are entitled to obtain one from Apple Canada at a student discount.      This updated course includes more topics, greater depth plus an online component using D2L. The main focus of this course is to learn to design and develop apps for the iOS platform to Apple standards. Students will design an application and write code on their own Intel based Mac and run their application on their own iOS device (iPhone/iPad/iPod Touch).   Starting with an intensive overview of the Objective-c language, followed by an introduction to the iOS platform, special attention will be placed on the user interface components of current popular iPhone and iPad applications and games.   Topics include; Objective-c, Xcode 4, Cocoa Touch API, memory management, user input and gesture recognition, data persistence including Core Data, SQLite, NSUserDefaults and Plists. Working with audio, video and the accelerometer will also be discussed.   The BCIT School of Computing is a member of the Apple iPhone Developer University program, providing access to Apple resources for the development and testing of iOS applications.   In addition to working on a number of simple in class applications during the course, students will also be required to work in teams and participate in the online component. Upon completion, successful participants will be able to specify, design and build a significant iOS application for iPhone or iPad. Prerequisite: COMP 2613 or COMP 2614 or COMP 2617 or equivalent ability to write executable code in an Object Oriented Programming such as Java, C#, or C++.

This hands-on course continues on from COMP 3613, Advanced Java Development and has replaced COMP 3641. Students continue their examination of Java EE in regard to Web Application and Servlet APIs with a focus on web application design, organization and deployment and prepares them to move on to COMP 4655, Java EE Application Development. Topics include: JSP scripting and actions, JSP Expression Language, JavaServer Page Standard Tag Library (JSTL), and JavaServer Faces (JSF) development. Special attention is paid to JSP and JSF development.     This course  together with COMP 3613 helps prepare for the Oracle Certified Professional Java SE Web Component Developer exam. Certification exams are available from third parties, will require more self-study and are not the main goal of this course. Successful participants in this course will be able to build and deploy Java web applications to industry standards. Prerequisites: COMP 3613

The MySQL database server is the world's most popular open source database product. This high level hands-on course is focused on the current version of MySQL Server and its administration, continuing on from COMP 1630. It is designed for those who already understand relational database design, data modeling, normalization and SQL programming. This course provides an in-depth understanding of designing and implementing configuring the current version of MySQL. It also helps to prepare for some of the MySQL certifications. Topics include: MySQL architecture, storage engines, client programs, DDL and DML for MySQL (CREATE, SELECT, INSERT, UPDATE, JOIN etc), importing/exporting data, replication and optimization. Students learn to write and optimize complex MySQL queries, perform backups and restore databases. Upon successful completion, participants will be able to install, design and create multiple databases and user accounts with permissions on a MySQL Server. Prerequisite: COMP1630 or equivalent knowledge of data modeling, normalization and SQL programming.

This updated hands-on course continues on from COMP 1630 and is designed for students who already understand relational database design, and who have a working knowledge of SQL programming. Students use Oracle 11g Enterprise Edition database software to create and administer a new database, then configure the database to support an application. Topics include; creating users, defining storage structures and setting up security. Participants will also learn how to protect the database by designing a backup and recovery strategy, as well as how to monitor the database. Participants are required to purchase mandatory Oracle University course materials in e-Book format. The official Oracle materials are $300 in addition to the course tuition. After registration, call 604-434-1610 to arrange purchase of the specific Oracle e-Book course material prior to the first class. Please note that the e-Book is personalized for each student by Oracle and this cost is not refundable. BCIT is a member of the Oracle Workforce Development Program and this course fulfils the Instructor-Lead-Training requirement for the Oracle 11g certification. Prerequisites: COMP 1630

This hands-on course uses Oracle 11g Enterprise Edition database software and follows on from COMP 4670 and is designed only for those who have completed a Level 1 Oracle Administration workshop. Advanced topics include; higher level administration, automating tasks with scheduler, globalization settings and how to backup and recover databases using RMAN. Students learn how to diagnose Oracle using log and trace files, recover committed transactions, manage resources, database storage and memory. Participants are required to purchase mandatory Oracle University course materials in e-Book format. The official Oracle materials are $300 in addition to the course tuition. After registration, call 604-434-1610 to arrange purchase of the specific Oracle e-Book course material prior to the first class. Please note that the e-Book is personalized for each student by Oracle and this cost is not refundable. BCIT is a member of the Oracle Workforce Development Program and this course fulfils the Instructor-Lead-Training requirement for the Oracle 11g certification. COMP 4671 will be offered once a year in the fall term. Prerequisites: COMP 4670

This course follows on from COMP 1630. Students who already understand relational database design and SQL are provided with an in-depth understanding of designing, creating, deploying, optimizing and maintaining enterprise SQL Server 2008 databases. This hand-on course is SQL Server 2008 specific, so those who have taken MS SQL 2000/2005 will also benefit and be able to better plan migration to SQL Server 2008. Topics include: architecture, installing and configuring SQL Server, physical database design, creation, maintenance, security, and high availability solutions. This Administration course also prepares for the follow-on course, COMP 4678, MS SQL Server 2008 Development. These two courses together will help you prepare for the new Microsoft certification exams (MCTS SQL Server 2008 and MCITP DBA) and obtain a thorough understanding of MS SQL from both a developer and administrator perspective. Successful participants in this course will learn to install and configure SQL Server 2008, to plan and set policies for system access, end-users, back-ups, disaster recovery, to troubleshoot and to manage database security. Prerequisites: COMP 1630

Students who already understand MS SQL Server 2008 Server Administration are provided with a detailed understanding of the design and implementation of enterprise scale SQL Server 2008 databases. Topics in this hands-on course is SQL Server 2008 specific, and include: architecture, new SQL 2008 components, T-SQL review, new T-SQL constructs for SQL Server 2008, programmable objects, and security for developer. There is an overview of BI tools (SQL Server Reporting Services, SQL Server Integration Services) and comparisons between different editions of SQL Server. This development course is built on top of the prior Administration course, COMP 4677. These two courses together will help you prepare for the new Microsoft certification exams (MCTS SQL Server 2008 and MCITP DBA) and obtain a thorough understanding of MS SQL from both a developer and administrator perspective. This course also prepares for the follow-on course, COMP 4679 -MS SQL Server Reporting tools. Successful participants in this course will learn to create procedural code in T-SQL and .NET, to create views, stored procedures and triggers, to develop XML-based applications with integrated managed code, to use SQL Server 2008 GeoSpatial data types, and to use performance tuning procedures. Prerequisites: COMP 4677

This course follows on from COMP 1630. Students who already understand relational database design and SQL are provided with an in-depth understanding of authoring, managing and delivering traditional and interactive reports using MS SQL Server 2008 Reporting Services (SSRS). This hands-on course is MS SQL Server 2008 specific, topics include: Install, configure and manage SSRS, authorize reports using Business Intelligence Development Studio (BIDS), and apply multiple levels of report security. Students receive an overview of MS SQL Server 2008 Analysis and Integration Services, which provides some Business Intelligence (BI) architecture concepts and some preparation towards the MCTS 70-445 and 70-446 exams. Successful participants will learn to extract the data from its multiple collections of applications and data sources and how to utilize the report builder for user "Ad hoc" reporting. Prerequisites: COMP 1630 or equivalent knowledge of relational database design, data modelling and SQL programming.

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. Prerequisites: COMP 4677

This course follows on from COMP 1630 and is designed to provide an introduction to SQL Server Analysis Services (SSAS) for online analytical processing (OLAP) and data mining for business intelligence applications. Microsoft SQL Server 2008 and MS Excel 2010 are used to design, create and manage multidimensional structures containing data from other sources such as a relational database. Focusing on the role of SSAS, students who already understand database design and SQL programming will be shown how to create and maintain an Analysis Services database. They will learn to use data mining techniques to extract data from collections of multiple data sources and applications. Topics include: OLAP with multidimensional cubes, data warehousing, accessing different data sources. Data mining, interacting with cube data via MS Excel and retrieve analysis service data using Multidimensional Expressions (MDX) queries. Aggregation, conversion, Drillthrough and Writeback are also discussed. This course also helps to prepare for the SSAS component of the Microsoft Certified Technology Specialist (MCTS): Business Intelligence Developer, which is available through third parties for additional fees. Upon completion of this course, successful participants will be able to use SSAS to deploy an Analysis Services database with multiple levels of security. They will gain a better understanding of Business Intelligence using Microsoft tools. Prerequisites: COMP 1630 and (COMP 2362 or COMP 2364)

This intensive 2 day workshop follows on from COMP 3705 and allows students to explore Intrusion Detection Systems (IDS) and to detect attacks that get past firewalls. The focus of this hands-on workshop is to configure and install an IDS, set-up email alerts and design useful policies to deal with false-positives and ongoing maintenance. Topics will also include heuristic, anomaly, signature and misuse detection systems and how to choose the best solutions. Students will examine various intrusions and discuss how to analyze logs for patterns. The goal of this workshop is to provide network administrators with a higher level understanding of the most common IDS tools and methodolgies available for network security. Prerequisites: COMP 3705

This intensive 2 day workshop follows on from COMP 3705 and allows students to explore Virtual Private Networks (VPN) as another measure to provide network security. The focus of this hands-on workshop is to design, implement and maintain a VPN. Topics will also include L2TP, PPTP and IPSec. Students will examine various tunneling protocols, authentication and encryption mechanisms. There is a group project setting up site-to site as well as remote access, providing network administrators with a functional understanding of the role of VPNs in network security. Prerequisites: COMP 3705