SQL for DB2 [Paperback]

James Cooper & Paul Conte (Author), Katie Tipton (Editor)

Book Description

ISBN-10: 1583041230 | ISBN-13: 978-1583041239 | Publication Date: January 16, 2009 | Edition: 2

This focused, comprehensive textbook provides start-to-finish coverage of SQL for DB2. Whether you re a college student studying SQL for DB2 for the first time or a professional developer who needs to learn SQL for DB2, this book covers all the basics necessary for success. The purpose of any database book is to learn how to develop databases effectively and precisely without the need for a lot of complicated jargon. This book delivers on that promise by focusing on the skill set necessary to develop well-designed DB2 databases. SQL for DB2 covers the core requirements of a traditional database course. Topics are presented in an accessible, easy-to-learn manner with numerous examples and tips. End-of-chapter materials include a chapter summary, list of key terms, and hands-on exercises that put the concepts to work. SQL for DB2 builds on the foundation of its widely acclaimed predecessor, SQL/400 Developer s Guide, to provide an up-to-date introduction to SQL for DB2 for today s students and professionals. All chapters have been refreshed, with improved organization throughout. Examples have been updated, and new material has been added. This new edition includes: *New chapters introducing DB2 and System i Navigator *Expanded coverage of single- and multiple-table queries *Expanded coverage of updating databases with SQL *An expanded discussion of normalization Table of Contents Chapter 1 Introduction to DB2 Chapter 2 Introduction to SQL Chapter 3 Single-Table Queries Chapter 4 Introduction to Data Modeling and Database Design Chapter 5 Logical Data Modeling Chapter 6 Entity Relationship Diagram Chapter 7 Normalization Chapter 8 Physical Database Design Chapter 9 Database Constraints Chapter 10 Multiple Table Queries Chapter 11 Views and Indexes Chapter 12 Updating Tables Chapter 13 Static and Dynamic Embedded Statements Chapter 14 SQL Cursors and Result Sets Chapter 15 The Create SQL Program Command Chapter 16 Using SQL in RPG Programs Chapter 17 Triggers Chapter 18 Additional SQL Topics Chapter 19 Database Security and Grant and Revoke Statements

Editorial Reviews

Review

A comprehensive, indispensable resource for students, programmers, and database administrators who need to learn about the AS/400 database. -- Bernadette Cinkoske, Assistant Professor, Ivy Tech State College

A practical database design and SQL programming textbook specifically for AS/400 application developers. -- Frank G. Soltis, IBM AS/400 Chief Scientist and Prof. Computer Engineering, Univ. of Minnesota

Both newcomers to the AS/400 and experienced AS/400 programmers will find SQL/400 Developer's Guide an excellent resource. -- Sharon L. Hoffman, Senior Analyst, TechReflections

This book is where you should start learning SQL on the AS/400. -- Kent Milligan, DB2 & BI Solutions, AS/400 Partner World for Developers --This text refers to an alternate Paperback edition.

From the Author

Structured Query Language/400 is IBM’s strategic language for defining and manipulating DB2 UDB for AS/400 databases. IBM has recently stated that the proprietary Data Description Specifications and built-in RPG and COBOL I/O extensions are not being enhanced to support new database features. That means if you plan to take full advantage of the AS/400 integrated database, you need to know SQL. And, if you plan to use Java, you need to know SQL because JDBC (Java Database Connectivity) uses SQL to access the AS/400 database. Finally, if you plan to keep your application programming skills current, you need to know SQL because it’s the database language used on all major platforms. This book provides a comprehensive explanation of SQL/400 to students and practicing programmers. Once you master the topics covered in SQL/400 Developer’s Guide, you’ll be able to design and create professional level databases for real applications. This book also provides developers wi! th extensive advice on database design, as well as programming. We cover SQL data definition language (DDL) and data manipulation (DML) in detail. But we go beyond that to explain essential areas such as security, transaction integrity (commitment control), object and row locking, stored procedures, and trigger programs. The book includes numerous examples, tables, appendices, and detailed technical explanations so in most cases, you won’t need any AS/400 manual to create, manage, and use UDB/400 tables and other objects. This edition is based on Version 4 Release 5 of UDB/400, RPG IV, and ILE COBOL/400. This is an ideal book for programmers coming from other database platforms, such as Oracle, Microsoft’s SQL Server 2000, or other versions of DB2 UDB (e.g., on IBM mainframes). If that’s your situation, you should be able to blast through most of the chapters and get a very rapid start with UDB/400. --This text refers to an alternate Paperback edition.

See all Editorial Reviews

Product Details

• Paperback: 400 pages
• Publisher: 29th Street Press; 2 edition (January 16, 2009)
• Language: English
• ISBN-10: 1583041230
• ISBN-13: 978-1583041239
• Product Dimensions: 9.9 x 8.3 x 0.8 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (19 customer reviews)
• Amazon Best Sellers Rank: #393,632 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

5.0 out of 5 stars Best book to learn SQL/400, February 1, 2001

By 

Terry W. Smith (Aumsville, Oregon United States) - See all my reviews

This review is from: SQL/400 Developer's Guide (Vol 2) (Paperback)

If I were teaching (or taking) a class on SQL/400, or just wanting to learn how to develop AS/400 database applications, this is _the_ book that I would want to use. The information needed to develop AS/400 SQL applications is available from other sources, but contained in hundreds of technical manuals, magazine articles, news group postings, and code examples (just to name a few sources). The authors have used their considerable knowledge and experiences to shorten the learning process for the reader by pulling together that information into a single place. I am especially impressed with the organization of material into manageable topics, the easy to read writing style, and numerous tips and techniques presented. I found reading this book more like reading a good novel and wanting to see what happens in the next chapter rather than reading a textbook. I have to admit however I live with this stuff every day. Having been an AS/400 database administrator for the past 10 years I can appreciate the amount of knowledge, experience and effort required to write a book of this kind. The only downside to this book that I found is that I would have liked to see more information about developing applications using JDBC, interfacing with Windows applications using ADO and ODBC, and serving AS/400 information via Web pages. I find an increasing part of my workload to be answering questions about these topics. A good majority of those questions however don't deal with language specific access mechanisms but rather from a lack of understanding about AS/400 specific features and database fundamentals, topics which are well covered in this book. After reading this book I do have one additional problem also. Now I need to buy a stack of these books to hand out to the numerous developers who cross my desk on a daily basis.

12 of 13 people found the following review helpful:

5.0 out of 5 stars Impressive technical depth, November 22, 2000

By 

"g-s" (Ft. Lauderdale, FL) - See all my reviews

This review is from: SQL/400 Developer's Guide (Vol 2) (Paperback)

I'm an AS/400 programmer with over ten years experience with RPG, DDS, and DB2/400. I've been working with SQL/400 for a little over a year. I wish I'd had this book when I started learning SQL! It has very thorough introductions to all the essential DDL and DML statements. Although I'm somewhat beyond the "basics" level now, I've also found lots of help with more advanced issues.

The explanation of transaction isolation levels and record locking is better than I've found anywhere. Also, the complex rules for "system" vs. "SQL" naming are finally comprehensible. The authors seem to know SQL/400 very well, judging from the numerous "nitty-gritty" technical fine points that are provided in footnotes.

This is really the kind of book that an AS/400 developer needs to become a good SQL programmer, too.

8 of 8 people found the following review helpful:

5.0 out of 5 stars SQL for the 400/iSeries Cool!, May 9, 2001

By 

R Stearns (Oregon City, OR USA) - See all my reviews

This review is from: SQL/400 Developer's Guide (Vol 2) (Paperback)

SQL the standard for data access is now presented in a AS400/iSeries user format. The differences that exist for the DB2/400 user are minor but significant enough to warrant 500 pages plus.

Conte and Cravitz flood the text with real working examples that hit homeruns with the IBM midrange user. Yet, minus the sprinkling of RPG/ILE & Cobol code any DB2 user would find the text extremely helpful.

Keep this book at the ready since it's a "quick grab" when questions come up regarding triggers, UDF's or Database Modeling and design.

The Book is a great starting point for the AS400/iSeries guru looking to open their database to the outside world. With a solid SQL footing the JDBC mountain is a much easier climb.

Conte & Cravitz keep up the great work!