DB2 9 Fundamentals: Certification Study Guide
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 93
Pages: 93
Authors: Roger E. Sanders
- Table of Contents
- Back Cover
- DB2 9 Fundamentals Certification Study Guide, First Edition
- About This Book
- Conventions Used
- Foreword
- Preface
- Chapter 1: IBM DB2 9 Certification
- The Certification Process
- Chapter 2: Planning
- The DB2 Family
- Other DB2 Products
- DB2 9 s Comprehensive Tool Set
- A Word About Database Workloads
- Practice Questions
- Chapter 3: Security
- Controlling Database Access
- Authentication
- Authorities and Privileges
- Granting Authorities and Privileges
- Authorities and Privileges Needed to Perform Common Tasks
- Practice Questions
- Chapter 4: Working with Databases and Database Objects
- Servers, Instances, and Databases
- Managing Instances
- Creating a DB2 9 Database
- DB2 s Directory Files
- Establishing a Database Connection
- Creating Database (Data) Objects
- Deleting Database (Data) Objects
- Practice Questions
- Chapter 5: Working with DB2 Data Using SQL and XQuery
- Structured Query Language (SQL)
- SQL Data Manipulation Language (DML) Statements
- A Closer Look at the SELECT Statement and Its Clauses
- Obtaining Results from a Result Data Set Using a Cursor
- Transactions and Transaction Boundaries
- Invoking User-Defined Functions
- Calling a Stored Procedure
- Working with XML Data
- Practice Questions
- Chapter 6: Working with DB2 Tables, Views, and Indexes
- DB2 9 s Data Types
- Understanding Constraints
- Creating Tables
- A Quick Review of Schemas
- Examples of the CREATE TABLE SQL Statement
- A Closer Look At Declared Temporary Tables
- Another Look At Views
- A Closer Look At Indexes
- Another Look at Triggers
- Practice Questions
- Chapter 7: Database Concurrency
- Understanding Data Consistency
- Isolation Levels
- Locking
- Practice Questions
- Appendix A: DB2 9 Fundamentals Exam (Exam 730) Objectives
- Appendix B: Sample Test
- Planning
- Security
- Working with Databases and Database Objects
- Working with DB2 Data Using SQL and XQuery
- Working with DB2 Tables, Views, and Indexes
- Data Concurrency
- Index
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Z
- List of Figures
- List of Tables
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 93
Pages: 93
Authors: Roger E. Sanders