Home > Vendors > ibm > ce121g

Share

CE121G - IBM DB2 SQL Workshop

This course provides an introduction to the SQL language.

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.

Duration: 2.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

Content

  • 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

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:

  • Basic computer literacy
  • Basic editing skills

Database skills are not required.

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

IBM Popular Courses

1o276g

"IBM OpenPages: Create Standard Reports-Part 5" is a tutorial or instructional module that is likely part of a series on using the IBM OpenPages software. In th

6a302g

"IBM Safer Payments Hands-On Technical Primer Training (V6.3)" is an immersive and practical learning program designed to equip participants with the essential

6a322g

"IBM Safer Payments Hands-On SysOps Training (v6.3)" is a specialized and practical training program offered by IBM. This training focuses on educating System O
Enquire Now
L6PttP
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤