Web Applications Certificate

Overview
The Web Applications certificate series provides students with information about the fundamentals of web-based applications; using the C# language to build web applications on the ASP.Net platform; interfacing with data in a disconnected environment; and communicating over the web with other automated services. Students will learn the differences between installed executable applications and web-based applications and how to account for the stateless nature of programming on the web. The course uses the Microsoft Visual Studio 2008 development tool and a Microsoft SQL Server database platform. The concepts of page lifecycle, HTML-based forms, client and server-side rendering, session management, data binding and cross-domain communication will be covered.

The Web Applications course series provides a classroom environment where the student will learn through task-oriented lectures and hands-on labs.

Introduction to Web Applications
This course helps participants understand the essential concepts of web-based applications. The student will learn the essentials of request-response communication, client versus server side code, and HTML forms and inputs. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Intermediate Web Applications
This course builds on the Introduction course material and includes server-side controls, page templates, and re-usable controls. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Advanced Web Applications
This course helps participants understand the advanced concepts of session management and database connectivity and binding. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Interfacing with Databases from the Web
This course focuses on the real world need to push and pull data from a database on a remote server. Topics will include executing queries against relational tables, presenting the results in a usable way on the page, and inserting and updating changes to the data made by the user. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Project in C#
A comprehensive project will be presented allowing the student to utilize the skills acquired in the Web Applications classes. This comprehensive project will include objectives required to comprehend the concepts of web-based programming and apply them to create a functional application. Success in this project qualifies the student for certification as a Web Applications Developer.

Register for a class

 

Visual Basic Developer Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Microsoft Visual Basic™ Language certificate series introduces students to the basics of Visual Studio and how to build VB Windows applications. They learn about declaring variables, using IF statements, looping, trapping exceptions and to declare and control cursors. As well, the student will learn how to create windows console applications. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of Visual Basic.

Introduction to Visual Basic
This course helps participants understand the essential concepts of using the Visual Basic programming language. The student will learn the essentials of using Variables, IF statements, Looping and various functions. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Intermediate Visual Basic
This course helps participants understand the intermediate concepts of using Visual Basic. The student will learn the essentials of working with data manipulation statements and iterative controls including IF and LOOP statements. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Advanced Visual Basic
This course helps participants understand the advanced concepts of using Visual Basic. The student will learn the essentials of working with Cursor Management, Error Handlers, and Advanced Variable Constructs. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Project in Visual Basic
A comprehensive project will be presented allowing the student to utilize the skills acquired in the Visual Basic Language classes. This comprehensive project will include the objectives required to create and comprehend the language statements addressed in the Visual Basic classes. Success in this project qualifies the student for certification as a Visual Basic Developer.

 

Register for a class

Desktop Publishing Certificate

Recommended Pre-requisites

  • Strong computer skills including knowledge of file storage, folder creation.
  • A strong interest in desktop publishing, and a desire to create professional looking publications.

Overview
This program is designed for employees who have a need to create flyers, brochures, newsletters and other publications for both desktop and commercial printing.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below.
  2. A final project during which the participant will demonstrate knowledge of Desktop Publishing.

Adobe Photoshop: Level 1
Adobe Photoshop is a professional image editing software application that can be used by experts and novices alike. In this course participants will learn the basics of selecting and modifying images, and creating and manipulating layers and other effects. Participants will also learn how to resize images, and prepare images for use in print and screen applications.

Adobe Photoshop: Level 2
Adobe Photoshop is a professional image editing software application that can be used by experts and novices alike. In this course participants will learn methods of using layers to accomplish various tasks, including retouching images and color adjustment, as well as some special effects. If you have some experience with Photoshop but want to go a little beyond the basics, this class is for you. You will benefit the most from this class if your goal is to learn more advanced ways of improving and adjusting your digital images.

Introduction to Adobe InDesign
Adobe InDesign is a professional page layout software application that can be used by experts and novices alike. In this course participants will learn the InDesign user interface, basic page layout concepts, typesetting, and how to format and manipulate objects and graphics in InDesign. Participants will also learn how to prepare publications for use in print and on screen.

Publishing Project
The Publishing Project is a comprehensive project designed to allow participants to utilize the skills acquired in the Desktop Publishing Certificate classes. Those attending this course will be required to create a publication using Adobe InDesign. Success in this project qualifies the participant for the Publishing Certificate.

 

Register for a class

Transact SQL Development Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Transact SQL certificate series teaches students fundamental relational database design as well as the Transact SQL, the programming language of Microsoft SQL Server. Students will learn to analyze data requirements and then, working within the Microsoft SQL Server Management Studio, build databases, tables and other SQL Server objects to support those requirements. Once database objects are created, students will use Transact SQL to mine data, add, edit and delete data and use programming objects such as stored procedures and triggers to build business logic into the database design. Upon completion of the series of classes, students will have skills necessary to use SQL Server as the back-end database to develop client-server applications using the front-end programming tool of their choice.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of Transact SQL.

Relational Database Modeling
This course is designed to assist participants in developing a systematic approach to developing a relational database. The student will learn how to define user requirements, develop an entity-relationship diagram and map a logical database model to a physical database design. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain hands-on practical experience. This course will conclude with a hands-on modeling workshop. This workshop provides the opportunity to model a real world database application. All materials for the class are provided. This course is intended for individuals who currently work with databases such as Access, Oracle or Microsoft SQL Server OR who anticipate working with them in the future. Individuals who are interested in database design.

Introduction to Transact SQL
This course is designed to introduce participants to the SELECT statement using Transact SQL and Microsoft SQL Server 2005. Transact-SQL is the language used by the SQL Server Database Engine, to create and manage database objects, and to insert, retrieve, modify, and delete data. Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI). Participants will use the Query Editor to create and execute SELECT statements from single and multiple tables.

Intermediate Transact SQL
This course is a continuation of the Introduction to Transact SQL course. The following SQL statements will be covered in detail: CREATE DATABASE, CREATE TABLE, INSERT, SELECT INTO, UPDATE, DELETE, ALTER TABLE, CREATE VIEW. Other topics include data integrity, types of constraints, defining constraints using SQL and creating and using views.

Advanced Transact SQL
This course is a continuation of the Intermediate to Transact SQL course. The following SQL statements and concepts will be covered in detail: Built-in functions, user defined programming objects, set based queries. Other topics include: indexes.

Project in Modeling and SQL
This course is a comprehensive exercise that incorporates all topics covered from Data Modeling through Advanced Transact SQL. Students are given a series of related objectives that require utilization of their skills and knowledge of Transact SQL to complete. During the course of the project, students will: create a database, create tables, insert, update and delete data, create views, write numerous queries, create views, rite several user defined functions, stored procedures and triggers. After completing all of the objectives, students take an online exam that tests their knowledge of concepts presented in the series of SQL courses.

 

Register for a class