Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 - Database Management Series V11

Advanced DB2 SQL V11

Duration
4 hours

Overview

Description

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 will 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

Course Catalog » Database Curriculum » DB2 - Database Management Series V11
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM