IBM Db2 12: SQL Workshop for Experienced Users

Course overview

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

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.

Who should attend

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.

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)

Delivery formats

• • Instructor-led online (virtual classroom)
• • Instructor-led on-site at your premises
• • Self-paced online training
• • Private/closed group delivery for corporate teams

Digital badge

Delegates completing this course are eligible for an IBM digital badge, issued via Credly. View the badge

Related and follow-on courses

• 2LA92G — IBM Db2 12.1: Advanced Data Management and Recovery for Relational DBAs (Advanced)
• B6359G — IBM Cognos Analytics: Author Reports Advanced (v11.2) (Advanced)
• 0A069G — IBM SPSS Modeler Foundations (V18.2) (Basic)
• 0A079G — Introduction to Machine Learning Models Using IBM SPSS Modeler (V18.2) (Basic)