DB2 Universal Database V8. 1 Certification Exam 700 Study Guide,9780131424654

DB2 Universal Database V8. 1 Certification Exam 700 Study Guide

by
Edition: 1st
ISBN13: 9780131424654
ISBN10: 0131424653
Format: Paperback
Pub. Date: 2003-09-29
Publisher(s): IBM Press
List Price: $64.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

-Covers all the material you need to know to pass the exam using sample exam questions and answers-Written by a DB2 Certified expert who was involved in the development of the Version 8 certification exams and the author of 7 best-selling DB2 titles!-Part of the IBM Press DB2 Series

Author Biography

Roger Sanders is a Database Performance Engineer with Network Appliance, Inc. He has been designing and programming software applications for IBM PCs for more than 15 years and he has worked with the DB2 Universal Database and its predecessors for the past 10 years. He has written several computer magazine articles, authored a tutorial on Database Concurrency for IBM's DeveloperWorks web site, presented at three IDUG conferences, and is the author of seven DB2 titles (073842522, 0072133759 (best-selling all-in-one exam guide), 0071353895, 007353925, 0071345728, 0070580871, 007057725). Sanders should receive 4 Version 8 certifications before the first Version 8 book even hits the market.

Table of Contents

Foreword xiii
Part 1 DB2 UDB Certification
Chapter 1 IBM DB2 Universal Database Certification
3(28)
DB2 Universal Database Certification Roles
3(14)
IBM Certified Database Associate-DB2 Universal Database V8.1 Family
4(1)
IBM Certified Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows
5(3)
IBM Certified Database Administrator-DB2 Universal Database V8.1 for z/OS and OS/390
8(2)
IBM Certified Application Developer-DB2 Universal Database V8.1 Family
10(3)
IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows
13(1)
IBM Certified Solution Designer-Business Intelligence V8.1
14(3)
The Certification Process
17(14)
Preparing for the Certification Exams
17(2)
Arranging to Take a Certification Exam
19(2)
Taking an IBM Certification Exam
21(10)
Part 2 DB2 UDB Family Fundamentals
Chapter 2 Planning
31(60)
The DB2 Universal Database Family
39(23)
DB2 Everyplace-Database Edition and Enterprise Edition
41(1)
DB2 Universal Database Personal Edition
42(1)
DB2 Workgroup Server Edition
43(1)
DB2 Workgroup Server Unlimited Edition
44(1)
DB2 Enterprise Server Edition
45(2)
DB2 Personal Developer's Edition
47(1)
DB2 Universal Developer's Edition
48(1)
DB2 Universal Database Clients
48(3)
Other DB2 Universal Database Products
51(9)
How DB2 Universal Database Products Are Packaged
60(2)
DB2 Universal Database's Comprehensive Tool Set
62(22)
The Control Center
63(2)
The Replication Center
65(1)
The Satellite Administration Center
66(1)
The Data Warehouse Center
67(1)
The Command Center
67(5)
The Task Center
72(1)
The Information Catalog Center
73(1)
The Health Center
74(1)
The Journal
74(3)
The License Center
77(1)
The Development Center
77(2)
The Information Center
79(1)
The Command Line Processor
80(2)
The Configuration Assistant
82(2)
Practice Questions
84(3)
Answers
87(4)
Chapter 3 Security
91(48)
Controlling Database Access
92(1)
Authentication
93(4)
Where Does Authentication Take Place?
94(1)
Trusted Clients Versus Untrusted Clients
95(2)
Authorities and Privileges
97(18)
Authorities
98(6)
Privileges
104(10)
Requirements for Granting and Revoking Authorities and Privileges
114(1)
Granting Authorities and Privileges
115(13)
Granting and Revoking Authorities and Privileges from the Control Center
116(2)
Granting Authorities and Privileges with the GRANT SQL Statement
118(5)
Revoking Authorities and Privileges with the REVOKE SQL Statement
123(5)
Authorities and Privileges Needed to Perform Common Tasks
128(2)
Practice Questions
130(4)
Answers
134(5)
Chapter 4 Accessing DB2 UDB Data
139(50)
Servers, Instances, and Databases
141(1)
What Makes Up a DB2 UDB Database?
142(4)
DB2 UDB Objects
143(3)
Creating a DB2 UDB Database with the CREATE DATABASE Command
146(9)
What Happens When a DB2 UDB Database Is Created
146(5)
The CREATE DATABASE Command
151(4)
Creating a DB2 UDB Database with the Create Database Wizard
155(2)
Deleting a DB2 UDB Database
157(1)
DB2 UDB'S Directory Files
158(4)
The System Database Directory
159(1)
The Local Database Directory
160(1)
The Node Directory
160(1)
The Database Connection Services (DCS) Directory
161(1)
Cataloging and Uncataloging a DB2 UDB Database
162(4)
Cataloging and Uncataloging a Node
166(2)
Cataloging and Uncataloging a DCS Database
168(1)
Cataloging Remote Databases with the Add Database Wizard
169(3)
Access Profiles
171(1)
DB2 Discovery
171(1)
Manual Configuration
172(1)
Database Objects
172(10)
Tables
173(1)
Indexes
174(1)
Views
175(1)
Aliases
176(1)
Schemas
177(1)
Triggers
178(1)
User-Defined Data Types
179(1)
User-Defined Functions (or Methods)
180(1)
Sequences
180(2)
Practice Questions
182(4)
Answers
186(3)
Chapter 5 Working with DB2 UDB Data
189(112)
Structured Query Language (SQL)
193(46)
Data Control Language (DCL) Statements
194(3)
Data Definition Language (DDL) Statements
197(34)
Data Manipulation Language (DML) Statements
231(8)
The SELECT Statement and Its Clauses
239(33)
The WHERE Clause
243(7)
The GROUP BY Clause
250(4)
The HAVING Clause
254(1)
The ORDER BY Clause
255(2)
The FETCH FIRST Clause
257(1)
Joining Tables
258(7)
Combining Two or More Queries with a Set Operator
265(3)
Using SQL Functions to Transform Data
268(2)
Retrieving Rows from a Result Data Set Using a Cursor
270(2)
Transactions
272(4)
SQL Procedures
276(6)
Creating a Stored Procedure
277(4)
Calling an SQL Procedure
281(1)
Practice Questions
282(17)
Answers
299(2)
Chapter 6 Working with DB2 UDB Objects
301(64)
DB2 Universal Database's Data Types
310(8)
Numeric Data Types
311(2)
Character String Data Types
313(1)
Date/Time Data Types
314(2)
Large Object (LOB) Data Types
316(1)
DataLinks
317(1)
Extenders
318(1)
User-Defined Data Types
318(1)
Understanding Constraints
318(23)
NOT NULL Constraints
319(1)
Default Constraints
319(3)
Check Constraints
322(2)
Unique Constraints
324(1)
Referential Integrity Constraints
325(11)
Temporarily Suspending Constraint Checking with the SET INTEGRITY SQL Statement
336(5)
Creating Tables with the CREATE TABLE SQL Statement
341(8)
Creating Tables That Are Similar to Existing Tables
348(1)
A Word about Declared Temporary Tables
348(1)
CREATE TABLE SQL Statement Examples
349(5)
Example 1
349(1)
Example 2
350(1)
Example 3
351(3)
Practice Questions
354(6)
Answers
360(5)
Chapter 7 Database Concurrency
365(38)
Understanding Data Consistency
366(1)
Isolation Levels
367(8)
The Repeatable Read Isolation Level
370(1)
The Read Stability Isolation Level
371(1)
The Cursor Stability Isolation Level
372(1)
The Uncommitted Read Isolation Level
373(1)
Choosing the Proper Isolation Level
374(1)
Specifying the Isolation Level to Use
374(1)
Locking
375(20)
Lock Attributes and Lock States
377(1)
How Locks Are Acquired
377(8)
Which Locks Are Acquired
385(1)
Locks and Performance
386(9)
Practice Questions
395(4)
Answers
399(4)
Appendix A DB2 UDB V8.1 Family Fundamentals Exam (Exam 700) Objectives 403(4)
Index 407

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.