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 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
Classroom or Remote
Remote
Receive the latest version of this course by email & subscribe to our Newsletter
CONTACT
+44 (0)20 8446 7555
enquiries@jbinternational.co.uk
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address 1345 High Road, London, N20 9HR
POPULAR
AI & ML training course
React training course
Threat Modelling training course
Python for Data Analysts training course
Power BI training course
Machine Learning training course
Spring & Boot Microservices training course
Terraform training course
Kubernetes training course
C++ training course
Biztalk training course
