Name: DB2 Interactive SQL
Course Code: ST901
Duration: 2
Scheduled Dates for ST901
DB2 UDB SQL offers the student a unique opportunity to learn how to code interactive DB2 UDB Structured Query Language (SQL). Typical business processing requirements are analyzed and coded into SQL statements. The SQL statements are tested using an interactive SQL utility such as IBM's SPUFI, QMF, the UDB Command Center, the UDB Command Line Interface, or even MS Query.
Target Audience
This class is for users, power users, application programmers, application analysts, database designers or anyone who needs to code SQL in or outside of an application program or stored procedure.
Key Topics
- DB2 Concepts and Facilities
- The Order Item Database
- Basic SQL Select Operations
- Basic SQL Insert, Update, and Delete Operations
- Column and Scalar Functions
- Subquery, Join, and Union Operations
- Joins Including Inner and Left, Right, and Full Outer Joins
- Views and Nested Table expressions
Required Skills/Experience
- This course is intended for those who need to learn IBM DB2 UDB Structured Query Language (SQL). It can be taught using DB2 for OS/390 and z/OS, DB2 for VM and VSE, DB2 for 95, 98, ME, and NT, DB2 for AIX, or DB2 for other versions of Unix.
Fee: $800.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
