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:

  • Better understand relational database concepts like: Table relationships, System catalog tables, Normalization, Optimization, Creating of tables, Column definitions
  • Begin coding the SQL programming language
  • Understand result sets
  • Understand how to maintain data SQL inserts, updates, and deletes
  • Translate and code business problems in Structured Query Language.

Prerequisites

None

Topics

  • I. Relational Database Concepts
    • The Relational Model
    • Domains
    • Integrity and Relationships
    • Structured Query Language (SQL)
    • Unknown Values (NULL)
    • Basic Datatypes
  • II. Basic Data Manipulation
    • SELECT Statement
    • Using SELECT
    • Projecting Columns Onto the Result
    • Basic Predicates
    • Expressions in the SELECT Clause
    • Expressions in the WHERE clause
  • III. Intermediate Data Manipulation
    • Compound Conditions
    • Other WHERE Clause Operators
      • IN
      • BETWEEN
      • LIKE
      • IS NULL
    • Using DISTINCT
    • ORDER BY Clause
  • IV. Built-in Functions
    • Working with Datatypes and Casting
    • Functions Involving NULLs
    • CASE Statements
  • V. Aggregation
    • SUM, AVG, MIN, MAX & COUNT Functions
    • Grouping Results with GROUP BY
    • Filtering Groups with HAVING
  • VI. Joins
    • Inner Equi-Join
    • Join Classification
    • Cartesian Products
    • Inner Joins of More than 2 Tables
  • VII. Data Modification
    • INSERT
    • UPDATE
    • DELETE
    • COMMIT and ROLLBACK
  • VIII. Other Joins
    • LEFT / RIGHT Outer Joins
  • IX. SQL Subqueries
    • Non Correlated Subqueries
    • Correlated Subqueries
    • Scalar Fullselects
  • X. Set Operations
    • Union / Union ALL
    • Intersect / Intersect ALL
    • Except / Except ALL
Copyright ©2020 Themis, Inc. All rights reserved Privacy Policy