Loading feeds...

DB2 DB200

DB2 UDB Basic SQL Usage

  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
Description: The seminar teaches the basic use of DB2 SQL
Audience: The course is intended for analysts / programmers and database administrators who have previous experience in a RDBMS and / or SQL language and want to get familiar with the features of the DB2 environment
Prerequisites: Familiarity with the basic user environment of Windows XP/2003, desired basic knowledge of RDBMS, desirable basic knowledge of SQL language
Material covered:
  • Commands select, insert, update, delete
  • Functions (Scalar, Group)
  • Subqueries
  • Joins (Inner / Outer)
  • Expressions (Nested Tables, CASE, Common Tables)
  • Recursive SQL
  • Set Operators (UNION/EXCEPT/INTERSECT)
Duration: The duration of this seminar is 2 Days from 9:30 to 14:30