logo
Home

IBM Db2 12: SQL Workshop for Experienced Users CLA32G

  • CMDBID 100191254
  • Course Code CLA32G
  • Duration 2 Days
Scroll

IBM Course

course overview

download outline

Select Country and City to View dates & book now

Overview

This course covers fundemental and advanced SQL techniques for efficient data management, optimization, and analytics in Db2 12. Participants will learn how to navigate the Db2 system catalog and explore query performance optimization techniques, including indexing strategies, predicate pushdown, and query access plans to improve efficiency.

The course also introduces advanced SQL functions, such as LISTAGG, PERCENTILE_CONT, and PERCENTILE_DISC. Participants will learn how to create and manage database objects and gain expertise in utilizing advanced join techniques such as inner and outer joins, hash joins, lateral joins, and set operators like UNION, INTERSECT, and EXCEPT to merge and analyze data from multiple tables.

The course also covers the use of subqueries and query optimization techniques, including correlated subqueries, EXISTS/NOT EXISTS, and quantified predicates to enhance data retrieval efficiency. 

Through hands-on exercises and real-world scenarios, they will develop the skills necessary to handle large datasets efficiently and implement best practices for high-performance database management.

Audience

This course is ideal for database administrators, SQL developers, and data analysts who have prior experience with SQL and wish to enhance their Db2 v12 expertise. This course is appropriate for customers working in Db2 environments for Linux, UNIX, and Windows.

Skills Gained

After completing this course, learners should be able to:

  • Demonstrate the use of OLAP ranking functions (RANK, DENSE_RANK, ROW_NUMBER) to analyze and order query results
  • Optimize queries with expression-based indexes for computed values
  • Utilize set operators like UNION, EXCEPT, and INTERSECT for advanced data merging
  • Leverage summary tables and MQTs to precompute and store aggregated data
  • Apply EXISTS, NOT EXISTS IN, IN, and NOT IN predicates for conditional data retrieval
  • Perform numeric and mathematical operations, including logarithmic, exponential, and trigonometric calculations
  • Implement recursive SQL to process hierarchical relationships
  • Leverage ARRAY data types to pass structured lists of values within SQL queries and procedures
  • Analyze and optimize SQL execution plans with EXPLAIN and VISUAL EXPLAIN

Prerequisites

Before taking this course, participants should:

  • Be able to discuss basic Relational Database concepts
  • Be able to code basic SQL statements 

OR

  • Have completed the SQL Workshop course (CLA22G or 2LA22G)

Outline

This course covers fundamental and advanced SQL techniques for data management, optimization, and analytics in Db2 12.

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.