FYI - DB2 SQL & Warehouse Classes - Baltimore Area

Cathy Peck

FYI - DB2 SQL & Warehouse Classes - Baltimore Area


Both Sheryl Larsen & Dave Beulke are going to be in Baltimore teaching 2
DB2 classes on 4/7-8.

Please see below for specifics! Seeya!

----- Forwarded by Cathy L Peck/ISG/CORP/Highmark on 04/04/2005 04:16 PM

[login to unmask email]

04/04/2005 01:54 To
PM [login to unmask email]

Two Great Classes - No Travel Costs

Hi Cathy,

Can you please forward the class announcement people out to your Harrisburg
and Pittsburgh User Group lists? There is still room in the Baltimore
classroom and via the Internet and there seemed to be a number of people
who were interested when I was speaking at the user group meetings.


Two great classes are available with no travel costs or out of the office
These great classes are being offered live over the Internet from the
Baltimore classroom.

Ask any questions via email to the instructor as if you were in room.

Sign up and get great education today!

Unleash the Power of SQL for Data Access
By Sheryl M. Larsen
Internet Class or Baltimore Classroom - April 7
Classroom New York - June 15, 2005

Sheryl M. Larsen is the founder/president of SMLI,, and is
an internationally recognized researcher, consultant and lecturer and is
known for her extensive expertise in SQL. She has over 20 years experience
in DB2, published many articles, several popular DB2 posters, and
co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. She is
frequently asked to keynote DB2 world wide events. She is an IDUG “Hall of
Fame” speaker, President of the Midwest Database Users Group,, and a member of IBM’s DB2 Gold Consultants program.

Data Warehouse Performance
By David Beulke
Internet Class or Baltimore Classroom - April 8
Classroom New York June 14

David Beulke is an internationally recognized DB2 consultant, author and
lecturer. He is known for his extensive expertise in database performance,
data warehouses and internet applications. He is currently a member of the
IBM DB2 Gold Consultant program, co-author of the IBM V8 and V7 z/OS DB2
Certification exams, co-author of the Business Intelligence Certification
exam, past president of the International DB2 Users Group (IDUG), columnist
for DB2 Magazine, and former instructor for The Data Warehouse Institute
(TDWI), He has helped clients with system and application issues on the
mainframe, UNIX and Windows environments and has over 20 years experience
in numerous industries.

He specializes in performance reviews and tuning of large complex
operational and data warehousing systems saving his clients millions of
dollars in hardware upgrade and software licensing costs. He can be
reached at [login to unmask email] for any help, questions or comments.

Unleash the Power of SQL for Data Access
Chapter 1: Things that Impact Query Speed
Infrastructure Impacts
Application Considerations
SQL Clauses
SQL Myths
SQL Coding “Best Practices”
Chapter 2: Join/Outer Join
Left/Right Outer Joins
Over Use of LEFT JOIN
Chapter 3: Table Expression for Left Join
Table Expression Uses
Chapter 4: Subqueries
Calculating Gaps Between Column Values
Audit Checking of Table Summaries
Finding the Needle in the Haystack
Chapter 5: CASE Expressions
The Power of CASE
CASE For Calculations
CASE for All Calculations
Nested CASE for Complex Calculations
CASE for Identifying
Reducing Multiple Passes Against the Data
Chapter 6: CASE in Other Clauses
Embedded Dynamic Syntax
Emulating With CASE
CASE to Change Join Criteria
CASE to Change Sort Sequence
Chapter 7: Global Temporary Tables
Global Temps Syntax – Created & Declared
Practical Uses
Chapter 8: Recursive SQL Syntax
Recursive Processing Code
Emulating Recursive SQL
Chapter 9: UNION Everywhere
Hide Schema Under the Covers
UNION Query – Rewrite
UNIOIN Views Benefits and Limitations
Scrollable Cursors
Chapter 10: Stage 1 Unlike Data Types
2M Statement Length
Limited Fetch
Multi-row FETCH
Multi-row Fetch Storage
Multi-row INSERT
Scalar Fullselect
Dynamic Scrollable Cursors
GROUP BY Expression
DPSI Indexes
Helps Improve Page Density
Backward Index Scans
Chapter 11: DB2 Family Compatibility
DB2 for LUW V8 vs. DB2 for z/OS V8
Chapter 12: Manual Query Tuning
Tuning Technique – X2QBOpt
Seminar Conclusion
Recommended SQL Reading
Appendix: Scrolling Forward and Backward

Data Warehouse Performance
Chapter 1: DW Performance Overview
System Considerations
Capacity Requirements
Physical Characteristics
End-User Considerations
Platforms and Connectivity
Maintenance Aspects
Summary Points & DW Matrix
Chapter 2: Performance Architectures
Architectures Trends
Hardware Architectures
Architecture Considerations
Storage Architectures
Processing Architectures
Chapter 3: Extract Performance Characteristics
Extract Source Performance
Extract Validation
Extract Data Manipulation
Scheduling Performance
Chapter 4: Designs Options for Performance
Scope Design Considerations
Data Warehouse Grain
Design Options
Answer Optimization
Aggregates Design
Chapter 5: Key Designs
General Key Designs
Different Key Types
Index Keys Considerations
Key Designs for Partitioning
Chapter 6: Tablespace Definitions
Tablespace Page Considerations
Tablespace Types
Partitioning Alternatives
Multi-Dimensional Cluster MDC
Chapter 7: UNION ALL and MQTs
LUW Partitioning
Leveraging LUW partitioning
Leveraging MQTs
Chapter 8: Business Intelligence Strategies
Business Intelligence Definition
Properties and Process
Analysis Context
Development & Implement
Business Intelligence Practices

Appendix 1: Multi-Thread Prototype Process
Appendix 2: Partition Keys and Aggregates
Appendix 3: Capacity Planning
Appendix 4: OLAP Tool Evaluation