IBM證書的七個技術方向

時間：2024-10-12 10:12:43 IBM認證

IBM證書的七個技術方向

　　IBM(國際商業機器公司)或萬國商業機器公司，簡稱IBM(International Business Machines Corporation)。總公司在紐約州阿蒙克市。下面是小編整理的關于IBM證書的七個技術方向，歡迎大家參考!

　　Exam 000-730 DB2 9 Family Fundamentals

　　1. IBM DB2 Overview1.1 Introduction to IBM DB2 Servers and Clients1.3 Different Editions IBM DB2 of Various Platforms

　　2. Deploying IBM DB2 for Windows2.1 Installation requirements for DB2 servers2.2 IBM DB2 Disk and Memory Requirements2.3 Configuring OS settings2.4 Installing IBM DB2 Database Server Enterprise Edition2.5 Installing IBM DB2 Database Server Enterprise Edition (Cont.)

　　3. DB2 Tools3.1 Tools Overview3.2 The Control Center3.3 The Journal3.4 The Task Center3.5 Health Center3.6 Command Editor

　　4. DB2 Command Line Processor (CLP)4.1 Using the DB2 Command Window4.2 Using the DB2 Command Line Processor CLP

　　5. Basic Concept of IBM DB2 Database5.1 Components of an IBM DB2 Database5.2 Creating a DB2 Database5.3 Installing DB2 Client5.4 Connecting a client to DB25.5 Data Types5.6 Schema5.7 Table5.8 Referential Integrity - Creating Relationships Between Tables5.9 Altering a table5.10 Constraints5.11 Understanding Views

　　6. Index6.1 Purpose of an Index6.1 Creating an Index (Cont.)6.2 Non-clustered and Clustered Index6.3 Non-Clustered Index with Included Columns6.4 Improving Update performance6.5 Composite Index (組合索引)6.6 Design Advisor6.7 Materialized Query Table (MQT)

　　7. SQL7.1 Limit the amount of data returned by a query7.2 Sorting Results7.3 Retrieving data from multiple tables

　　8. Sequence8.1 Introducing Sequence object8.2 Creating and Altering a Sequence8.3 Rolling back a transaction with sequence

　　9. Understanding Transactions9.1 Understanding data consistency9.2 Understanding Unit of Work9.3 Effects of Commit and Rollback operations9.4 Using SAVEPOINT

　　10. Understanding Concurrency and Isolation10.1 Phenomena that may occur when multiple users access a database10.2 Concurrency and Isolation Levels10.3 Repeatable Read

　　Exam 000-731 DB2 9 DBA for Linux UNIX and WindowsSection 1 - DB2 Server Management

　　Ability to configure/manage DB2 instances (e.g. scope)

　　Ability to obtain/modify database manager configuration information

　　Ability to obtain/modify database configuration information

　　Knowledge of the DB2 force command

　　Ability to configure client/server connectivity

　　Ability to schedule jobs

　　Ability to use Automatic Maintenance (i.e., RUNSTAT, Backup, REORG)

　　Ability to configure client server connectivity using DISCOVERY

　　Skill in interpreting the Notify log

　　Ability to obtain and modify DB2 registry variables

　　Ability to use Self-tuning memory managemer and autoconfig

　　Ability to use Throttling utilities

　　Section 2 - Data Placement

　　Ability to create a database

　　Skill in discussing the use of schemas

　　Skill in discussing the various table space states

　　Ability to create and manipulate the various DB2 objects

　　Ability to create and discuss the characteristics of an SMS tablespace

　　Ability to create and discuss the characteristics of an automated managed tablespace

　　Knowledge of partitioning capabilities (e.g., Table partitioning, Hash partitioning, MDC, Hybrid)

　　Knowledge of XML structure (indexing for performance)

　　Knowledge of compression data

　　Section 3 - Database Access

　　Knowledge of the creation and management of indexes

　　Ability to create constraints on tables (e.g., RI, Informational, Unique)

　　Ability to create views on tables

　　Skill in examining the contents of the System Catalog tables

　　Ability to use the GUI Tools for administration

　　Knowledge of how to enforce data uniqueness

　　Section 4 - Analyzing DB2 Activity

　　Ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information

　　Ability to capture snapshots using Get Snapshots or SQL functions

　　Ability to create and activate event monitors

　　Ability to configure Health Monitor using the Health Center

　　Ability to identify the functions of Problem Determination Tools (e.g, db2pd, db2mtrk)

　　Section 5 - Utilities

　　Ability to use EXPORT utility to extract data from a table

　　Ability to use IMPORT utility to insert data into a table

　　Ability to use the LOAD utility to insert data into a table

　　Knowledge to identify when to use IMPORT vs. LOAD

　　Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities

　　Ability to use DB2Move, DB2Look and DB2Batch

　　Knowledge of the functionality of the DB2 Advisors (db2advis utility)

　　Ability to use the DB2 Control Center

　　Section 6 - High Availability

　　Ability to perform database-level and table space level BACKUP & RESTORE

　　Knowledge to identify and explain issues on index recreation

　　Knowledge of database logging

　　Knowledge of crash recovery

　　Knowledge of version recovery

　　Knowledge of Roll Forward recovery

　　Knowledge of and ability to perform HADR

　　Knowledge of and ability to perform Log Mirroring

　　Knowledge of Configurable Online Parameters

　　Section 7 - Security

　　Knowledge of DB2 authentication

　　Knowledge of DB2 authorizations

　　Ability to set user and/or group privileges

　　Knowledge of the DB2 Security Infrastructure (e.g. LBAC and Security Plug-ins)

【IBM證書的七個技術方向】相關文章：

IBM簡介07-09

IBM認證的分類和獲得IBM認證的好處10-18

什么是IBM認證09-02