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:
- February 8 at 8 am Central
- April 5 at 8 am Central
- June 7 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:
- February 8 at 2 pm Central
- April 5 at 2 pm Central
- June 7 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:
- February 9 at 8 am Central
- April 6 at 8 am Central
- June 8 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:
- February 9 at 2 pm Central
- April 6 at 2 pm Central
- June 8 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:
- February 10 at 8 am Central
- April 7 at 8 am Central
- June 9 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:
- February 10 at 2 pm Central
- April 7 at 2 pm Central
- June 9 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:
- February 11 at 8 am Central
- April 8 at 8 am Central
- June 10 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:
- February 11 at 2 pm Central
- April 8 at 2 pm Central
- June 10 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:
- February 12 at 8 am Central
- April 9 at 8 am Central
- June 11 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:
- February 12 at 2 pm Central
- April 9 at 2 pm Central
- June 11 at 2 pm Central
