Heart of America DB2 User Group - Training Invitation

Carl Nelson

Heart of America DB2 User Group - Training Invitation
The Heart of America DB2 User Group would like to extend an
invitation to your DB2 User Group membership to attend training
being offered in Kansas City. Please feel free to contact me if you
have any questions.

TRAINING ANNOUNCEMENT

SHERYL LARSEN, Sheryl M. Larsen,Inc.
IBM Gold Consultant

Training Dates: June 13 , 2006 and June 14 , 2006 Holiday Inn
Overland Park
8787 Reeder Road
Overland Park, KS 66204
Check in: 8:00 am, Training Begins: 8:30 am

Heart of America DB2 User Group Members:

Sheryl Larsen of Sheryl M. Larsen, Inc. will present two days of
training for our group in June. She will offer two classes that are
appropriate for a variety of platforms. This is going to be a great
training opportunity and we wanted to give you a chance to get this
on your calendar. Sheryl will also be presenting on June 12, 2006 at
our quarterly meeting. I hope you can attend.

JUNE 2006 SHERYL LARSEON TRAINING TOPICS

June 13, 2006
Title: UNLEASH THE POWER OF SQL FOR DATA ACCESS
Platform: Z/OS, LINUX, UNIX AND WINDOWS
Description:
Is your goal optimizing IT? SQL education/tuning is a low cost,
immediate return and high ROI solution. Let Sheryl M. Larsen’s
more than 20 years of DB2 experience and award- winning course
material increase your staff’s SQL skills in one day of
education. Her recent performance audits have easily discovered
poorly-coded or -tuned SQL. These avoidable situations can cost 50%
CPU per transaction or 25% of total CPU utilization. Did you know
the number of DB2 SQL clauses has doubled in the past few years?
These new SQL features can quickly reduce your operational costs and
save additional hardware upgrades. This seminar exposes students to
the inherent power of the SQL language, while ensuring they know
when to use what SQL. Leave this class with powerful sample queries
and the confidence to implement them on DB2 for z/OS and DB2 for
Linux, Unix, Window

June 14, 2006
Title: DESIGN PATTERNS: DATA ACCESS STRATEGIES FOR PERFORMANCE
Platform: Z/OS, LINUX, UNIX AND WINDOWS
Outline:
Performance
Performance by Design
Codd's 12 Rules Abridged
E.F. Codd Highlights &Key Issues
What Matters... Data and much more!
Data Warehousing Principles
Know Thy Data! Patterns
Why Patterns?
Patterns for Data Access
Patterns for Data
Data Warehouse Pattern Infrastructure Impact Interrelationship of
Domains and Views Set Notation - INTERSECT Data Types Matter
Layered Views Simple Sets Time and Relations Relations?
UNION ALL View Impact
Origins of Temporal Data and Databases Physical Impacts System
Impacts Typical Schema &Index Design Optimal Schema &Index Design
Exploiting Constraints For Query Optimization Application
Considerations Optimizing The Index Design Materialized Query
Tables

RESERVATIONS

If you would like to make your reservations for the training in June
go to our website hoadb2ug.org and signup. Just select the option in
the upper left hand corner of the homepage that says “June
2006 Registration”. The cost for each day of training is
$250.00.
[login to unmask email] <mailto:[login to unmask email]>

Please make checks payable to:

Heart of America DB2 User Group

Checks can be mailed to:

Dan Tuck
728 Southeast 10th Terrace
Lee’s Summit, MO 64081

See you there,
Roxann Ford, President
Heart Of America DB2 User Group
http://[login to unmask email]
(816)682-4614


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Indiana.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Indiana List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm