ComCon
Contact
    HOME  |  ABOUT US  |  COMMUNITY  |  DOWNLOAD
 
March 17-19, 2015 in Dallas          


    Services
    Courses
    Workshops
    Sessions
    Articles
    Books

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 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
      • UPDATE, INSERT, DELETE.
  • Overview of Data Definition Language (DDL)
    • Create SCHEMA, TABLE, VIEW, INDEX
    • Drop SCHEMA, TABLE, VIEW, INDEX
Home | About Us | System i Community | Contact
ComCon © 1994 - 2017. This site is hosted on an  i