IT Training Online Course: DB2

DB2 has a long history and is considered by many to have been the first database product to use SQL (also first developed by IBM). This course is designed for COBOL programmers who want to use SQL in their programs to access data in DB2 tables.

Product Duration: 12 Months Unlimited Access Price  Add to Cart   DB2 Training This Online Training Course is designed for COBOL programmers who want to implement SQL into programs to access data in DB2 tables. It provides an overview of embedding SQL in a program, including coding requirements and stored procedure functions. An overview of the interactive tools for program development is provided. This Training also examines the use of DB2 to change and manipulate data in DB2 rows and tables. £199.99

DB2 Course Lessons:

DB2: The Programming Environment This course introduces the programming considerations related to embedding SQL statements in a COBOL program. Objectives: Describe when and why SQL is embedded in a COBOL program Identify the tools available and the tasks to perform in the users environment Explain how SQL reads data into and writes from Working-Storage Describe the communication that occurs between COBOL and SQL Explain the purpose of stored procedures and how they operate 2.0 hour(s) DB2: Row and Table Manipulation This course provides an overview of the use of DB2 and how to use it to change and manipulate data in DB2 rows and tables to affect the outcome of COBOL programs. Objectives: Select and retrieve a single row of data Operate Working Storage to receive VARCHAR columns Select and retrieve multiple rows of data Use the FETCH statement to bring multiple rows into the application Create direct table updates Create indirect table updates Locate column values 3.0 hour(s) DB2: Program Development and Efficiency This course provides an overview of the interactive tools available for program development methods to prevent failures and invalid updates. Objectives: Explain program development and preparation, including the use of SPUFI and DCLGEN Discuss error recovery practices and potential errors due to concurrent users Describe various considerations for program performance 3.0 hour(s)

If you just have a question about our DB2 training or any other careers or training course just telephone us on 0871 222 8790 or fill in the simple form below and an advisor will contact you shortly.

What do I get?

Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.

Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn

Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide

Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 8am-8pm to help you out if you get stuck

Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.

Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.