Db2 SQL for Everyone

PT24804
Summary
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.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for 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.
Topics
  • Relational Database Concepts
  • Basic Data Manipulation
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification
  • Other Joins
  • SQL Subqueries
  • Set Operations

Related Scheduled Courses