Welcome to the e-Learning DB2 Universal Database course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning DB2 Universal Database course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning DB2 Universal Database

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning DB2 Universal Database course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning DB2 Universal Database course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning DB2 Universal Database online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

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 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.

About the course

The Programming Environment - Duration 2 Hour(s)

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

Row and Table Manipulation - Duration 3 Hour(s)

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

Program Development and Efficiency- Duration 3 Hour(s)

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

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here