ComCon
Contact
    HOME  |  ABOUT US  |  COMMUNITY  |  DOWNLOAD
 
October 17-19, 2017 in Minneapolis        


    Services
    Courses
    Workshops
    Sessions
    Articles
    Books

Define Your Database with SQL

Duration

1 day

What the Course Covers

An introduction to defining your database using SQLs Data Definition Language (DDL). As well as examining the required SQL statements the course also introduces the tools provided in Navigator to aid in the definition and maintenance of a database.

How Can You Apply the Skills You Will Learn?

On completion of the course, participants will be aware of what can be defined with DDL as well as how to define it.

Who Should Attend

System Administrators, Analysts or Programmers with responsibilty for defining and/or maintaining a database.

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
  • DDL Vs DDS
  • Basic Definitions
    • Schema
    • Table
    • Index
    • View
    • Constraints
  • Generating SQL
  • DDL Statements
    • CREATE, ALTER and DROP
  • Other Definitions
    • Triggers
    • Functions
    • Procedures
    • Distinct Types
    • Aliases
    • Sequences
  • Database Navigator
  • Visual Explain
Home | About Us | System i Community | Contact
ComCon © 1994 - 2017. This site is hosted on an  i