PROGRAMS
Advanced Computer Programming

ORGANIZATIONS WHO HAVE EMPLOYED OUR ADVANCED PROGRAMMING GRADUATES IN THE PAST

Imperial Oil/Exxon Mobil, OAO Technologies, XWave, Hewlett Pakard, Assomption Life, Assomption Life, Medavie Blue Cross, Brunswick News, School District 16, ACOA, IBM Contact Centre, ICT US Robotics, Smart Force, Spielo, AOL, Whitehill Technologies, Connetik Interactive

Course Content

PART I: DIGITAL GRAPHIC DESIGN

Digital Imaging for Web and Multimedia

Student will learn how to manipulate digital images to suit the needs of the medium using Adobe Photoshop. Techniques learned include adjusting light and dark values, cropping, resizing, adding layers to images. Students will also learn about different resolution and file formats and how to apply them to multimedia, web page design and electronic publishing.

Computer Animation for Web and Multimedia

The students will learn frame-based 2D and 3D animation using computer modeling and animation software programs as the primary tool. This course will emphasize the creation of animated sequences and GIF animation for multimedia applications. Animation concepts such as key-frames, morphs and tweens will be taught.

• Learn Adobe Flash animation techniques for 2-D animation
• Learn how to use 3-D modeling graphics software
• Create animations in 3-D
• Morph and move graphical objects, coordinated in time

PART II: WEB DESIGN AND PROGRAMMING

Internet Development Technologies using HTML and CSS

This course is designed to introduce students to the Internet and its architecture using HTML and Cascading Style Sheets. Students will learn how to create HTML documents using basic HTML tags including lists, images, hyperlinks, tables and forms. The course provides learners with a firm understanding of how CSS works and how they are deployed to format and style web pages. Emphasis is on getting started quickly and on applying the various techniques to layout and format typical web development. Among the topics covered are:

• Develop and publish Web pages using HTML
• Configuring and testing a Web server
• Building, testing and refining a Web site
• Developing Cascading Style Sheets that work with different browsers
• Creating rollover effects
• Building site navigation using different horizontal and vertical menu designs
• Styling tables, links and lists using CSS techniques
• Incorporating background images in page designs
• Optimizing document layout for usability and accessibility
• Positioning and floating page content
• Designing absolute positioning of page elements

Building Web Applications in PHP

This course provides an introduction to the PHP Web scripting language. Students will have basic understanding of the web technology and be able to architect, write, debug, and run complete web applications using PHP and MySQL. Among the topics covered are:

• Generating dynamic Web pages using PHP
• Language structure, data types, application design
• String manipulation and regular expressions
• Input processing and web session management
• Using arrays
• Working with Files and Streams
• Integrating database content to generate dynamic Web pages

Introduction to the Microsoft .NET Framework with ASP.NET and VB.NET

This course provides students with the knowledge and skills needed to develop applications in Microsoft Visual Studio .NET 2005 for the Microsoft .NET platform. The course focuses on user interfaces, program structure, language syntax, and implementation details. After completing this course, students will be able to:

• Create a simple Visual Basic .NET–based application based on the Windows Application template
• Use forms and controls to create a user interface
• Creating a Common Layout by Using Master Pages
• Create and populate ASP.NET Web Forms
• Managing State for a Web Application
• Create and use variables and arrays
• Create and use Sub and Function procedures, including predefined functions Implement decision structures and loops by using conditional expressions
• Validate user input for fields, controls, and forms using the validation controls
• Apply object-oriented programming techniques to create classes, add methods, and add properties
• Resolve syntax, run-time, and logic errors by using the debugger and structured exception handling
• Enhance the user interface by adding menus, status bars, and toolbars.
• Create a simple Visual Basic .NET–based Web Forms application that uses an XML Web Service
• Access and manipulate data in a Microsoft SQL Server™ database by using Microsoft ADO.NET
• Build, package, and deploy an application

PART III: DATABASE DESIGN AND ADMINISTRATION

Data Modeling and Relational Database Design Using SQL Server™ 2000

The goal of this course is to provide an introduction to the environment and functionality of a Database Management System. The students will learn how to develop effective database designs using Entity Relationship Diagrams and normalization techniques. Given a specification for a database modeled on a real-world system, the students will learn how to:

• Describe the basic principles of data modeling
• Define and identify entities, attributes, relationships and keys
• Define, explain and use the concepts of data relationships
• Build a logical data model using advanced concepts including sub-types, super-types and entity aspects
• Describe the theory and application of relational data analysis
• Use relational data analysis (‘normal forms’) to identify data relations and build a data model based upon them
• Create a composite data model from the logical data model and the relational data model
• Validate a data model against defined access and navigation requirements

Querying and Programming Microsoft SQL Server™ 2000

The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000. After completing the course, students will be able to:

• Describe the uses of and ways to execute the Transact-SQL language
• Use querying tools
• Write SELECT queries to retrieve data.
• Group and summarize data by using Transact-SQL
• Join data from multiple tables
• Write queries that retrieve and modify data by using subqueries
• Modify data in tables
• Create, use, and maintain indexes
• Create, use, and maintain data views
• Design, create, and use stored procedures
• Implement user-defined functions
• Create and implement triggers
• Program across multiple servers by using distributed queries, distributed transactions, and partitioned views

Administering Microsoft SQL Server™ 2000

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000. At the end of the course, students will be able to:

• Describe SQL Server architecture
• Plan for a SQL Server installation, and then install an instance of SQL Server
• Manage files and databases, including determining resource requirements
• Create and manage databases and their related components
• Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique
• Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network
• Perform and automate administrative tasks and create custom administrative tools
• Back up databases and implement a backup strategy
• Restore databases
• Monitor and optimize SQL Server performance
• Transfer and migrate data into databases.
• Maintain the high availability of SQL Server

Programming Microsoft SQL Server™ 2005

The goal of this course is to provide students the knowledge and practical skills needed to upgrade their skills from SQL Server™ 2000 and exploit the new features and enhancements of SQL Server™ 2005. At the end of the course, students will be able to:

• Use the new features and enhancements in SQL Server™ 2005
• Describe the new development tools
• Use Transact-SQL enhancements to perform database development tasks, and
• Develop XML-based Solutions using SQL Server™ 2005

PART IV: ADVANCED PROGRAMMING

JAVA - Core Programming

The goal of this course is to provide a complete reference to the Core Java Classes. Hands-on learning is emphasized, with assignments, full programming exercises, and projects. Specific topic coverage includes:

• Introduction to Core Java Programming
• Object Oriented software design, i.e. Classes and Objects
• Input/Output and Serialization
• Collections and a Wealth of Utilities
• Multithreading; Common Elements of Graphical User Interfaces
• Components and Facilities for Rich User Interfaces
• Coding Java to Use Relational Databases

JAVA - Object-Oriented Design and Programming using UML

The Student will learn Object-oriented concepts, analysis and design principles as well as OO analysis and design techniques using the Unified Modeling Language (UML). The student will be familiarized with many essential concepts such as:

• Incremental vs. iterative development
• View-model-persistence segmentation architecture
• Types of object relationship - aggregation, generalization, association multiplicity/cardinality
• Qualified associations responsibility-driven design technique
• Use case and use case model, object interaction diagram, CRC cards
• Encapsulation, inheritance, delegation, polymorphism, etc.
• Java Packages
• UML notation

JAVA – Building J2EE Web Applications

Students will learn to develop and test server-side applications based on the Java 2 Platform using NetBeans software platform products and tools. Develop and test server-side applications that use Servlets and Java Server Pages (JSP) for the control and flow of e-business applications. Develop Servlets, JSP and JavaBeans using NetBeans Integrated Development Environment and test Sun Application Server, and Tomcat. Learn the best practices for building J2EE e-business applications, including the use of the Model-View-Controller (MVC) framework to separate concerns among the JavaBeans, JSP in the application

• Tier-based approach to enterprise software development
• Use Enterprise Java Beans (EJB) to create database independent code
• Apply concept of separation of presentation from processing
• Develop and compare JSP and Servlet technologies for server side processing

Developing Enterprise Web Solutions with ASP.NET 2.0
using Visual Studio.NET 2005

This course will teach Microsoft Visual Basic® programmers and beginning Web developers the fundamentals of Web application site implementation by using Microsoft ASP.NET and Microsoft Visual Basic .NET. This course focuses on using the Microsoft Visual Studio® .NET environment and the Microsoft .NET platform to create an ASP.NET Web application that delivers dynamic content to a Web site. After completing this course, students will be able to:

• Explain the Microsoft .NET Framework and ASP.NET
• Create a component in Visual Basic .NET or C#. Create an ASP.NET Web application project by using Visual Studio .NET
• Add server controls to an ASP.NET Web Form
• Add functionality to server controls that are on an ASP.NET Web Form
• Use the Trace and Debug objects that are provided with Visual Studio .NET
• Use validation controls to validate user input
• Create a user control. Access data by using built in data access tools that are available in Visual Studio .NET
• Use Microsoft ADO.NET to access data in an ASP.NET Web application
• Accomplish complex data access tasks from an ASP.NET Web application
• Access Extensible Markup Language (XML) data and read it into a Dataset
• Call an XML Web service from an ASP.NET Web application and incorporate the returned data into a Web application
• Store application and session data by using a variety of methods
• Configure and deploy an ASP.NET Web application
• Secure an ASP.NET Web application by using a variety of technologies

PART V: PROFESSIONAL DEVELOPMENT / WORK TERM

Self – Directed Studies

This module is used by the student who may want to obtain one-on-one instruction with an instructor. This optional module is completed on Friday mornings during the entire duration of the program. The student does not receive a mark for this module as it is optional.

Work Term

The student that meets all the work term criteria will be placed in a work environment for a four week period.