Becoming a Design Ninja, Step One: Selecting, Organizing, and Painting in Adobe Illustrator

Product(s): Adobe Illustrator.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Wednesday, September 2, 2009 3:00PM (EDT) US 

Event Overview:
True Illustrator mastery comes from the ability to quickly select and manipulate any detail in your artwork. This Webinar will equip you for this task with a focus on the direct selection tool, anchor points, and the pasting and grouping of objects. You’ll learn how to use drawing aids such as the ruler, guides, and smart guides. Drawing tools including the paintbrush, pencil, smooth, and eraser tools are explored along. The lesson culminates with tips on how to organize your work in layers and output your illustration in a useful format.

*In-Depth Selection Techniques
*Anchor Points
*Pasting
*Grouping Objects
*Rulers and Guides
*Drawing Tools

Click here to register. Fee: $89.00

Logos and Photos and Fliers, Oh My! An Introduction to the Adobe Creative Suite

Product(s): Adobe Creative Suite
Audience(s): Business Professional.
Duration: 30 Minutes
Start Date: Wednesday, September 2, 10:00AM (EDT) US 

Event Overview:
When you begin the task of designing your own marketing materials, you may think that Photoshop is the tool for you. Others may and claim its InDesign or Illustrator. The reality is that each of these applications plays a definite and unique role in the design process. This webinar will uncover the benefits of each application and which to use when, and why. In the process we will also cover some basic principles of graphic design.

* Explanation of the Creative Suite Application
* Definition of Raster vs. Vector Images
* Outline of Graphic Design Workflow

Click here to register. Fee: FREE

Discovering the Secrets to Mastering Table of Contents and Other Crucial Word Tools for Long Documents (Word 2007)

Product(s): Microsoft Word 2007
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Tuesday, August 25, 2009 3:00 PM (EDT) US 

Event Overview:
Nothing is worse than being handed a long, confusing document with poor referencing, or worse, inaccurate referencing. The Table of Contents tool is a huge time-saver and a necessary tool for long documents. Along with foot notes and cross-references, these functions make up a nice bundle of features that will make navigating long documents a snap, and might even help you in the creation process.

Some of the things you will learn:

* Introduction to styles
* Create a Table of Contents
* Use Table of Contents as a navigation tool within Word
* Update fields
* Create footnotes, endnotes and cross-references
* Convert note types

Click here to register. Fee: $79.00

KnowledgeWave is pleased to announce another confirmed and “guaranteed to run” instructor-led training course: MS2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
KnowledgeWave is Vermont’s largest Microsoft Gold Learning Solutions Partner which means that our instructors are certified and our classrooms are state-of-the-art.

Special Promotion Alert! Register for this class you get a fully-licensed copy of Microsoft SQL Server 2008 Standard Edition with one client access license (CAL).

See below for a complete course outline and call 800.831.8449 to reserve your spot today – Hurry, seating is limited!

Date(s): September 9-11, 2009
Time: 9AM – 5PM (EST) U.S.
Duration: 3 days
Location: 30 Community Drive, Suite 5 South Burlington VT 05403
Format: Instructor-led, Classroom training
To Register: Call 800.831.8449 or Click here to register.  

About this Course:
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Intended Audience:
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Course Outline

Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
The student will be introduced to how client/server architecture works, and examine the various database and business tasks that can be performed by using the components of SQL Server 2008. The student will also be introduced to SQL Server database concepts such as relational databases, normalization, and database objects. In addition, the student will learn how to use T-SQL to query databases and generate reports.
Lessons

* Overview of SQL Server 2008
* Overview of SQL Server Databases
* Overview and Syntax Elements of T-SQL
* Working with T-SQL Scripts
* Using T-SQL Querying Tools

Lab : Using SQL Server Management Studio and SQLCMD

* Exploring the Components and Executing Queries in SQL Server Management Studio
* Starting and Using SQLCMD
* Generating a Report from a SQL Server Database Using Microsoft Office Excel

After completing this module, students will be able to:

* Describe the architecture and components of SQL Server 2008.
* Describe the structure of a SQL Server database.
* Explain the basics of the SQL language.
* Describe the syntax elements of T-SQL.
* Explain how to manage T-SQL scripts.
* Use T-SQL querying tools to query SQL Server 2008 databases.

Module 2: Querying and Filtering Data
The students will be introduced to the basic Transact-SQL (T-SQL) statements that are used for writing queries, filtering data, and formatting result sets.
Lessons

* Using the SELECT Statement
* Filtering Data
* Working with NULL Values
* Formatting Result Sets
* Performance Considerations for Writing Queries

Lab : Querying and Filtering Data

* Retrieving Data by Using the SELECT Statement
* Filtering Data by Using Different Search Conditions
* Using Functions to Work with NULL Values
* Formatting Result Sets

After completing this module, students will be able to:

* Retrieve data by using the SELECT statement.
* Filter data by using different search conditions.
* Explain how to work with NULL values.
* Format result sets.
* Describe the performance considerations that affect data retrieval.

Module 3: Grouping and Summarizing Data
The students will learn to group and summarize data when generating reports in Microsoft SQL Server 2008 by using aggregate functions and the COMPUTE clause.
Lessons

* Summarizing Data by Using Aggregate Functions
* Summarizing Grouped Data
* Ranking Grouped Data
* Creating Crosstab Queries

Lab : Grouping and Summarizing Data

* Summarizing Data by Using Aggregate Functions
* Summarizing Grouped Data
* Ranking Grouped Data
* Creating Crosstab Queries

After completing this module, students will be able to:

* Summarize data by using aggregate functions.
* Summarize grouped data by using the GROUP BY and COMPUTE clauses.
* Rank grouped data.
* Create cross-tabulation queries by using the PIVOT and UNPIVOT clauses.

Module 4: Joining Data from Multiple Tables
The students will learn to write joins to query multiple tables, as well as limiting and combining result sets.
Lessons

* Querying Multiple Tables by Using Joins
* Applying Joins for Typical Reporting Needs
* Combining and Limiting Result Set

Lab : Joining Data from Multiple Tables

* Querying Multiple Tables by Using Joins
* Applying Joins for Typical Reporting Needs
* Combining and Limiting Result Sets

After completing this module, students will be able to:

* Query multiple tables by using joins.
* Apply joins for typical reporting needs.
* Combine and limit result sets.

Module 5: Working with Subqueries
The students will be introduced to basic and correlated subqueries and how these compare with joins and temporary tables. The students will also be introduced to using common table expressions in queries.
Lessons

* Writing Basic Subqueries
* Writing Correlated Subqueries
* Comparing Subqueries with Joins and Temporary Tables
* Using Common Table Expressions

Lab : Working with Subqueries

* Writing Basic Subqueries
* Writing Correlated Subqueries
* Comparing Subqueries with Joins and Temporary Tables
* Using Common Table Expressions

After completing this module, students will be able to:

* Write basic subqueries.
* Write correlated subqueries.
* Compare subqueries with joins and temporary tables.
* Use common table expressions in queries.

Module 6: Modifying Data in Tables
The students will be able to modify the data in tables by using the INSERT, DELETE, and UPDATE statements. In addition, students will examine how transactions work in a database, the importance of transaction isolation levels, and how to manage transactions.
Lessons

* Inserting Data into Tables
* Deleting Data from Tables
* Updating Data in Tables
* Overview of Transactions

Lab : Modifying Data in Tables

* Inserting Data into Tables
* Deleting Data from Tables
* Updating Data in Tables
* Working with Transactions

After completing this module, students will be able to:

* Insert data into tables.
* Delete data from tables.
* Update data in tables.
* Describe transactions.

Module 7: Querying Metadata, XML, and Full-Text Indexes
The students will learn to query semi-structured and unstructured data. The students will also learn how SQL Server 2008 handles XML data and will query XML data. The students will also be introduced to full-text indexing in SQL Server 2008.
Lessons

* Querying Metadata
* Overview of XML
* Querying XML Data
* Overview of Full-Text Indexes
* Querying Full-Text Indexes

Lab : Querying Metadata, XML, and Full-Text Indexes

* Querying Metadata
* Querying XML Data
* Creating and Querying Full-Text Indexes

After completing this module, students will be able to:

* Query metadata.
* Describe the functionality of XML.
* Query XML data.
* Describe the functionality of full-text indexes.
* Query full-text indexes.

Module 8: Using Programming Objects for Data Retrieval
The students will be introduced to user-defined functions and executing various kinds of queries by using user-defined functions. The students will be introduced to SQL Server views that encapsulate data and present users with limited and relevant information. In addition, the students will be introduced to SQL Server stored procedures and the functionalities of the various programming objects. The students will learn how to perform distributed queries and how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers.
Lessons

* Overview of Views
* Overview of User-Defined Functions
* Overview of Stored Procedures
* Overview of Triggers
* Writing Distributed Queries

Lab : Using Programming Objects for Data Retrieval

* Creating Views
* Creating User-Defined Functions
* Creating Stored Procedures
* Writing Distributed Queries

After completing this module, students will be able to:

* Encapsulate queries by using views.
* Encapsulate expressions by using user-defined functions.
* Explain how stored procedures encapsulate T-SQL logic.
* Define triggers, types of triggers, create a trigger.
* Write distributed queries.

Module 9: Using Advanced Querying Techniques
The students will be introduced to best practices for querying complex data. The students will also examine how to query complex table structures such as data stored in hierarchies and self-referencing tables. The students will analyze the recommended guidelines for executing queries and how to optimize query performance.
Lessons

* Considerations for Querying Data
* Working with Data Types
* Cursors and Set-Based Queries
* Dynamic SQL
* Maintaining Query Files

Lab : Using Advanced Querying Techniques

* Using Execution Plans
* Converting Data Types
* Implementing a Hierarchy
* Using Cursors and Set-Based Queries

After completing this module, students will be able to:

* Explain the recommendations for querying complex data.
* Query complex table structures.
* Write efficient queries.
* Use various techniques when working with complex queries.
* Maintain query files.

Course: Save Time, Work Less: The Power of Using Macros to Complete Repetitive Tasks in Microsoft Word 2007
Date(s): 8/27/2009
Time: 3:00 PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:
Are you tired of performing the same repetitive steps on document after document? Do you wish Word had an “easy” button? Then macros may be the tool for you. Macros allow users to record a series of actions within Word to be “played back” later. From simple to complex strings, macros help make you a more efficient user. This 60-Minute Webinar will help you save time by automating your tasks.

This workshop is for the advanced Word 2007 user.

Some of the things you will learn:

* How macros work
* How to record macros
* How to edit macros
* Create macros to be used in a single document
* Edit macros
* Delete macros

Click here to register. Fee: $79.00

Taking Your PivotTables and PivotCharts to the Next Level (Excel 2003)

Product(s): Microsoft Excel 2003
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Wednesday, August 26, 2009 11:00 AM (EDT) US

Event Overview:
Discover the advanced features of creating and working with PivotTables and PivotCharts. This course is recommended for those who have attended Make Sense of Your Data with PivotTables and Pivot Charts in Microsoft Excel or have equivalent knowledge. Build PivotTables from external databases, customize PivotTables, work with subtotals, and use advanced PivotCharts features.

Click here to register. Fee: $79.00

KnowledgeWave

Learn the Essentials in 60 Minutes: A Beginners Guide to Using Adobe InDesign

Product(s): Adobe InDesign
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Thursday, August 20, 2009 11:00 AM (EDT) US

Event Overview:
InDesign is a powerful print layout application. In this Webinar we will discuss the many applications for InDesign and learn how it integrates with Photoshop and Illustrator. We will take a comprehensive tour of InDesign’s workspace, learning how key tools work and how to prepare for your first page layout.

Some of the things you will learn:

* Overview of the InDesign Interface
* How to Integrate InDesign with Other Creative Suite Applications
* Place Text in InDesign
* Place Graphics in InDesign
* Explain Package Process

Click Here to Register. Fee: $89

Look at Your Data in a Whole New Way with PivotTables in Microsoft Excel 2007

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Tuesday, August 18, 2009 1:00 PM (EDT) US

Event Overview:
Grab a comfortable seat and we’ll walk you through a one-hour Webinar on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to use PivotTable Wizard? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do.

Click here to register. Fee: $79.00

St. Albans – The US Department of Labor recently announced a $1,000,000 award to Vermont Associates for Training and Development, Inc., a statewide non-profit that provides training and employment services to Vermonters age 55 and over. The Aging Worker Initiative: Strategies for Regional Talent Development is designed to train workers age 55 and older for jobs in high-growth, high-demand industries, and increase the workforce system’s capacity to effectively serve an aging worker population.

            Vermont Associates’ challenge and strategy statement was developed at the Windham Foundation’s Vermont Older Worker Policy Summit: The aging of society and correspondingly of the workforce demand that we develop strategies to re-educate and re-train older workers to enable them to enter, re-enter or remain in the workforce (supply side). Likewise, we need to help employers across all industries understand these shifting demographics and to view them not as a vulnerability but as a competitive advantage, a paradigm shift (demand side).

The project will 1) identify current and develop new employer responses to the aging workforce, focusing on the needs of employers and the opportunities presented by the aging workforce; 2) coordinate existing training resources and create new opportunities for disadvantaged, unemployed, incumbent workers, and retirees to increase their workforce participation; and 3) capacity building activities including concurrence from the Workforce Development Council to develop sustainable mechanisms to coordinate the various federal, state, and private resources available to Vermont businesses and Vermonters 55+. In addition, a minimum of four statewide Mature Worker Resource Centers will be established.

Pat Elmer is the Executive Director of Vermont Associates. “Anyone who is a mature worker, who is looking to retrain or change the work they do, or retirees interested in returning to the workforce, will benefit from the services offered at these Resource Centers”, said Elmer. “They will be able to learn what training resources are available in Vermont, what type of financial aid might be available to finance that training, as well as other services that may help them be successful in re-tooling for a new career.”

Key partners in the Initiative include the Vermont Department of Labor, Department of Disabilities, Aging, and Independent Living, KnowledgeWave Training, Vermont Country Store, the Agency of Commerce and Community Development, Vermont Business Roundtable, AARP, Vermont Information Technology Center and Champlain College, Vermont Association of Adult Technical Education Coordinators, The Windham Foundation, and the Vermont Workforce Development Council.

“The older worker is a key state workforce asset and this project is targeting disadvantaged, unemployed, incumbent, and retired individuals age 55+”, said Governor Jim Douglas in support of this project. “The strategic partnerships and older worker specialized employment services of this project, focusing on high-growth, high demand jobs, would be a great benefit to Vermont’s employers and older workers and would complement the goals of my statewide Workforce, Economic Development, and Aging Initiatives.”

This project builds on Vermont Associates’ experience in operating older worker programs in Vermont for the past 26 years, including the Senior Community Service Employment Program and the Dislocated Older Worker Demonstration Project.

The ability for Vermont to develop, attract, and retain a well-educated and skilled workforce is a key factor in economic growth. Older workers are a valuable, though often underutilized, labor pool that can meet the workforce needs of the Vermont economy.

For information: Deputy Director Greg Saylor @ 802 524-3200 ext 11.