The AS/400 & IBM i Pocket SQL Guide: QuikCourse: IBM i SQL By Example - Paperback

by Brian W. Kelly (Author)

A Learn By Example Guide for IBM i-based Application Development Finally, there is a Pocket Developer's Guide for IBM i SQL data- base development. Yes, it is in big pocket guide form and it is tutorial in nature. You'll be pleased with all the valuable explanations and examples. You won't want to put down this comprehensive guide to learning IBM i SQL now that you've got your hands on it. This book is over 20 years overdue. In today's IT landscape, most shops support heterogeneous systems with numerous client and server PCs, and even Unix boxes. Ironically, all of these non-IBM i platforms, from the smallest to the largest have one thing in com- mon in the relational database area. They all use SQL as their data language. That's a big change in the database landscape. SQL is now the industry data / query language standard. IBM backs SQL 100%. A quick look at the SQL function list for the latest release gives a good indication that SQL will have an even more important role in the IBM i future. So, today, it makes little sense for an AS/400 and IBM i professional to not be on board by warming up to SQL - at least for functions that return sets of data. This Guide has an example for just about every type of common SQL function you can imag- ine - from creating tables & views to performing simple and complex selections, column and scalar functions, sub-queries, all the way to unions and joins. Author Brian Kelly designed this book to show you how to use SQL by working with rich examples that you'll use over and over again. Additionally, for each example, there is the explanation you need to get a head start on being an SQL guru. This is the first book to hand to your new developers and veterans alike. More importantly, rather than Oracle being the only database taught at your local Community Colleges and Universities, this new up-to-date IBM i SQL Guide is the right size text for a modern database course. Contains end of chapter extras for teaching / learning.

Author Biography

Brian W. Kelly retired as a 30-year IBM Midrange Systems Engineer in 1999. While with IBM, he was also a Certified Instructor and a Mid-Atlantic Area Designated Specialist. 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 89 books with better tha half of them on advanced IT topics. He has also written hundreds of articles with many about current IT topics. These include articles for The Four Hundred, Midrange Computing, Showcase, News/400, AS/400 Systems Management, AS/400 Internet Expert, Computer Business News, Search400, and others. Kelly has also developed and taught a number of college courses and recently retired as a member of the Business / IT faculty at Marywood University in Scranton, Pennsylvania, where he also served as IBM I technical advisor to the IT faculty.