SQL for DB2 - Softcover

Cooper, James; Conte, Paul

Softcover

ISBN 10: 1583041230 ISBN 13: 9781583041239

Publisher: 29th Street Pr, 2009

Synopsis

SQL for DB2 ISBN: 978-1-58304-123-9 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

About this title

About the Author

James Cooper is a professor in the Computer Studies department at Lambton College in Sarnia, Ontario, Canada. During his 24 years with the college, he has taught a variety of computer subjects, focusing primarily on IBM i technology and teaching that subject since 1990. Jim serves as Lambton's liaison to the IBM Academic Initiative program. From 1995 through 2001, he was director of the IBM Roundtable College Conference, an annual IBM international conference for colleges teaching IBM i technologies. As director of the conference, he received an honorary award from IBM for his efforts with the IBM Academic Initiative Program and the Roundtable College Conference. Jim has co-authored two other programming textbooks: Programming in Cobol/400, 2nd Ed. (John Wiley and Sons, 2002) and RPG II and RPG III Structured Programming, 2nd Ed. (John Wiley and Sons, 1991).Paul Conte, a System iNetwork senior technical editor, is president of PCES of Eugene, Oregon, which provides educational and consulting services in software development practices and database design. Paul has been a software developer and consultant for more than 20 years and is a widely published expert on database systems, database design, programming languages, and application development practices. A leading authority on DB2 for IBM i, his articles have appeared in System iNEWS, DB2 Magazine, Database Programming & Design, and numerous other publications. Paul is also author or co-author of several books, including Common Sense C, Database Design and Programming for DB2/400, and SQL/400 Developer's Guide, all published by 29th Street Press. He is also co-author of SQL Server 7.0 Developer's Guide and SQL Server 2000 Developer's Guide, both published by Osborne/McGraw-Hill.

Edition details

• Publisher: 29th Street Pr
• Publication date: 2009
• Language: English
• ISBN 10: 1583041230
• ISBN 13: 9781583041239
• Binding: Paperback
• Number of pages: 400