NWDB1000 DB2 SQL for Everyone

DB2 SQL for Everyone is a 3 day course targeting the needs of anyone writing SQL to access data stored in the DB2 environment on any platform.

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, integrity and an introduction to performance analysis.

Material comprising the course is consistent with DB2 for Version 9. Topics are supported by workshop activities that follow the classroom material and are designed for both topic reinforcement and practice.

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

Business analysts, end users, programmers and testers who are exposed to, or are required to perform the activities associated with writing SQL in a DB2 environment.

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.
• Describe the major objects used by DB2 for data manipulation.
• Translate and code business problems in Structured Query Language.
• State the internal approaches utilized by DB2 for accessing data.

• Introduction To Relational Databases
• Basic Data Manipulation
• Intermediate Data Manipulation
• Built-in Functions
• Data Modification
• Joins
• Subselect and Union
• Additional Concepts in Data Manipulation

None.