Instructor Led 1 Views Training in Canada

SQL Server 2005 Analysis Services SSAS In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to  more...

SQL Server 2005 Transact SQL T-SQL with Additional Topics In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the  more...

SQL Server 2008 Transact SQL (T-SQL) In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for  more...

SQL Server 2008 for developers In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management  more...

Oracle 10g Administration Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data  more...

Oracle 10g 11g Advanced SQL This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability  more...

Oracle 10g 11g Introduction to SQL This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING  more...

Windows Forms Using C# This five-day course provides a practical, hands-on introduction to GUI development using Windows Forms and C#. The course introduces database programming in Windows, including use of Language Integrated Query (LINQ). The course covers powerful newer Windows Forms features, such as controls, data binding, and ClickOnce deployment for creating smart client applications. It covers interoperability  more...

Windows Forms Using Visual Basic This five-day course provides a practical, hands-on introduction to GUI development using Windows Forms and Visual Basic. The course introduces database programming in Windows, including use of Language Integrated Query (LINQ). The course covers powerful newer Windows Forms features, such as controls, data binding, and ClickOnce deployment for creating smart client applications. It covers  more...

JavaServer Faces This course introduces the JavaServer Faces API for Java Web application development. Proceeding from a foundation of Java, Servlets, and JSP, the course develops the best-practice concepts of MVC architecture and command-object encapsulation that propel the JSF architecture. Students create JSF Web applications by organizing their pages as JSF component trees, and their server-side code as JSF  more...

Sharepoint 2010 for Developers SharePoint 2010 has reached a new level of features for .NET and web development that far exceeds previous versions. This course introduces SharePoint 2010 as a development platform, which includes creating sites, lists and pages. In creating these items youa ™ll be introduced to the many new features that SharePoint 2010 has to offer. You will explore new SharePoint projects, item templates,  more...

Credit Derivatives The credit derivative markets allow participants to take views on an entities credit quality and to insure themselves against counterparty and credit risk. Many structures exist but the most common and widespread is the Credit Default Swap (CDS). This course covers the basics of single name and basket CDS contracts, CDS pricing, ISDA definitions together with examples of real life practical  more...

Microsoft Outlook 2010 Level 1 Microsoft Office Outlook provides an integrated solution for managing e-mail, schedules, tasks, notes, and more. Key enhancements include the new cached mode, automatic grouping of messages, junk e-mail handling, and improved reading views.  more...

Writing Queries Using Microsoft SQL Server 2005 T-SQL - CTE In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL.  more...

Writing Queries Using Microsoft SQL Server In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL.  more...

Microsoft Project Training Seminar Location: City of Mississauga Date: 2007-04-30 List Price: $650 Offered Price: $455.00 Seats Available: 2 Upon completion of the course, participants will be able to accomplish the following: * Understanding the basic operations of the software, working with * Windows, menus, commands, and views. * Creating a new project file and creating, editing and outlining a task list,  more...

Microsoft Project Introduction Location: Ottawa Date: 2007-07-09 List Price: $470 Offered Price: $329.00 Seats Available: 2 Upon completion, participants will be able to create a project, add tasks, durations, resources and costs. They will also be able to create outlines, link and unlink tasks, modify the Project, Resources and Task calendar, view critical paths, review projects using the Baseline, print and format Gantt  more...

Microsoft Project 2003 Level 1 - English Location: Ottawa Date: 2008-01-31 List Price: $695 Offered Price: $485.00 Seats Available: 2 Module 0: Learning Project Basics Module 1: Working With Views Module 2: Working With Calendars Module 3: Working With Tasks Module 4: Outlining Tasks Module 5: Making Adjustments To Tasks Module 6: Working With Resources Module 7: Adjusting Resources Module 8: The Critical Path Module 9:  more...

Microsoft Excel Introduction (French Instruction, French Software) Location: Ottawa Date: 2008-01-24 List Price: $185 Offered Price: $129.00 Seats Available: 2 COURSE OUTLINE - Getting started - Excel basics - Basic editing - Basic formulas - Formatting worksheets - Inserting - Various views - Printing  more...

Microsoft Excel 2003 Level 4 - Bilingual Location: Ottawa Date: 2008-01-29 List Price: $300 Offered Price: $210.00 Seats Available: 1 Module 0: Working with Data Series Module 1: Using Advanced Functions Module 2: Using Scenarios and Goal Seeking Module 3: Using Data Tables Module 4: Using Auditing Tools Module 5: Consolidating Worksheets Module 6: Solving Problems Module 7: Working With Views Module 8: Using Macros  more...

Microsoft Project Training Seminar (2 days) Location: City of Mississauga Date: 2008-01-30 List Price: $650 Offered Price: $454.00 Seats Available: 2 Upon completion of the course, participants will be able to accomplish the following: Understanding the basic operations of the software, working with Windows, menus, commands, and views. Creating a new project file and creating, editing and outlining a task list, as well as  more...

Microsoft Excel Introduction Location: Ottawa Date: 2008-02-13 List Price: $185 Offered Price: $148.00 Seats Available: 1 COURSE OUTLINE GETTING STARTED Starting Excel Excel Window and Views Excel Menus and Toolbars Task Pane Excel Help Excel Intellisense EXCEL BASICS Creating and Saving a Document Opening a Document Using Spell check Using Autocorrect and Autocomplete Closing vs. Exiting BASIC  more...

CATIA V5 Fundamentials Training (5 Days) This course is intended for new CATIA V5 Users. It focuses on the fundamentals training of the program. Upon completion of this course, the student will be able to describe the basic terminology and use the basic features of the CATIA V5 Solutions. The students will be introduced to the CATIA V5 fundamental concepts and interface, will learn the concept of sketch-based features, dress-up features,  more...

Microsoft Word XP 2003 Level 1 Objectives: * Load And Exit The Word 2002 Working Environment * Create, Save, Revise And Print Documents * File Management, Including Manipulation Of Multiple Documents * Change The Document Format To The Desired Presentation * Cutting, Copying And Pasting Text * Preview Documents * Switch Between Different Views *  more...

Microsoft Project Training Seminar (2 days) Upon completion of the course, participants will be able to accomplish the following: * Understanding the basic operations of the software, working with * Windows, menus, commands, and views. * Creating a new project file and creating, editing and outlining a task list, as well as establishing dependencies by linking tasks. * Adding and assigning resources to a project file,  more...

SQL Advanced Location: Winnipeg Date: 2008-05-28 List Price: $159 Offered Price: $127.00 Seats Available: 2 Upon completion of this course, students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT  more...

Microsoft Project Training Seminar - Introduction (2 days) Upon completion, participants will be able to create a project, add tasks, durations, resources and costs. They will also be able to create outlines, link and unlink tasks, modify the Project, Resources and Task calendar, view critical paths, review projects using the Baseline, print and format Gantt charts and create various views using filters and grouping.  more...

Microsoft PowerPoint XP 2003 Level 1 Microsoft Office PowerPoint gives you the tools you need to create great-looking presentations. In addition, this easy-to-use software can improve how you share information and communicate with users across platforms and devices Objectives * Use The Various Toolbars In PowerPoint * Manage Presentation Files * Create Presentations * Use Different Views In PowerPoint *  more...

Creating Dynamic Presentations with PowerPoint This course is designed for students who desire to gain the skills necessary to work with design templates, organizational charts, special effects, web presentations, collaboration functionality, and advanced presentation delivery, including slide formatting, working with tables, images, and objects, charting data, and presentation preparation. Learn the tips and tricks that make this  more...

Microsoft Powerpoint 2007 Level 1 Introduction in English This course will run for two days; from 9:00 am until 4:00 pm, at Montreal Road (CBiT). This course is an introduction to Microsoft Office Powerpoint 2007. There are no prerequisites; however, a working knowledge of the Windows Operating System is recommended. In this two-day course, the topics that will be covered will include: Exploring the MS Powerpoint Interface; Creating a MS Powerpoint  more...

Word Introduction - Level This course provides competency in using toolbars and menus, opening documents, moving through documents, closing documents, and using document views; creating documents and entering text, saving documents and working with document properties; selecting, editing, copying and moving text; inserting date and time fields, using automatic text features; previewing and printing documents, creating and  more...

Microsoft Sharepoint Services 2003 Level 1 Microsoft Sharepoint Services 2003 Level 1 is a course that will help you get started if you are new to the software and require training for it. In this course, the topics discussed will be: getting started; using the Sharepoint team Web site; site access; managing lists; libraries; discussions and surveys; working with views; and much more. It is recommended that you have basic knowledge of  more...

Microsoft Project Advanced This course is designed to cover more advanced features of MS Project for users that have already been working and have a good working idea of Project. Among the topics that will be looked at for this course, Using advanced views, Formatting the Gantt chart, Customizing how Project looks, and Setting Project options will be some of them. With completion of the course, participants will be able to  more...

Front Page Introduction This course teaches the basics to Microsoft Frontpage including: page views; working with web pages; formatting web pages; adding lists; enhancements; creating hyperlinks, adding graphics; creating tables; creating frames; managing and publishing; and much more. All program fees include a manual on CD complete with self study lessons. Upon completion of the each program each participant will  more...

ProEngineer - Introduction to Wildfire 30 This course is an introduction to the Pro/ Engineer course. Upon completion, the student will be able to describe the basic terminology and use the core design features of Pro/ E. The students will be introduced to Pro/ E Wild Fire 3. 0, the latest version of the software from PTC. Fundamental concepts and exploring of the interface will be covered. Also, the concept of sketch-based features,  more...

Excel 2003 Macros VBA Level 1 - computer help This course explores creating, editing, and using Excel Macros and provides a good introduction to the relationship between macros and Visual Basic. This course is classroom style instruction: Instructor-led, hands-on training. Basic Macro Concepts Macros And Sub Procedures Limitations Of Recorded Macros Recording Macros Relative Referencing Macro Options Storing Macros Editing A  more...

Project Intermediate -Level 2 This course provides competency in using templates working with resources more specifically conflicts, views and leveling. Expanding further into tasks with linking, editing and working with variances. Learn how to use and create reports.  more...

Microsoft Office Access 2007 Foundation Getting Started Starting Out What is Microsoft Access? Whata ™s New in Access 2007? Basic Terminology Opening Microsoft Access Interface Overview Closing Microsoft Access Step-By-Step Skill Sharpener Using the Getting Started Window Overview of the Window Navigating Through the Window Creating a  more...

Implementing a Microsoft SQL Server 2005 Database - nexient Who should attend? This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database. Performance Objectives After completing this course, students will be able to: Create databases and database files. Create data types and tables. Use XML-related features in Microsoft SQL Server 2005. Plan,  more...

Microsoft Project Introduction- Compuease Upon completion, participants will be able to create a project, add tasks, durations, resources and costs. They will also be able to create outlines, link and unlink tasks, modify the Project, Resources and Task calendar, view critical paths, review projects using the Baseline, print and format Gantt charts and create various views using filters and grouping.  more...

Excel 2007 Intermediate Level 1- Last Minute Training Topics include: working with multiple sheets, window panes & freezing titles, views & cell comments, multiple files, creating range names, using autocorrect, sorting, autofilter, find & replace, using the list feature, and advanced page setup & printing.  more...

Microsoft Excel 2007 Level 1- Nexient Upon completion participants will be able to accomplish the following: Understand the concepts of word processing, create, save, and open documents; organize columns and rows; calculate values; create formulas; format worksheets; use views and more.  more...

Microsoft Excel 2007 Level 1 - uofa Upon completion participants will be able to accomplish the following: Understand the concepts of word processing, create, save, and open documents; organize columns and rows; calculate values; create formulas; format worksheets; use views and more.  more...

InDesign - Level 1 - UofA Students enrolled in this course will learn the history of InDesign, the interface, different document views, how to identify and use graphic frames, text frames, and unassigned frames. Students will also learn how to import images, use transparency effects, applying character and paragraph styles to automate text formatting, create multi-page documents, and learn to centralize page layouts in  more...

Microsoft Project 2003 Beyond Basics - TPLANIT Project 2003 Beyond Basics presents skills training and assessment for Microsoft Project 2003. This course provides competency in evaluating project schedules; tracking project performance and managing costs; customizing project tables, filters, views and reports; creating and using templates; and managing multiple projects. Customizing your project; formatting the Gantt Chart; Tasks; tracking  more...

Microsoft Office Project Beyond Basics This course provides competency in Customizing Project, Using Advanced Views, Formatting the Gantt Chart, Customizing How Project Looks, Setting Project's Options, Advanced Topics, Tasks, Project Costs, The WBS Code, Importing & Exporting Files & more..  more...

SharePoint Designer 2007 This course will consist of lessons such as: Creating and Modifying Web Pages Working with Lists and Libraries Working with Data Views Working with Data Sources Using Controls in Webs Pages Working with Master Pages  more...