Home About Courses Schedule Services Webinars Contact Search

Advanced SQL for Db2

SEE SCHEDULE

Duration: 3 Days

Method: Instructor Led, Hands-on Workshops

Price: $1800.00

Course Code: DB1041



View Related Video

Audience

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to interact with data in Db2 databases.

Description

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepared to master Structured Query Language (SQL) on the Db2 platform in this fast paced and hands-on course. We begin with an in-depth discussion of joins and move quickly to more complex operations involving set processing, grouping, subqueries, table expressions, recursion and more. Sometimes there are 3,4,5,6 different ways to write an SQL query to get the same logical results. Come find out why this is so important to know. Each topic is reinforced with hands-on workshops.Notes: The SQL covered in this course will work across the Db2 family of products. The topics covered in this course are also covered in Themis course SQ1010: Cross Platform SQL – Dealing with Complex Queries.

Prerequisites

DB1000 or equivalent experience

Topics

  1. Complex Joins
    • Inner Joins
    • LEFT and RIGHT Outer Joins
    • Full Outer Joins
    • “Anti” Joins
    • Self Joins
  2. Multiple Query Blocks
    • Non-correlated Subqueries
    • Correlated Subqueries
    • Scalar Fullselects
  3. Table Expressions and Views
    • Views
    • Nested Table Expressions
    • Common Table Expressions
  4. Set Operations
    • UNION / UNION ALL
    • INTERSECT / INTERSECT ALL
    • EXCEPT / EXCEPT ALL
  5. Advanced Grouping
    • GROUP BY Clause
    • HAVING Clause
    • Grouping Sets (ROLLUP & CUBE)
    • Aggregation Partitioning
  6. Solving Complex Problems with SQL
    • Relational Difference
    • Quota Queries
    • Relational Division
    • Recursion
    • Complex CASE Statements
    • Table Pivoting
  7. Managing Transactions and Units of Work
    • Data Modification Statements
    • COMMIT, ROLLBACK and SAVEPOINT
    • When to COMMIT?
    • Checkpoint and Restart Considerations
    • Constraint Violations
  8. Temporary Data
    • Global Temporary Tables
    • Materialized Query Tables