The purpose of this Seminar is to introduce SQL/400 to experienced users, programmers and analysts. The attendees will learn to extract data from existing databases, as well how to create and update databases.

We will cover the following subjects:

SQL Tools
- STRSQL
- Query Manager
- Run SQL Scripts

SQL Statement Syntax
- Selecting which fields to display
- Extracting specific records from the database
- Sorting the data into a specific order
- Performing totals
- Performing sub totals
- Built in Functions
- Date support

Data Manipulation
- Adding records to a database
- Changing records
- Deleting records
- Creating collections
- Creating new tables
- Deleting a table
- Deleting a collection

Other SQL Objects
- Indexes
- Views
- Joining Files
- Report Formats

Advanced SQL topics
- Security
- Commitment control
- Embedding SQL statements in an RPG program
- Stored Procedures
- Connecting from remote systems

Part of COMMON's 2008 Seminar Series, this Seminar will be held in partnership with the Delaware Valley Computer Users Group (DVCUG). It is a great opportunity to learn more about SQL.

Details:
Wednesday, September 17, 2008

West Chester University of PA
Graduate Business Center
1160 McDermott Drive
West Chester, PA 19383

8:30am - 4:00pm
Registration and breakfast at 8:00am

About the Speaker

With 20 years as a programmer and consultant, Kevin has a wide range of experiences to share. He has been with DMC Consulting for over 10 years. For the last 7 years he has been the primary instructor for their AS/400 based AS/Credentials training program, and has been speaking at COMMON for several years. Recently, Kevin took on the challenge of being a Subject Matter Expert for COMMON, and has authored the book SQL for eServer i5 and iSeries.

Click here to register online for this Seminar

Click here to download a PDF registration form.