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.
You should have experience with:
coding and executing basic SQL statements.
These skills can be developed by attending
SQL Workshop (CE120), or equivalent experience.
1. IntroductionIdentify the purpose of the clauses in the SELECT statement
2. Create ObjectsCode statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints
4. CASE, CAST, Summary Tables, and Materialized Query TablesIdentify when CASE expressions can be used
5. Using SubqueriesCode subqueries using the ALL, ANY/SOME, and EXISTS keywords
7. Scalar FunctionsExtend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data
8. Table Expressions and Recursive SQLIdentify reasons for using table expressions and recursive SQL
9. UDTs/UDFs and PerformanceDescribe the concepts behind User-Defined Types, User-Defined Functions and Stored Procedures