Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
-
All (8)
from
$1.99
-
-
Used (8)
from
$1.99
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since Sun Jan 01 01:01:01 EST 2006
With CD! Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase benefits world
...
literacy!
Read more
Show Less
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Thu Jan 01 01:01:01 EST 2009
Light shelving wear with minimal damage to cover and bindings. Pages show minor use. Help save a tree. Buy all your used books from Green Earth Books. Read. Recycle and Reuse.
Ships from: Portland, OR
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$1.99
Seller since Thu Jan 01 01:01:01 EST 2009
Giving great service since 2004: Buy from the Best! 4,000,000 items shipped to delighted customers. We have 1,000,000 unique items ready to ship! Find your Great Buy today!
Ships from: Toledo, OH
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$2.49
Seller since Fri Jan 01 01:01:01 EST 2010
0130796611 May have highlighting or writing and wear to cover. May not include supplemental items like CDs or access codes. A portion of your purchase of this book will be
...
donated to non-profit organizations. We are a tested and proven company with over 900,000 satisfied customers since 1997. We ship daily M-F. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders.
Read more
Show Less
Ships from: Nashua, NH
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$12.99
Seller since Tue Oct 07 09:42:27 EDT 2014
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.
Ships from: Fort Mill, SC
Usually ships in 1-2 business days
$29.51
Seller since Tue Oct 07 09:35:53 EDT 2014
Possible retired library copy, some have markings or writing.
Ships from: Chatham, NJ
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$31.99
Seller since Tue Oct 07 09:35:53 EDT 2014
Very good.
Ships from: Chatham, NJ
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$32.95
Seller since Tue Oct 07 09:35:53 EDT 2014
As new.
Ships from: Chatham, NJ
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
More About This Textbook
Overview
The only official handbook for IBM's DB2 Certification program
Completely updated for DB2 Universal Database
Covers both database administration and application development
IBM's Professional Certification program provides a mark of excellence recognized around the world. Prepare for DB2 Certification with the manual created by IBM's own team of experts.
This self-paced guide familiarizes you in-depth with administering databases and developing applications for DB2 Universal Database. Incorporating all the latest enhancements present in Version 5, this handbook shows you how to use all of DB2's powerful tools, including the new Control Center.
While this second edition of DB2 Universal Database Certification Guide is intended primarily for users who are preparing for certification, it is also an invaluable resource for anyone who wants to gain a deeper understanding of DB2's wide-ranging capabilities.
The accompanying CD-ROM offers hands-on exercises for every chapter in the book. A trial copy of DB2 is included, along with product README files and libraries. The software runs under Windows 95, Windows NT® and OS/2®.
Editorial Reviews
Booknews
This guide to IBM's DB2 Universal Database Version 5 covers such topics as the installation and configuration of DB2 servers and clients, the Structured Query Language (SQL), database concurrency, database administration and monitoring, alternate programming interfaces, and the development of a static imbedded SQL application. The authors include sample questions for those who wish to become IBM Certified Professionals. A CD-ROM provides a complete set of DB2 products for Windows NT, Windows 95, and OS/2 for 60 days. Annotation c. by Book News, Inc., Portland, Or.Product Details
Related Subjects
Read an Excerpt
Since the publication of the first DB2 Certification Guide in 1996, thousands of readers have learned about DB2 Common Server and earned certification by taking the DB2 Database Administrators and DB2 Database Developers exams. With the introduction of DB2 Universal Database, the newest release of DB2 from IBM, we're pleased to provide a new, updated version of the DB2 Certification Guide.
DB2 Universal Database (UDB) brings together the data management strengths and advanced SQL of DB2 Common Server Version 2 with the scalable parallelism of DB2 Parallel Edition Version 1. To this combination we've added new OLAP functions, enhanced performance, and a rich, integrated set of easy-to-use graphical tools. DB2 UDB is the industry's first multi-media, web-enabled database, that scales from PCs to UNIX platforms, from single-processor machines to SMPs and MPPs, and supports applications from transaction processing to business intelligence.
Businesses today are reaching for extraordinary results in everything they do, in market effectiveness, customer service, product development, quality and logistics. Business Intelligence solutions including data marts, data warehouses and data mining supported by online transaction systems, deliver knowledge to business professionals, and allow better decisions to be made, faster. The role of the trained database professional remains vital to business success, and the shortage of available skills provides opportunities for those who keep current on the latest technological advancements.
This Certification Guide provides the reader with an understanding of the function and tools supported by UDB, and howto use them to do multi-dimensional analysis, to support non-traditional content, or to write an application intended to deliver information over the internet. It gives tips for tuning applications to run their best when using multiple processors, or large memories, or when supporting thousands of users. The reader will learn how to use the new Control Center to define the structure of a database, to view the access plan for SQL using visual explain, and to monitor the execution of an application. The Certification Guide was designed to help you keep current, and to prepare you to meet the needs of your customers and users, within business of all sizes. You'll find the self-study design lets you proceed at your own pace, while learning the material necessary to complete the formal certification exams for a DB2 Database Administrator or DB2 Database Developer. As the importance of data to businesses grows, and as increasingly the responsibility for keeping technical skills current rests with the technical professional, I think you'll find this guide provides a cost-effective and efficient way to meet your business needs. The latest DB2 technology puts customers on the road to getting even more value form their data. I think you'll enjoy being part of the journey.
Hershel Harris
Manager, Database Technology
IBM Software Solutions Division
Preface
This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 5. DB2 Universal Database (UDB) Version 5 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 database servers from IBM, then read on. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of each chapter. There are exercises provided at the end of many of the chapters to provide hands-on use of DB2.
The book is divided into 3 main sections:
Exercises are provided at the end of most of the chapters. The exercises make references to files that can be found on the companion CD-ROM. The exercises are provided to enforce that the concepts discussed in the chapter are understood. Any Intel DB2 operating environment can be used to perform the exercises.
This book can be used as a self-study guide to prepare for the DB2 certification exams or as a complete guide to DB2 Universal Database.
The path to certification involves successfully completing two exams:
The test objectives are provided in Appendixes A, B, and C. These should be used as a guide to ensure that you are fully prepared to take the DB2 exams.
The DB2 Fundamentals Exam (503) covers these skills:
For more details on the contents of this exam, see "DB2 Fundamentals (503) - Test Objectives" on page 714.
The DB2 Database Administration Exam (504) covers these skills:
For more details on the contents of this exam, see "DB2 UDB V5 Database Administration (504) - Test Objectives" on page 718.
The DB2 Application Development exam (505) covers these skills:
For more details on the contents of this exam, see "DB2 UDB V5 Application Development (505) - Test Objectives" on page 722.
Conventions
Many examples of SQL statements, DB2 commands, and operating system commands are included throughout the book. SQL statements are usually displayed within a shaded box and any of the mandatory sections of the statements are shown in uppercase. An example of an SQL statement is shown:
SQL is not a case-sensitive language, so the above query would provide the same result regardless of the case of the SQL keywords, or the database object (table names or column names). Of course the data stored in the database is stored exactly as it was entered (including case). Therefore, the above query would only find the candidates with the last name of `JANACEK' or `SNOW'. If the data were stored as `Janacek', it would not be part of the result table.
If SQL keywords are referred to in the text portion of the book, they will be shown as a bold mono-spaced font. For example, the SELECT statement is used to retrieve data from a DB2 database.
DB2 commands will be shown using the same method as SQL keywords. For example, the CREATE DATABASE command allows you to define the initial location of database objects. DB2 commands are issued from the Command Line Processor (CLP) utility. This utility will accept the commands in upper and lower case. The CLP program itself is an executable called db2. In some operating systems, such as AIX, the program names are case sensitive. Therefore, be careful to enter the program name using the proper case. There are a few operating system specific commands in this book. If the commands must be in lowercase they will be shown as such. For example, the UNIX command to create a user is the mkuser command.
Occasionally, notes are provided to highlight a particular point.
- A note may be used to explain a minor operating system difference or it may be used to summarize a concept.
There are a few syntax diagrams shown in the book. We recommend that the Command Line Processor be used to verify the syntax of DB2 commands. Some of the commands are shown with the complete syntax as shown in the Command Line Processor. The following is an example of complete syntax of the DB2 BACKUP DATABASE command.
A syntax diagram shows how the command should be entered using the Command Line Processor. The diagram should be followed from left to right, and from top to bottom. Parameters are regarded as keywords or variables. A parameter can be a combination of a keyword and a variable.
· Keywords represent constants in the command. They are shown in uppercase in the syntax diagram. For example, BACKUP DATABASE is a keyword. A keyword may be entered in upper-, lower-, or mixed case.
· Variables are values that are user supplied. They are indicated in the command syntax using lowercase. At the command prompt, they may be entered in either upper-, lower-, or mixed case, unless case restrictions are explicitly stated. Some of the user-supplied variables are required, such as database-alias in the BACKUP DATABASE command.
The vertical bar "" means that the keyword following is required. Optional parameters are indicated in the syntax with square brackets "" . An optional parameter may have a possible list of user-supplied input values. This is indicated with the combination of "{" and three periods "...". For example, a user may back up multiple table spaces using a single BACKUP DATABASE command. The DB2 SQL Reference should be used to verify the syntax of SQL statements. To emphasize a term or concept, the term is shown in bold type or emphasized with italics.
How this Book was Created
This book was a joint effort between the Austin ITSO (International Technical Support Organization) and the IBM Toronto Lab. The ITSO is a group within IBM whose mission is to provide skill transfer on new products and technology worldwide. We provide direct feedback to the IBM software labs as we gather input from various groups of DB2 users, including IBM support personnel, customers and business partners. The ITSO provides a working environment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. The team develops a workshop or book, known as a redbook.
- ITSO redbooks - ...
Table of Contents
2. Getting Started and Connected.
3. Controlling Data Access.
4. Using SQL.
5. Database Concurrency.
6. Data Placement.
7. Data Management.
8. Database Monitoring and Tuning.
9. DB2 Application Programming.
10. DB2 Advanced Application Programming.
Appendix A - Test Objectives.
Appendix B - Test Objectives.
Appendix C - Test Objectives.
Appendix D - DB2 Tools and Utilities.
Appendix E - DB2 Example Source Code.
Index.
CD-ROM Installation.