"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
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
"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
Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...
All 20 points are in our latest Newsletter - Delivered directly to your inbox
Our DB2 training course client feedback shows that delegates will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.
To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.
CONTACT
+44 (0)20 8446 7555
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
