Accessing the IBM i Database Using SQL

Course

In London

Price on request

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

Accessing the IBM i Database Using SQL Training CourseSQL 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 IBM i high-level languages as an alternate means to access the database.This course is designed to teach IBM i programmers and highly skilled IBM i users how to access the DB2 database using SQL. You will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.

Facilities

Location

Start date

London
See map
Arrow Ecs Training, 56433

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • Database training
  • Database
  • Access

Course programme

Training Course Content

Welcome and Administration

  • Unit 1. SQL Concepts
    • Introducing SQL
  • Unit 2. Extracting Data Using SELECT
    • The SELECT Statement
    • Using System i Navigator
    • Using 5250 STRSQL
  • Unit 3. Functions
    • Column Functions
    • Scalar Functions
    • CASE and CAST
  • Unit 4. JOIN and UNION
    • Using JOIN
    • UNION
  • Unit 5. SubSELECTs
    • Using SubSELECTs / Subqueries
  • Unit 6. Query Tools
    • Using Query Manager
  • Unit 7. Database Maintenance
    • SQL Data Types
    • SQL Data Definition and Manipulation
    • Data Integrity
    • SQL SYS Objects
    • Creating SQL Objects on the System i

Additional information

Expenses

The cost of this course is £995 + VAT.

Accessing the IBM i Database Using SQL

Price on request