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.
DB2 for z/OS Overview
DB2 database design
Physical database design
Major components of DB2
Tables and Storage
Tablespaces, Tables & Views
Storage Groups & Databases
Tablespaces & Tables
Accessing DB2 Interactive
SELECT statement syntax
Selection of columns
Selection of rows (WHERE)
NOT, BETWEEN & IN
Literals & arithmetic expressions
Arithmetic expressions in the WHERE clause
CURRENT DATE & TIME
Sorting (ORDER BY)
Built in functions
SQL column functions
Expressions in column functions
SQL scalar functions
Qualified column names
Commit & Rollback
Suspension & Timeout
See why people choose JBI
31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum...
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
16/11/2018: Data Analytics – the process of analysing data sets – enables organisations to make better-informed decisions. It’s a key focus in many businesses...
07/11/2018: Containerized applications are becoming very popular and it’s easy to understand why. They provide so many benefits to organisations, especially...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"