MidAtlantic Midrange's Continuing Education Seminars presents

All You Need To Know About SQL in Six Hours
With Dave Prescott
August 27 - Holiday Inn, Ft. Washington, PA


SQL has become the industry standard for moving data between platforms in a
network centric computing environment, and working with data in a relational
database. In today's IT environment of mixed hardware and software platforms
you have to know SQL to survive. This six hour seminar will serve as an
excellent introduction to SQL on the IBM i, System i, and the iSeries for those
people who may not be familiar with it, or it will be an excellent review for
those who need a refresher course.

After attending this seminar, you will have an understanding of SQL basic
concepts and theory, and will be able to create and execute simple SQL
statements using SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP. You will
understand the four groups of SQL statements and how they are used, the various
SQL interfaces and what they are used for, and how to embed and compile SQL
statements in a high level language program like RPG or Cobol. You will also
understand how to use SQL in place of DDS and the native interface to create and
manage database objects.

The morning part of this seminar will be spent building a firm SQL foundation.
It will start with a discussion of SQL basic theory and terminology, and
progress to SQL statement format and structure and the more frequently used SQL
statements: SELECT, INSERT, UPDATE, DELETE, CREATE, and
DROP. It will show you how to use SQL functions such as MIN, MAX, AVG,
SUM, COUNT, AS, and Subselect to query and analyze data.

After covering these basics, the seminar will move on to some intermediate level
topics. First it will look at the SQL software support that is available in
Version 5 and Version 6 of OS/400 and i5/OS so you can understand which part is
included with OS/400 and which part is a separate licensed product. Next it
will show you the groups of SQL statements used to query and work with data, to
define and manage data base objects, and used for miscellaneous functions. The
morning will end with a discussion of the various SQL interfaces available on
the IBM i, System i, and the iSeries.


The afternoon part of this seminar will take you on a detailed exploration of
some more advanced SQL topics that include: Interactive SQL, the SQL Statement
Processor (RUNSQLSTM command), the SQL Script Center in iSeries Navigator,
Embedding SQL in a High Level Language program (RPG, COBOL, C), and Dynamic SQL.
The seminar will conclude with a detailed discussion of how you can use SQL, in
place of DDS and the native interface, to create and manage your database
objects.

Dave Prescott has been an AS/400 specialist since 1987 and was an IBM Rochester
Lab Consultant and participant in the AS/400 National Technical Advocate
Program. His special interests include iSeries and AS/400 performance tuning and
capacity planning, system operations, and system management. Since retiring
from IBM, Dave, co-owner of Systems Management Associates, Inc., has provided
system management and performance expertise in a large installation with
multiple iSeries and AS/400s.

These seminars start at 8:30 AM and ends at 5:00 PM and will be held on:

August 13 - College Park - Holiday Inn at US 1 and The Beltway

August 20 - At EDPS (Electronic Data Processing Services), 3901 West Broad
Street Richmond, VA 23230

August 27 - Holiday Inn, Ft. Washington, PA

The course fee is $295 for non-user group members and $250 for user group
members. This fee offering is a special arrangement between Washington Area
Midrange Users Group and MidAtlantic Midrange. Members of other iSeries/AS400
User groups may also apply under the user group rate.



Name: ___________________________________________________________

Company:________________________________________________________

Address:_________________________________________________________

City: _________________________________ State: _____ Zip: __________

Office Phone: ____________________________

Fax:___________________________

Email address: _____________________________________________________________

Please circle the date of the session you plan on attending. Please mail
completed form with check to: MidAtlantic Midrange, Conference Services, 12023
Blackberry Terrace., North Potomac, MD 20878. For any further questions or
reservations, contact K.B. Soni at 301-590-7121 or email kbsoni@....