SQL - Introduction
Duration
2 days
What the Course Covers
An introduction to SQL and how to take advantage of it on the
i (System
i , i5, iSeries and AS/400).
This course does not cover embedded SQL, so a programming background is not essential.
How Can You Apply the Skills You Will Learn?
On completion of the course, participants should be able to use SQL to access and manipulate a DB2 database
on the
i (System
i , i5, iSeries and AS/400).
Who Should Attend
System Administrators, Operators, Analysts or Programmers.
Prerequisites
Attendees should have at least a knowledge of the system by attending
An
Introduction to i or have comparitive experience
Agenda
The following topics will be covered
- A recap on Relational Database
- Overview and Terminology
- SQL and the i
- The 5250 (green screen) interface - STRSQL
- The Navigator interface - Run SQL Scripts
- Data Manipulation Language (DML)
- Retrieving Data
- SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
- Special Operators (BETWEEN, IN, LIKE, IS NULL)
- SQL Scalar Functions
- Selecting From Multiple Tables and Views
- Sub Queries.
- Updating Data
- Overview of Data Definition Language (DDL)
- Create SCHEMA, TABLE, VIEW, INDEX
- Drop SCHEMA, TABLE, VIEW, INDEX