Accessing the IBM i Database Using SQL
Course
In London
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
Start date
Reviews
Subjects
- SQL
- Database training
- Database
- Access
Course programme
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
Accessing the IBM i Database Using SQL