DB2 SQL for Experienced Users

Show more IBM DB2 Training Courses

About this class

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, that is z/OS, OS/390, VM/VSE, iSeries, Linux, UNIX and Windows.

Who will the lesson benefit?

Experienced SQL end users, application programmers, database administrators and user support staff who need more advanced knowledge of SQL.

What prerequisites are required

Before taking this course, you should have experience with coding and executing basic SQL statements.

These skills can be developed by attending CE12, 'SQL Workshop' or equivalent experience.

What delegates will learn

After completing this course, you should be able to:

• Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
• Discuss basic relational database concepts including: databases, tables, indexes and referential integrity
• Create tables, views and indexes
• Use referential integrity, check constraints and triggers
• Use outer join, join tables to themselves
• Use CASE and CAST
• Understand the impact of Summary Tables, Materialized Query Tables and temporary tables
• Use complex subqueries
• Use a greater number of scalar SQL functions
• Use advanced SQL constructs including recursive SQL and table expressions
• Understand User-Defined Distinct Types and User-Defined Functions
• Avoid several of the most common causes for poorly-performing SQL

Contents of this class

• Introduction, SQL review, OLAP functions
• Creating objects (tables, indexes, views, etc.)
• Join
• CASE, CAST, Summary Tables, MQTs, temporary tables
• Subqueries
• Scalar Functions
• Table Expressions and Recursive SQL
• User-Defined Distinct Types and Functions
• Performance Considerations

Please note this course replaces CF13GB

DB2 SQL for Experienced Users / CE130GB (CE130GBGB)

(C) AquinasTraining.co.uk - Contact Us