- RPG
 - SQL
 - DB2
 - Java
 - Security
 - Internet
 - WebSphere
   


 -  Top 10 List
 -  New Titles
 -  Products on Sale
 -  Close-out Specials
 -  Current Email Special
 -  College Texts
 -  At Work Series
 -  Step-by-Step Guides
 -  Certification Guides
 


 -  Contact Us
 -  Become a Distributor
 -  Give a Gift Certificate
 -  Privacy Statement
 -  Email Us
 -  Information for
     Distributors and
     Wholesale Accts
 

Browse | New Products | Bestsellers | On Sale | Close Outs | Shipping/Returns | Help
Click to enlargeContains SQL reference material, how-to’s, and tutorials.

The System i5 Pocket SQL Guide

Author: Brian Kelly
Price: $59.00
Availability: SOLD OUT and DISCONTINUED
ISBN: 0-9745852-6-2
SKU: 5930


Book Description:
Finally, there is a Pocket Developer’s Guide for System i5 SQL database 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 iSeries SQL now that you’ve got your hands on it. This book is 15 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-iSeries platforms, from the smallest to the largest have one thing in common in the relational database area. They all use SQL as their data language. That’s a big change in the database landscape. Nobody even tries to deny that SQL is now the industry data / query language standard. IBM backs SQL 100%. A quick look at the SQL function list for V5R4 gives a good indication that SQL will have an even more important role in the iSeries future. IBM has been chipping away at all the little things and the annoying things over the years so that SQl is no longer a lesser function cousin on iSeries to DDS. It certainly is not yet the time to throw in the DDS towel but the new SQL functions are more and more compelling with each release. So, today, it makes little sense for an iSeries 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 imagine – 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 it is a natural for the veteran development team. More importantly, rather than seeing Oracle as the only database taught at your local Community Colleges, Colleges, and Universities, finally there is an up-to-date SQL Guide as the right sized text to use as a teaching vehicle for a modern iSeries database course.

Product Details:
Audience:Programmers
Level:Novice to Intermediate
Subject:SQL, Database
Length:390 pages
Format:Paperback, Perfectbound
Publisher:Let's Go Publish
Publish Date:December 2005




The System i5 Pocket SQL Guide

Author: Brian Kelly
Price: $59.00
Availability: SOLD OUT and DISCONTINUED
ISBN: 0-9745852-6-2
SKU: 5930


SQL Built-In Functions and Stored Procedures
SQL Built-In Functions and Stored Procedures

$49.95
SQL for eServer i5 and iSeries
SQL for eServer i5 and iSeries

$64.95
Free-Format RPG IV
Free-Format RPG IV

$59.95



© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM. All other product names are trademarked or copyrighted by their respective holders.

MC Press Online Privacy Policy