Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This course provides the necessary knowledge to effectively develop application programs in the DB2 for OS/390 UDB environment.


 
Course Outline
 This hands-on course covers all relevant topics from introductory relational concepts to a discussion of the SQL language to the review of the DB2 facilities necessary for application development. Hands-on exercises ensure an effective learning experience.
The course is intended for database administrators, systems analysts, and programmers who participate in the development of DB2 for OS/390 applications.
Objective
  • Gain an appreciation for the major characteristics of the relational model and the components of DB2.
  • Become familiar with DB2 objects.
  • Gain a good understanding of the SQL language.
  • Learn to code basic Data Definition Language (DDL) commands.
  • Learn to effectively code Data Manipulation Language (DML) for both interactive and programmed environments.
  • Learn how to prepare and test a program containing SQL.
  • Gain an understanding of how DB2 controls concurrency and manages referential integrity.
  • Learn DB2"s security and authorization components and Data Control Language (DCL).
  • Understand the basic access paths to DB2 data and to be able to use the EXPLAIN facility.
  • Become familiar with the DB2 Catalog and the major DB2 Utilities.

Prerequisites & Certificates
Pre-Requisites

No previous database experience is necessary, however, some familiarity with the OS/390 environment, basic TSO/ISPF skills, and a general understanding of application programming are assumed.

Certificates offered


Cancellation Policy
Up to the 11th business day prior to class, a registration may be cancelled or rescheduled without charge. Thereafter the full course fee will be invoiced whether it's a cancelled or rescheduled. In which case a reschedule credit, valid for 1 year, will be issued. Substitutions may be made at any time prior to the start of the course.
Map & Reviews
IB-Learning
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 515 times.