Highlights
- Understand the concepts of Relational Tables, Normalisation, Database Design, Primary & Foreign Keys.
- List the main data types available.
- Recognise some DDL and DML statements.
- Describe the main DB2 objects and their relationships.
- Discuss the need for program preparation and the DB2 catalog.
- Discuss authorisation concepts.
- Understand the need for locking and define some of the associated terminology.
- Recognise some utilities and their uses.
- Use SPUFI to edit SQL statements to access tables.
- Code and test some SQL statements to perform simple selection from a single table
- Code and run SQL statements that perform selection from 2 tables
- Code and run SQL using some column and scalar functions including date manipulation.
Course Details
DB2 for z/OS Overview
DB2 Introduction
Relational database
Tables
DB2 database design
Entity relationships
Attributes
Normalisation
Physical database design
Table relationships
Data types
Null values
DB2 interfaces
Major components of DB2
DB2 objects
Tables and Storage
Tablespaces, Tables & Views
Storage Groups & Databases
Tablespaces & Tables
Indexes
Views
Referential Integrity
DB2 catalog
Accessing data
Application programs
Program Preparation
DB2 sub-systems
Statement syntax
SPUFI
Accessing DB2 Interactive
DB2I defaults
SPUFI panel
Using SPUFI
SPUFI defaults
SQL
SQL statements
Retrieving data
SELECT statement syntax
Selection of columns
Selection of rows (WHERE)
Logical expressions
NOT, BETWEEN & IN
LIKE
NULL conditions
Literals & arithmetic expressions
Concatenating columns
Arithmetic expressions in the WHERE clause
CURRENT DATE & TIME
DISTINCT
Sorting (ORDER BY)
Table names
Synonyms
Built in functions
SQL column functions
Expressions in column functions
COUNT
GROUP BY
HAVING
SQL scalar functions
SUBSTR
VALUE
Joining tables
Qualified column names
Cartesian products
Additional topics
EXPLAIN
Authorisation
Commit & Rollback
Concurrency
Locking
Suspension & Timeout
Deadlock
Utilities
RUNSTATS
LOAD
Who should attend
Feedback
4.8 out of 5 average
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
