Home About Courses Schedule Services Webinars Contact Search

DB2 SQL for Everyone

SEE SCHEDULE

Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1800.00

Course Code: DB1000



View Related Video

Audience

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a DB2 relational database.

Description

Come prepared to master Structured Query Language on the DB2 platform in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. The workshops and examples in this course may be used across the DB2 family of products. This class may be taken in conjunction with the 2-day DB1001 DB2 for z/OS Embedded SQL Programming class. The combined course is, DB1010 DB2 for z/OS SQL & Application Programming.

Objectives

Upon successful completion of this course, the student will be able to:

  • Describe the overall purpose of, and the approaches to manipulating data in a database management system.
  • Describe the major objects used by DB2 for data manipulation.
  • Translate and code business problems in Structured Query Language.
  • State the internal approaches utilized by DB2 for accessing data.

Prerequisites

None

Topics

  1. Relational Database Concepts
    • The Relational Model
    • Domains
    • Integrity and Relationships
    • Structured Query Language (SQL)
    • Unknown Values (NULL)
    • Basic Datatypes
  2. Basic Data Manipulation
    • SELECT Statement
    • Using SELECT
    • Projecting Columns Onto the Result
    • Basic Predicates
    • Expressions in the SELECT Clause
    • Expressions in the WHERE clause
  3. Intermediate Data Manipulation
    • Compound Conditions
    • Other WHERE Clause Operators
      • IN
      • BETWEEN
      • LIKE
      • IS NULL
    • Using DISTINCT
    • ORDER BY Clause
  4. Built-in Functions
    • Working with Datatypes and Casting
    • Functions Involving NULLs
    • CASE Statements
  5. Built-in Functions
    • Working with Datatypes and Casting
    • Functions Involving NULLs
    • CASE Statements
  6. Aggregation
    • SUM, AVG, MIN, MAX & COUNT Functions
    • Grouping Results with GROUP BY
    • Filtering Groups with HAVING
  7. Joins
    • Inner Equi-Join
    • Join Classification
    • Cartesian Products
    • Inner Joins of More than 2 Tables
  8. Data Modification
    • INSERT
    • UPDATE
    • DELETE
    • COMMIT and ROLLBACK
  9. Complex Joins
    • LEFT / RIGHT / FULL Outer Joins
    • Self-Joins
  10. SQL Subqueries
    • Non Correlated Subqueries
    • Correlated Subqueries
    • Scalar Fullselects
  11. Set Operations
    • Union / Union ALL
    • Intersect / Intersect ALL
    • Except / Except ALL