OL37G Accessing the IBM i Database Using SQL

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

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.