On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

DB1000 DB2 SQL for Everyone
 
 
Duration 3 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $1625.00


DESCRIPTION (Return to Top)

Come prepared to master Structured Query Language on the DB2 platform in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. The workshops and examples in this course may be used across the DB2 family of products.

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



AUDIENCE (Return to Top)

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a DB2 relational database.



OBJECTIVES (Return to Top)

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.


TOPICS (Return to Top)
  • Relational Database Concepts
  • Basic Data Manipulation
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification
  • Complex Joins
  • SQL Subqueries
  • Set Operations


PREREQUISITES (Return to Top)

None.