Advanced SQL Coding and Performance

Harriette Matthews

Advanced SQL Coding and Performance
Open your eyes to the power of SQL, and achieve maximum performance.


877-TRAIN-ME (877-872-4663)

http://www.techknowledge.com/



Taking DB2's SQL features to the limit

Advanced SQL Coding and Performance
<http://www.techknowledge.com/courses/coursedetails.asp?pid=&sid=&browse=c&c
id=EWORKSERVER$EWORKSERV$00012860>
2 days in Columbia Maryland, 8/30-8/31
Cost: $1145 (GSA $960)

The SQL language is becoming more feature rich with every update to the ANSI
standards and subsequent releases of DB2. Not only that, but the non-OS/390
features are slowly creeping into OS/390 DB2.

High performance SQL requires much more than an understanding of the syntax.
New techniques must be learned to write the solutions for the business
information in as few SQL statements as possible.

In this course, you will see examples of how SQL can solve very difficult
business problems, and why this type of SQL never gets written. Other
examples demonstrate problems you may need to solve and offer solutions to
problems you haven t even encountered yet. Presented are advanced examples
of joins, table expressions, CASE expressions, table functions, SQL
recursive processing, and many other features of the UDB family.


Submit this document for approval, or forward by email for easy interactive
access to our website.

You may then enroll in this class from http://www.techknowledge.com/, or
call our Enrollment Center for assistance.


877-TRAIN-ME (877-872-4663)




You may request removal from our mailing list at any time by sending an
email to [login to unmask email]

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Pittsburgh list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Pittsburgh.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 - Pittsburgh List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm