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
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...
31/01/2019: Java is a well-established programming language that has been around since the mid 1990s. It’s used extensively in industry and commerce, and...
11/01/2019: Cloud computing has entered its second decade and is still growing strongly. Gartner, for example, has forecast the global public cloud services...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
0800 028 6400
"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"