top of page

Introduction to DB2 via SQL and Query/400

Summary

SQ101

This course provides an introduction to SQL language applied for DB2 environments and IBM QUERY/400 basic concepts. It provides the basic knowledge to code simple SQL and QUERY/400 statements in order to retrieve data from a DB2 table, to group and order the selected data, to perform simple numerical and alphanumerical operations, to join and merge tables, to modify table data using INSERT, UPDATE and DELETE commands and to create new tables or views.

Audience

This course is being addressed to people needing to write, maintain, or understand SQL queries. Additionally, it might be useful to business analysts, software developers and database administrators who don’t have the knowledge of a Data Manipulation Language (DML).

Prerequisites

There is no need of any special prerequisite, however, a basic familiarization with computer literacy is strongly advised.

Duration

16 hours

Level

Fundamental

Content

-Introduction to DB2 and DMLs and tools

-Simple SQL Queries

-Retrieving Data from Multiple Tables

-Numeric and alphanumeric functions

-Column Functions and Grouping

-UNION and UNION ALL

-Using Subqueries

-Maintaining data

-QUERY/400

Available financial cover by LAEK

bottom of page