All You Need To Know About SQL in Six Hours with Dave Prescott

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 27 - Holiday Inn, Ft. Washington, PA

The course fee is $295 for non-user group members and $250 for user group members.



Name: ___________________________________________________________

Company:________________________________________________________

Address:_________________________________________________________

City: _________________________________ State: _____ Zip: __________

Office Phone: ____________________________

Fax:___________________________

Email address: _____________________________________________________________

Please indicate August 27th when replying .
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 mailto:kbsoni@....