DB2 SQL Workshop – CE121GCR

image_pdfCourse Outline PDF

Enrol   Details


Course Code: CE121G Brand: HDM – Db2 Category: Analytics Skill Level: Basic Duration: 16H Modality:CR      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 the SQL Data Manipulation Language (DML).

  Prerequisites


You should have:

_x000D_
_x000D_

    _x000D_

  • Basic computer literacy
  • _x000D_

  • Basic editing skills
  • _x000D_

_x000D_
_x000D_

Database skills are not required.

  Short Summary


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…  Overview


This course provides an introduction to the SQL language.

_x000D_
_x000D_

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.

  Topic


  • 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

  Objectives


    _x000D_

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

  • Code inner joins and non-correlated subqueries
  • _x000D_

  • Use SQL arithmetic operations
  • _x000D_

  • Use scalar and column functions
  • _x000D_

  • Use UNION and UNION ALL
  • _x000D_

  • INSERT, UPDATE and DELETE rows
  • _x000D_

  • Code simple CREATE TABLE and CREATE VIEW statements
  • _x000D_

Tags :
Call Now +27 12 023 1959