Join our mailing list!






You are here:Home > Additional Hardware and Software Training > DB2 for z/OS Training > DB2 for z/OS - Applications > NWDB1001 DB2 for z/OS Embedded SQL Programming
NWDB1001 DB2 for z/OS Embedded SQL Programming
 
DESCRIPTION

DB2 for z/OS Embedded SQL Programming is a 2 day course targeting the needs of programmers and developers writing applications that access data stored in the DB2 environment.

The presentation is an integrated mixture of lecture and workshop activities that introduce and reinforce the basic techniques and approaches to relational database technology as implemented in DB2. Topics covered include structure and manipulation of DB2 data, operational considerations in both on-line and batch environments; integrity; embedded programming techniques and preparation; and an introduction to performance analysis.

Material comprising the course is consistent with DB2 for z/OS Version 9. The workshop activities follow the classroom material and are designed for both topic reinforcement and practice. Programming topics are supported by workshops in both the on-line and batch environment, this includes precompiling, compiling, linking, and the various options of the DB2 BIND.

This class may be taken in conjunction with the 3-day NWDB1000 DB2 SQL for Everyone class. The combined course is, NWDB1010 DB2 for z/OS SQL & Application Programming.



AUDIENCE

Programmers, application developers and computer analysts who are exposed to, or are required to perform the activities associated with application development and implementation in a DB2 environment.



OBJECTIVES

Upon successful completion of this course, the student will be able to:

  • Describe the overall purpose of, and the approaches to manipulating data in a database management system.
  • List the features of DB2 for z/OS Version 9.
  • Describe the major objects used by DB2 for data manipulation.
  • Translate and code business problems in Structured Query Language.
  • Embed SQL in COBOL programs.
  • Prepare COBOL programs containing embedded SQL statements for execution in the z/OS batch environment.
  • Process multi-row tables with DB2 cursors.
  • State the internal approaches utilized by DB2 for accessing data.


TOPICS
  • Introduction To DB2 and SQL
  • Introduction to Embedded SQL
  • Program Preparation
  • Cursors
  • Performance


PREREQUISITES

Basic programming skills in the COBOL environment and familiarity with the z/OS environment and TSO/ISPF. A basic understanding of SQL.

Sort By:
Page of 1
NWDB1001 DB2 for z/OS Embedded SQL Programming 7/26/2010 Phoenix AZ
Our Price: $950.00

NWDB1001 DB2 for z/OS Embedded SQL Programming 7/26/2010 Virtual
Our Price: $950.00

NWDB1001 DB2 for z/OS Embedded SQL Programming 11/29/2010 San Francisco CA
Our Price: $950.00

NWDB1001 DB2 for z/OS Embedded SQL Programming 11/29/2010 Virtual
Our Price: $950.00

   
 
Nationwide Training Alliance

 About Us
 Become an Affiliate
 Privacy Policy
 Send Us Feedback
 Bookmark Us
Company Info | Advertising| Product Index | Category Index | Help | Terms of Use
Copyright © Nationwide Training Alliance. All Rights Reserved.
Sell Online with Volusion.