Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Software
Certification
Networking
Network Administration
Category list
Databases
Relational Databases
Education & Reference
DB2 Universal Database V8.1 Certification Exam 700 Study Guide - page 1
Buy on amazon.com >>
Sanders R. E.
<< Previous book
Next page >>
Main Page
Main Page
Table of content
Copyright
IBM Press SeriesInformation Management
About Prentice Hall Professional Technical Reference
Foreword
Preface
About This Book
Conventions Used
Acknowledgments
About the Author
Part 1: DB2 UDB Certification
Chapter 1. IBM DB2 Universal Database Certification
DB2 Universal Database Certification Roles
The Certification Process
Part 2: DB2 UDB Family Fundamentals
Chapter 2. Planning
The DB2 Universal Database Family
DB2 Universal Database s Comprehensive Tool Set
Practice Questions
Answers
Chapter 3. Security
Controlling Database Access
Authentication
Authorities and Privileges
Granting Authorities and Privileges
Authorities and Privileges Needed to Perform Common Tasks
Practice Questions
Answers
Chapter 4. Accessing DB2 UDB Data
Servers, Instances, and Databases
What Makes Up a DB2 UDB Database?
Creating a DB2 UDB Database with the CREATE DATABASE Command
Creating a DB2 UDB Database with the Create Database Wizard
Deleting a DB2 UDB Database
DB2 UDB s Directory Files
Cataloging and Uncataloging a DB2 UDB Database
Cataloging and Uncataloging a Node
Cataloging and Uncataloging a DCS Database
Cataloging Remote Databases with the Add Database Wizard
Database Objects
Practice Questions
Answers
Chapter 5. Working with DB2 UDB Data
Structured Query Language (SQL)
The SELECT Statement and Its Clauses
Answers
Chapter 6. Working with DB2 UDB Objects
DB2 Universal Database s Data Types
Understanding Constraints
Creating Tables with the CREATE TABLE SQL Statement
CREATE TABLE SQL Statement Examples
Practice Questions
Answers
Chapter 7. Database Concurrency
Understanding Data Consistency
Isolation Levels
Locking
Practice Questions
Answers
Appendix A. DB2 UDB V8.1 Family Fundamentals Exam (Exam 700) Objectives
Planning (15)
Security (9)
Accessing DB2 UDB Data (15)
Working with DB2 UDB Data (31)
Working with DB2 UDB Objects (19)
Data Concurrency (11)
Buy on amazon.com >>
Sanders R. E.
<< Previous book
Next page >>