---

DB2 9 Fundamentals: Certification Study Guide

ISBN: 1583470727
EAN: 2147483647

Year: 2007
Pages: 93

Authors: Roger E. Sanders

BUY ON AMAZON

• 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