|
Exam C2090-730
DB2 9 Family Fundamentals
1. IBM DB2 Overview
1.1 Introduction to IBM DB2 Servers and Clients
1.3 Different Editions IBM DB2 of Various Platforms
2. Deploying IBM DB2 for Windows
2.1 Installation requirements for DB2 servers
2.2 IBM DB2 Disk and Memory Requirements
2.3 Configuring OS settings
2.4 Installing IBM DB2 Database Server Enterprise Edition
2.5 Installing IBM DB2 Database Server Enterprise Edition (Cont.)
3. DB2 Tools
3.1 Tools Overview
3.2 The Control Center
3.3 The Journal
3.4 The Task Center
3.5 Health Center
3.6 Command Editor
4. DB2 Command Line Processor (CLP)
4.1 Using the DB2 Command Window
4.2 Using the DB2 Command Line Processor CLP
5. Basic Concept of IBM DB2 Database
5.1 Components of an IBM DB2 Database
5.2 Creating a DB2 Database
5.3 Installing DB2 Client
5.4 Connecting a client to DB2
5.5 Data Types
5.6 Schema
5.7 Table
5.8 Referential Integrity - Creating Relationships Between Tables
5.9 Altering a table
5.10 Constraints
5.11 Understanding Views
6. Index
6.1 Purpose of an Index
6.1 Creating an Index (Cont.)
6.2 Non-clustered and Clustered Index
6.3 Non-Clustered Index with Included Columns
6.4 Improving Update performance
6.5 Composite Index (組合索引)
6.6 Design Advisor
6.7 Materialized Query Table (MQT)
7. SQL
7.1 Limit the amount of data returned by a query
7.2 Sorting Results
7.3 Retrieving data from multiple tables
8. Sequence
8.1 Introducing Sequence object
8.2 Creating and Altering a Sequence
8.3 Rolling back a transaction with sequence
9. Understanding Transactions
9.1 Understanding data consistency
9.2 Understanding Unit of Work
9.3 Effects of Commit and Rollback operations
9.4 Using SAVEPOINT
10. Understanding Concurrency and Isolation
10.1 Phenomena that may occur when multiple users access a database
10.2 Concurrency and Isolation Levels
10.3 Repeatable Read
|
