CE121 IBM DB2 SQL Workshop

Price
$1,495.00
Duration
 2 Days
Delivery Methods
 VILT    Private Group

This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

 

Upcoming Class Dates and Times

Coming Soon:
The next class is currently being scheduled. Need it now? No problem.
Contact us and we will help you get the training you need!

Who Should Attend

This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of SQL.

Agenda

1 - Course Outline
  • Introduction
  • Simple SQL Queries
  • Retrieving Data from Multiple Tables
  • Scalar Functions and Arithmetic
  • Column Functions and Grouping
  • UNION and UNION ALL
  • Using Subqueries
  • Maintaining data