Advanced Db2 SQL V11
Duration
4 hours
Overview
The Advanced Db2 SQL course discusses some of the more advanced SQL code used to manipulate table data. Various methods used for joining tables is presented, along with examples of SQL statements and subqueries used to filter data results.
Audience
Programmers, DBAs, business analysts, and any other personnel that require SQL coding skills to manage Db2 data.
Prerequisites
Completion of the "Db2 SQL Fundamentals" course, or equivalent knowledge.
Objectives
After completing this course, the student should be able to:
- Describe the differences between inner, outer, and full joins
- Describe how Db2 data can be filtered
- Create views from base tables
Course Content
Joining Db2 Tables Together
Inner, Left Outer, Right Outer, and Full Outer Table Joins
COALESCE Function
SQL - DISTINCT, CASE, UNION, and VIEWs
Using the DISTINCT SQL Keyword
Using the SQL CASE Expression
Creating Unions to Combine Data from Multiple Selects
Creating and Using Views to Protect or Aggregate Underlying Table Data
Subqueries and Correlated Subqueries
Subquery Uses
EXISTS Clause
AS Clause
Nesting Subqueries
Correlated Subqueries
Advanced Db2 SQL Mastery Test

This course is part of
the IBM Digital Badge Program
Mainframe Application Programmer
Db2 SQL Coding - Expert
Help Center
Instant Web Chat:
- Chat with tech support or
- have a product question?
Call Us:
770-872-4278
Contact our Learning Consultants or call us at 770-872-4278