EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
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
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
10/02/2018: Background The Development Team found itself having legacy modules developed in Ruby script. These modules would rapidly render dynamically changing...
06/02/2018: Originating from Facebook, React is a component based front-end library that allows you to build applications out of a tree of small, testable,...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
27/02/2018: Mariella has put together this short briefing on the bookmarks functionality in Power BI... "I love it!" she says.. Bookmarks has been available...
27/02/2018: Our world is changing; this is hardly anything new. New startups emerge consistently, almost on a daily basis, each claiming to have the latest...
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"