Canada's Leader in Professional Development

855-581-7246 Call us: 1-855-581-7246

IBM i DB2 and SQL School

Currently no upcoming Class Dates

Description

SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as to extract data from a server and pass that data to a Java applet running on a client PC. SQL is frequently used in i system high-level languages as an alternate means to access the database.

This course is designed to teach i programmers and highly skilled i system users how to access the database using SQL. You will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.

This course provides lectures and hands on labs in a face-to-face classroom setting. This course is also offered in a live virtual classroom environment (ILO - Instructor Led Online) with hands-on labs: IBM i DB2 and SQL School - ILO (OV47CE).

Objectives

  • Use data definition language (DDL) to describe tables and views
  • Use UPDATE, INSERT, ALTER, and DELETE to modify SQL tables and maintain a database
  • Use the SELECT statement to extract data from tables and views
  • Code SQL queries that include column and scalar functions
  • Code SQL queries that include inner and outer joins
  • Use SQL Query Manager

Audience

This intermediate course is designed primarily for experienced IBM i programmers. However, very skilled i system users who want to learn how to use the SQL programming language as a means to access the DB2 for i database may also consider attending this class. You will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.

Prerequisites

You should complete:

  • Intro to System i for New Users (OE980)
  • System i Programming Facilities Workshop (OL490CE)

or be able to:

  • Use a Windows-based PC
  • Navigate and use a Windows-based desktop
  • Navigate IBM i menus
  • Use IBM i commands
  • Use PDM/SEU or LPEX Editors
  • List the data types that are supported by the DB2 for i database
  • Explain the function of Data Description Specifications (DDS) in defining files on the i
  • Explain the use of the data types supported by the DB2 for i database

Duration

5 days

Topics

  • Introduction to RDB Management and DB2 for i
  • Introducing Structured Query Language
  • Extracting Data Using SELECT
  • Functions
  • JOIN and UNION
  • SubSELECT
  • Query Manager
  • Database Maintenance
  • Embedding SQL
  • Stored Procedures
  • Database Tools with System i Navigator

Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets