Flylib.com
DB2 9 Fundamentals: Certification Study Guide
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
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
Year: 2007
Pages: 93
Authors:
Roger E. Sanders
BUY ON AMAZON
MySQL Stored Procedure Programming
Using Unbounded SELECT Statements
Calling Stored Functions
Trigger Overhead
Review of ADO.NET Basics
The Development Process
The .NET Developers Guide to Directory Services Programming
Definition of Active Directory
System.DirectoryServices.ActiveDirectory Overview
Controlling the Content of Search Results
Useful Shortcuts for Developers
Error 0x80072020: "An operations error occurred."
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Basic Router Configuration
Static Routes
RIP
Neighbor Authentication
A.1. IPv4 Subnetting
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Success Story #3 Fort Wayne, Indiana From 0 to 60 in nothing flat
The Value in Conquering Complexity
Phase 3 Mobilization
Service Process Challenges
Designing World-Class Services (Design for Lean Six Sigma)
DNS & BIND Cookbook
Configuring a Name Server Not to Forward Certain Queries
Returning Different Answers to Different Queriers
Figuring Out How Much Memory a Name Server Will Need
Setting Up a Hidden Primary Master Name Server
Upgrading from BIND 8 to BIND 9
Understanding Digital Signal Processing (2nd Edition)
SIGNAL AMPLITUDE, MAGNITUDE, POWER
OPTIMIZED IIR FILTER DESIGN METHOD
A BRIEF COMPARISON OF IIR AND FIR FILTERS
REFERENCES
FREQUENCY TRANSLATION WITHOUT MULTIPLICATION
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies