Know DB2

Db2 SQL Webinar Schedule

All webinars are instructor led

These one hour webinars are provided to our clients as an alterative for those who don't have the time to spend all day in class.

To register for any webinar below, simply call us on our toll free number: 1.866.224.4968

Judy Nall is the scheduled instructor for all the webinars below.

Topic one: SQL BASICS

Outline:

  • SQL Basics
  • Open Data Studio Product
  • - A basic walk through and how it is used in LUW and z/OS
  • - Looking at our Database
  • Beginning SQL
  • - How data is structured - Tables, rows, columns
  • - SELECT structure
  • SELECT, FROM, WHERE
  • - Basic row retrieval
  • Writing and running the exercises

 

Schedule Dates:

  • June 7 at 8 am Central - Closed
  • August 2 at 8 am Central
  • October 18 at 8 am Central

Topic Two: WHERE CLAUSES & FUNCTIONS

Outline:

  • SELECT and using scalar and column functions in Db2
  • Using SQL Functions
  • - SUBSTR
  • - DATE & TIME
  • - COALESCE/VALUE
  • - CONCAT
  • Working with UNION and UNION ALL
  • Writing and running the exercises

 

Schedule Dates:

  • June 7 at 2 pm Central - Closed
  • August 2 at 2 pm Central
  • October 18 at 2 pm Central

Topic Three: DML Statements

Outline:

  • DML Statements
  • - Character, Varchar, Numeric, Null characteristics
  • INSERT
  • -Adding rows to a table and data requirements
  • UPDATE
  • - Updating column values in a table
  • DELETE
  • - Removing rows from a table
  • Understanding the syntax options using these DML statements
  • Checking the Db2 Error Codes and your options
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 8 at 8 am Central - Closed
  • August 3 at 8 am Central
  • October 19 at 8 am Central

Topic Four: JOINS in SQL

Outline:

  • How JOINS work in Db2
  • Coding correlation IDs and working with multiple tables
  • INNER Joins
  • LEFT Joins
  • RIGHT Joins
  • OUTER Joins
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 8 at 2 pm Central - Closed
  • August 3 at 2 pm Central
  • October 19 at 2 pm Central

Topic Five: Sub Query

Outline:

  • Single row Sub Queries
  • Using Built-in Functions MIN, MAX
  • Using GROUP BY and HAVING clauses
  • Multiple row Sub Queries
  • Correlated Sub Queries
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 9 at 8 am Central - Closed
  • August 4 at 8 am Central
  • October 20 at 8 am Central

Topic Six: Nested SQL Queries

Outline:

  • Working with Nested Table Expressions
  • -Definition in the SELECT statement
  • - How the values are built
  • - ORDER OF and ORDER BY clauses
  • Using Nested Table Expressions in JOINS
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 9 at 2 pm Central - Closed
  • August 4 at 2 pm Central
  • October 20 at 2 pm Central

Topic Seven: SQL Queries

Outline:

  •  Common Table Expressions
  • - Temporary result tables
  • - WITH clause
  • RECURSIVE SQL
  • - Structure of clauses in RECURSIVE SQL
  • - Controlling the depth of recursion
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 10 at 8 am Central - Closed
  • August 5 at 8 am Central
  • October 21 at 8 am Central

Topic Eight: SQL - TABLE SPACE Structures in Db2

Outline:

  • DDL - Data Definition Language
  • Storage structures in Db2
  • - Segmented, Partitioned, Universal or LOB table space
  • CREATE TABLESPACE syntax
  • - CREATE syntax review
  • -   Internal structure in Db2
  • Universal Table spaces
  • - Partition by Growth Table Spaces
  • - Partition by Range Table Spaces
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 10 at 2 pm Central - Closed
  • August 5 at 2 pm Central
  • October 21 at 2 pm Central

Topic Nine: SQL - TABLES in Db2

Outline:

  • DDL - Data Definition Language
  • How Tables are designed
  • CREATE TABLE syntax
  • - CREATE TABLE syntax review
  • - IN Clause
  • - Naming conventions
  • - Internal structure of a TABLE in Db2
  • Using the LIKE statement to CREATE a TABLE
  • Data Characteristics and choices
  • Building the CREATE statement
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 11 at 8 am Central - Closed
  • August 6 at 8 am Central
  • October 22 at 8 am Central

Topic Ten: SQL - INDEXES in Db2

Outline:

  •  DDL - Data Definition Language
  • CREATE INDEX syntax
  • - CREATE INDEX syntax review
  • - Internal structure of an index in Db2
  • - How SQL can use these indexes to improve performance
  • - Unique and Non-Unique Index structures
  • - Clustering and Non-Clustering Indexes
  • - Primary and Foreign Key Indexes in Referential Integrity
  • Writing and Running the Exercises

 

Schedule Dates:

  • June 11 at 2 pm Central - Closed
  • August 6 at 2 pm Central
  • October 22 at 2 pm Central