Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

SQL Workshop (WBT)

IBM Course Code: 1E121G

GK# 720273 Vendor# 1E121G

Course Overview

TOP

This course provides an introduction to the SQL language. This course is appropriate for those working in all DB2 environments, but particularly for, z/OS, Linux, UNIX, and Windows.

What You'll Learn

TOP
  • Code SQL statements to retrieve data from a DB2 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

Outline

TOP
Viewing outline for:

Self-Paced 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

Who Should Attend

TOP

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).

Course Delivery

This course is available in the following formats:

Self-Paced

On-demand content enables you to train on your own schedule.



Request this course in a different delivery format.
Enroll