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 fill out the registration form and send it to us. We will process the form and send you a confirmation email along with your invoice and all the information needed to ensure your entry. There is nothing you will need to download.

If you encounter any problems give us a call at 866.224.4968 or email us at info@cbi4you.com and we will be glad to assist you.

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:

  • April 23 at 8 am Central - 0423s018Wa - Registration Closed
  • June 11 at 8 am Central - 0611s018Wa

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 23 at 2 pm Central - 0423c028Wp - Registraion Closed
  • June 11 at 2 pm Central - 0611c028Wp

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 24 at 8 am Central - 0424ds038Wa - Registration Closed
  • June 12 at 8 am Central - 0612ds038Wa

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 24 at 2 pm Central - 0424js048Wp - Registration Closed
  • June 12 at 2 pm Central - 0612js048Wp

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 25 at 8 am Central - 0425sq058Wa - Registration Closed
  • June 13 at 8 am Central - 0613sq058Wa

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 25 at 2 pm Central - 0425nq068Wp - Registration Closed
  • June 13 at 2 pm Central - 0613nq068Wp

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 26 at 8 am Central - 0426qu078Wa - Registration Closed
  • June 14 at 8 am Central - 0614qu078Wa

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 26 at 2 pm Central - 0426ts088Wp - Registration Closed
  • June 14 at 2 pm Central - 0614ts088Wp

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 27 at 8 am Central - 0427tb098Wa - Registration Closed
  • June 15 at 8 am Central - 0615tb098Wa

Register (to register, please copy and paste code in the webinar registration form.)

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:

  • April 27 at 2 pm Central - 0427idx108Wp - Registration Closed
  • June 15 at 2 pm Central - 0615idx108Wp

Register (to register, please copy and paste code in the webinar registration form.)