CE121 IBM DB2 SQL Workshop

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.

CE121 IBM DB2 SQL Workshop

Skip to Available Dates

Learning Objectives

Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses

  • Code inner joins and non-correlated subqueries
  • Use SQL arithmetic operations
  • Use scalar and column functions
  • Use UNION and UNION ALL
  • INSERT, UPDATE and DELETE rows
  • Code simple CREATE TABLE and CREATE VIEW statements

     

    Course Details

    Course Outline

    1 - 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
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    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

    CE121 IBM DB2 SQL Workshop

    $1,550
    Course Length : 2 Days
     

    1. Choose a Date | 2. Click Enroll Now

    Need Help Picking the Right Course? Give us a call! 808-670-1466