Customer Training Classes
|
IQ Server Tune Up and NGS-IQ Desktop Modules Workshop
Sacramento, CA
May 13-14, 2009
Schedule |
Day One Class Description |
Day Two Class Description |
Class Information |
Register Now
|
 |
Get two days of valuable, customized NGS-IQ training at half the normal price!
NGS has put together two days of fast-paced, yet comprehensive, workshop training to help you gain the advanced and new skills you need to take full advantage of NGS-IQ. The two-day format enables us to cover topics of interest to beginners and the most experienced NGS-IQ users. Please review the complete list of topics below and then give us a call or complete the registration form to reserve your seat.
|
Class Schedule |
Day One: May 13, 2009
IQ Server Query Development Training Class
Agenda |
8:00 - 8:30am
8:30am - 12:00pm
12:00 - 1:00pm
1:00 - 4:00pm |
Registration and complimentary breakfast
Training class, Part 1
Complimentary luncheon
Training class, Part 2 |
Reception: enjoy appetizers and your favorite beverages with NGS staff from 5:00pm to 7:00pm. It's on us! |
Location:
Staybridge Suites,
140 Promenade Circle,
Sacramento, CA
Day Two: May 14, 2009
IQ Client Training Class
Mastering Qport Access and SmartView Workshop
Agenda |
8:30 - 11:30am
|
Qport Access and SmartView Workshop OR
IQ Client Training Class
|
12:00 - 1:00pm |
Box lunch |
1:00 - 4:00pm |
Qport Access and SmartView Workshop OR
IQ Client Training Class |
Locations:
Qport Access and SmartView Workshop: Staybridge Suites, Sacramento, CA
IQ Client Training Class: NGS Corporate Headquarters, Sacramento, CA
|
Day One Class Description |
The IQ Server Query Development training class is an opportunity to fine-tune your product knowledge and skills, learn how to use new functions in the latest release, and expand your day-to-day use of NGS-IQ. The class will be taught lecture-style. We recommend that attendees have a basic knowledge of IQ Server (Interactive Query), since we'll be covering more advanced functions of the product.
Functions and features to be covered include the following:
1. |
Conditional Calculations
- If/Then? If/Then/Else? Buckets? We'll explain the reasons you'd want to use conditions in new fields.
- Learn when and how to use the special conditional fields like PREV, *SKIP and *COUNT.
|
2. |
Running Queries on the Web *NEW
|
3. |
Web Links in Report Breaks *NEW
- In the queries that run in the browser, you can build links into the report breaks that will run other queries for more detail. You can even pass variables you need from the first query.
|
4. |
SQL
- Use "Group By" to quickly make a summary-only query. You'll be able to include description fields you normally miss. You can even sort on summarized amounts!
|
5. |
Date Arithmetic
- Do you know when to use IQDATE vs. DATE COND CALCS vs. REAL DATES?
We'll show you an easy way to decide.
|
6. |
Exit Programs
- Three places to tie in external programs - new fields, before the query starts, or after the query ends.
|
7. |
400 Query API *NEW
- Can’t face rewriting all your old IBM queries? Let IQ run them behind the scenes and handle the output. This process is easier than you think.
|
8. |
Tables
- Why use them, when and where not to use them, and how to attach them.
|
9. |
Designing Queries for SmartView and Excel
- Writing queries for SmartView - learn all the things you don't have to do in the query.
|
10. |
Meta-Data and Pre-Defined Joins
- Have you ever formatted a field in IQ? Then you can use Meta!
|
11. |
Security
-
See an example of a basic database security solution. Understand what IQ SeQure can do to simplify database access and restrict features.
|
|
Day Two Class Description |
IQ Client Training Class: In this hands-on lab led by an NGS-IQ specialist, you'll create queries in a 100% PC environment. You’ll see much more of the options at a glance – no F10 required! You will also learn how to use the new HTML editor to make reports really shine when you run them from a Web browser. See how much faster you can build a query using IQ Client.
Mastering Qport Access and SmartView Workshop: The step-by-step exercises in the Workshop will help you quickly deploy the NGS-IQ desktop modules and streamline your query and reporting process. Taught lecture-style, the Workshop focuses on the features and capabilities of Qport Access and SmartView OLAP, plus Windows’ functions such as creating desktop icons, scheduling IQ queries to run from your desktop, and more. Other lessons include output from IQ Server (IQ Client, Qport Builder) to PDF, HTML, XML, and e-mail distribution. Click here for a detailed description of the exercises that will be covered.
|
Class Information |
The cost to attend this two-day training program is only $450 per person—a tremendous savings compared to the usual cost associated with software training. This fee includes the classes, training materials, breakfast, and lunches. The registration fee is non-refundable; however, it can be transferred to other people in your company. As an added bonus, NGS will let you apply your class fee towards the license fee of any NGS product for 90 days following the training dates!
Hotel Information:
Staybridge Suites, 140 Promenade Circle, Sacramento, CA
The Staybridge Suites Sacramento - Natomas is a recently opened, modern, and affordably priced hotel located just up the street from NGS headquarters. Click here for details and ask for the NGS Corporate Rate if you need to make hotel reservations.
Seating is limited, so reserve your space for this NGS-IQ Tune Up Workshop today!
Registration deadline is April 24, 2009.
We look forward to seeing you!
For more information, please call Jeff Coley at (800) 824-1220, ext. 228
|
|
|
