
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 6 at 8 am Central- ClosedAugust 1 at 8 am Central- Closed- October 17 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 6 at 2 pm Central- ClosedAugust 1 at 2 pm Central- Closed- October 17 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 7 at 8 am Central- ClosedAugust 2 at 8 am Central- Closed- October 18 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 7 at 2 pm Central- ClosedAugust 2 at 2 pm Central- Closed- October 18 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:
June8 at 8 am Central- ClosedAugust 3 at 8 am Central- Closed- October 19 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 8 at 2 pm Central- ClosedAugust 3 at 2 pm Central- Closed- October 19 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 9 at 8 am Central- ClosedAugust 4 at 8 am Central- Closed- October 20 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 9 at 2 pm Central- ClosedAugust 4 at 2 pm Central- Closed- October 20 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 10 at 8 am Central- ClosedAugust 5 at 8 am Central- Closed- October 21 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 10 at 2 pm Central- ClosedAugust 5 at 2 pm Central- Closed- October 21 at 2 pm Central