|   A Thorough Overview of SQL and DB2
SQL for DB2
Author: James Cooper, Paul ContePrice: $85.00
On Sale: $79.96
Availability: Out of stock--more coming
ISBN: 978-1-58304-123-9
SKU: 5845 | |
 
Book Description:
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
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
Product Details: | Audience: | Database Adiminstrators | | Level: | Novice to Intermediate | | Format: | Paperback, Perfectbound | | Publisher: | 29th Street Press | | Publish Date: | May 2009 |
SQL for DB2
Author: James Cooper, Paul ContePrice: $85.00
On Sale: $79.96
Availability: Out of stock--more coming
ISBN: 978-1-58304-123-9
SKU: 5845 | |
|  DB2 9 FundamentalsPrepare for IBM Exam 730 by learning from one of the world's leading experts and an active participant in the creation of the exam.
| | |  SQL for eServer i5 and iSeriesIn this book, you will learn about Structured Query Language (SQL), but with an IBM eServer i5/iSeries twist. With a practical "how-to" style, this book introduces you to the basics and then examines--in detail--the many ways in which SQL functions on the iSeries.
| | |  XML for eServer i5 and iSeriesIn this book, you will learn about Extensible Markup Language (XML), but with an IBM eServer i5/iSeries twist. An incredibly versatile language, XML can adapt to any programming language and any platform. Truly it is a language without boundaries that will take the i5/iSeries platform to new heights. XML is fast becoming required knowledge for every i5/iSeries professional. Don't get left behind. Learn to harness the power of XML today.
| |
|
| |
© 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
|
|
|
