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 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
- DDL Vs DDS
- Basic Definitions
- Schema
- Table
- Index
- View
- Constraints
- Generating SQL
- DDL Statements
- Other Definitions
- Triggers
- Functions
- Procedures
- Distinct Types
- Aliases
- Sequences
- Database Navigator
- Visual Explain