pad
padThe iSeries Pocket SQL Guide

by Brian W. Kelly

Book Description

AS/400 and iSeries SQL Concepts, Coding Examples, and Exercises.

A Comprehensive Textbook of Updated Database Information and SQL Examples for the new and experienced AS/400 and iSeries Application Developer.

Contents: Preface
Chapter 1. What Is a Database?
Chapter 2. Distributed Relational Databases with SQL
Chapter 3. What Is SQL
Chapter 4. SQL Concept and Facilities
Chapter 5. Introduction to RUNSQLSTM
Chapter 6. Creating and Understanding Schema & Catalog
Chapter 7. Libraries, Native Objects Used for SQL Development
Chapter 8. Creating and Dropping SQL Objects
Chapter 9. Interactive SQL (ISQL)
Chapter 10. Relational Database Operations
Chapter 11. The Basic Select Statement
Chapter 12. Query Manager
Chapter 13. Embedded SQL in High Level Language Programs
Chapter 14. Advanced SQL, Special Facilities, Select, Join, Sub-Qry, Update, Ins, Del
Chapter 15. AS/400 and iSeries Database Concepts
Chapter 16. Relational Database Theory
Chapter 17. Advanced SQL ? Constraints and Isolation Levels
Chapter 18. Re-engineering PF and LF Objects to SQL DDL
Index


About the Author

Brian Kelly retired as a 30-year IBM Midrange SE in 1999, having cut his eye teeth in 1969 on the System/3 and later with CCP. While with IBM, he was also a Certified Instructor and a Mid-Atlantic Area Designated Specialist. Kelly takes pride in having announced the AS/400 at Marywood University in June, 1988. When IBM began to move its sales and support to Business Partners, he formed Kelly Consulting in 1992 as an IT education and consulting firm. Kelly developed numerous AS/400 professional courses over the years that range from soup to nuts. He has written dozens of books and numerous magazine articles about current IT topics, including articles for The Four Hundred, Midrange Computing, Showcase, News/400, AS/400 Systems Management, AS/400 Internet Expert, and others. Kelly has also developed and taught a number of college courses and is currently an adjunct member of the graduate faculty at Marywood University in Scranton, Pennsylvania, where he also serves as iSeries technical advisor to the IT faculty.


BWK-BOOK-16pad$59.00pad



Guild Companies · 50 Park Terrace East, Suite 8F, New York, NY 10034 · Telephone: (212) 942-5818 · Email: store@itjungle.com