MidAtlantic Midrange is proud to offer the next in our continuing education seminars, bringing you the best education and educators available in the iSeries world, and to do so at User Group Rates.

A Full Day of SQL for the iSeries
With IBM's Linda Swan

This one-day seminar explores the issues regarding the development and deployment of the latest in iSeries SQL. We start with a quick review of the basics and then hit the ground running.

Our agenda for the day will run like:

Introduction to SQL on iSeries. SQL is IBM's relational database language that can be used for query and for data definition, manipulation and retrieval. It is a simple, yet extremely powerful tool. In this session we will learn: The basic concepts of SQL, usage for data retrieval and database management, usage in application programs and finally use of interactive SQL.

SQL Performance Basics for the iSeries. If you are thinking of using or have used SQL on the iSeries, then you need to understand how the iSeries database engine handles SQL requests. This session covers performance concepts that apply to any SQL interface (embedded SQL in applications, JDBC, ODBC).

SQL Advanced Functionality Sampler. Come and hear an overview of the functionality contained within the iSeries database. We'll highlight the state-of-the-art, advanced database functions like referential integrity, triggers, stored procedures and predictive query governor. These enhancements make the iSeries relational database one of the best in the industry.

SQL Stored Procedures. Stored Procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedure language that is comparable with stored procedure languages of other DB Servers such as Oracle and SQL Server. By the end of this sessions you should know how to: create and invoke an SQL Stored Procedure, understand error handling techniques in SQL Procedures, and how to move an SQL Stored Procedure into production.

And we'll end the day with:

Using DB2 Monitors to Analyze and Improve SQL and Query Performance. Have you ever tried to solve a query or SQL performance problem with someone else's program and not known where to start? One of the tools that can help is the iSeries most overlooked performance monitors, the database performance monitors. The data collected by the integrated DB2 monitors during runtime can be used to identify which database requests are causing the biggest performance issues. In this session we'll go over: Collecting database performance monitor data, Understanding the data that's being collected and how it's organized, How to use the data to identify and fix performance problems.

These are going to be very power packed sessions and we're going to be covering a lot of real estate.

Linda Swan is a senior software engineer at IBM Rochester. She's currently the team leader of the optimizer component of the SQL Query Engine. Linda previously worked in the Database area in the early 90's as team leader of the SLIC journal and commit recovery team. In the number of years between her two assignments with in iSeries Database, Linda worked as a developer on database related projects involving workflow, Domino and XML.

This course starts at 8:30 AM and ends at 5:00 PM and will be held on:

October 3, 2005 at the Richmond Airport Holiday Inn in Richmond, VA.
                                 - and -
October 4, 2005 at the Holiday Inn in College Park on US1 and the Beltway.
                                 - and -
October 6, 2005 at the Holiday Inn in Ft. Washington, PA.

The course fee is $275 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 AS/400 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 by email.