This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows. If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. Terms and Conditions: Ingram Micro – https://www.ingrammicrotraining.com/Terms-of-use.aspx; IBM – http://www.ibm.com/training/terms

Version:

Audience:

This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.

Objectives:

Detail:

Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data. Examples of scalar functions that are addressed in this course:SUBSTRPOSSTRCOALESCE/VALUEDECIMALROUNDDIGITSCHARDATE/TIMETable Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQLUse nested and common table expressionsIdentify the difference between views and table expressionsCode recursive SQLControl the depth of recursion when coding recursive SQLUDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored ProceduresPredict when queries will use indexes to get better performanceIdentify concepts of predicate processingState introductory concepts about index structureState general best practices advice

Pre-Requisites:

You should have experience with coding and executing basic SQL statements. These skills can be developed by attending SQL Workshop (CE120), or having equivalent experience.