| Week |
Topic |
Courseware |
Software |
Retail Book |
Additional Resource Material |
| |
|
All course material is accessed from the
courseware
repository
|
All software can be downloaded from the
software
catalog
|
|
|
1 |
Database Systems - Database Administration |
DB2 Family Fundamentals (CF030)
Unit 5: What does an Administrator do in DB2 UDB?
IBM DB2 Universal Database V8.1 System Administration (L1-626)
DB2 Universal Database Administration Workshop (CF23)
DB2 Universal Database Advanced Administration Workshop (CF45)
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Understanding DB2 - Learning Visually with Examples;
Teach Yourself DB2 Universal Database in 21 Days
DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e;
High Availability for DB2
The Official Introduction to DB2 for z/OS: covers DB2 Universal Database Version 8.1 for z/OS
An Introduction to IMS: Your Complete Guide to IBM's Information Management System;
Apache Derby: Off to the Races (includes coverage for IBM Cloudscape)
|
Data Placement
Tutorial: DB2 UDB V8.1 Database Administration: Part 2 Data Placement
Part 2
pp 1 to 66
DB2 Access
Tutorial: DB2 UDB V8.1 Database Administration: Part 3 DB2 Access
Part 3
pp 1 to 66
DB2 Utilities
Tutorial: DB2 UDB V8.1 Database Administration: Part 5 DB2 Utilities
Part 5
pp 1 to 34
Backup and Recovery
Tutorial: DB2 UDB V8.1 Database Administration: Part 6 Backup and Recovery
Part 6
pp 1 to 37
|
2 |
Data Modeling data normalization
|
DB2 Family Fundamentals (CF030)
Unit 2: Data Modeling and Database Design
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 3: DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Day 8, Teach Yourself DB2 Universal Database in 21 Days
|
Logical database design
Product Manual: IBM DB2 Universal Database Administration Guide: Planning (1.87MB)
Get Adobe® Reader®
Ch 4
pp 47-61
|
3 |
Relational Databases
|
Relational Database Design (CF18)
DB2 Family Fundamentals (CF030)
Unit 6: Information Management with DB2
DB2 Universal Database Administration Workshop (CF23)
Unit 1: Overview of DB2 UDB
Unit 2: Getting Started with DB2 UDB GUIs
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 3: DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Understanding DB2 - Learning Visually with Examples;
|
DB2 Planning
Tutorial: DB2 UDB V8.1 Family Fundamental: Part 1 DB2 Planning
pp 1 to 63
Concepts
Product Manual: IBM DB2 Universal Database SQL Reference1 (1.87MB)
Get Adobe® Reader®
Ch 1
pp 1 to 60
Basic relational database concepts
Product Manual: IBM DB2 Universal Database Administration Guide: Planning (1.87MB)
Get Adobe® Reader®
Ch 1
pp 1-24
|
4 |
Database query languages
|
SQL Fundamentals for IBM DB2 Study Guide
pp 1 to 175
DB2 SQL Workshop (CF12)
DB2 SQL Workshop for Experienced Users (CF13)
IBM DB2 Universal Database V8.1 System Administration (L1-626)
Module 13: Query
Optimization
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Part 2: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 9: Understanding DB2 - Learning Visually with Examples;
Day 12, Teach Yourself DB2 Universal Database in 21 Days
|
Queries
Product Manual: IBM DB2 Universal Database SQL Reference (2.92MB)
Get Adobe® Reader®
Ch 4
pp 553 to 606
Functions
Product Manual: IBM DB2 Universal Database SQL Reference (2.92MB)
Get Adobe® Reader®
Ch 3
pp 247 to 552
Teaching Tools
Hello World, Part 7: DB2 for Linux, UNIX, and Windows
DB2 Detective Game
DB2 Business Game
|
5 |
Relational database design - Data Definition Language
|
Relational Database Design (CF18)
Introduction to IBM DB2 Universal Database (FN625)
Module 3: Creating & Accessing DB2 Databases
Module 4: Basic SQL
Module 5: Intermediate SQL
DB2 SQL Workshop (CF12)
DB2 SQL Workshop for Experienced Users (CF13)
Unit 2: Create Objects
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Part 2: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 9: Understanding DB2 - Learning Visually with Examples;
Day 12, Teach Yourself DB2 Universal Database in 21 Days
|
Accessing DB2 UDB data
Tutorial: DB2 UDB V8.1 Family Fundamental: Part 3 Accessing DB2 UDB data
Part 3
pp 1 to 47
Working with DB2 Data
Tutorial: DB2 UDB V8.1 Family Fundamental: Part 4 Working with DB2 Data
Part 4
ppp 1 to 34
Working with DB2 UDB Objects
Tutorial: DB2 UDB V8.1 Family Fundamental: Part 5 Working with DB2 UDB Objects
Part 5
pp 1 to 27
Concepts
Product Manual: IBM DB2 Universal Database SQL Reference Vol 1 (2.92MB)
Get Adobe® Reader®
Ch 2
pp 62 to 245
Statements
Product Manual: IBM DB2 Universal Database SQL Reference Vol 2 (2,29MB)
Get Adobe® Reader®
Ch 1
pp 332 to 394, 463 to 479, 497 to 504,512 to 541,603 to 613,738 to 750.
|
6 |
Relational database design - Relational Integrity and Concurrency Control
|
Introduction to IBM DB2
Universal Database (FN625)
Module 7: Database Concurrency
DB2 Universal Database
Administration Workshop (CF23)
Unit 7: Monitoring & Problem Determination
Unit 8: Concurrency
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 8: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 11: Understanding DB2 - Learning Visually with Examples;
|
Data Concurrency
Tutorial: DB2 UDB V8.1 Family Fundamental: Part 6 Data Concurrencya
Part 6
pp 1 to 26
Logical database design
Tutorial: DB2 UDB V8.1 Database Administration: Part 4 Monitoring DB2 Activities
Ch 4
pp 80 to 85
|
7 |
Distributed Databases
|
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 3: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 6: Understanding DB2 - Learning Visually with Examples;
|
Designing Distributed Databases
Product Manual:IBM DB2 Universal Database Administration Guide: Planning (1.86MB)
Get Adobe® Reader®
Ch 6
pp 153 to 169
|
8 |
Physical Database Design
|
Introduction to IBM DB2 Universal Database (FN625)
Module 3: Creating and
Accessing DB2 Databases
Module 4: Basic SQL
Module 5: Intermediate SQL
Module 6: Database Objects
|
Small Medium Client Server
DB2 Express-C
Express
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Part 2: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 3: DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Chapter 7: DB2 Universal Database V8.1 Certification Exam 700 Study Guide
Understanding DB2 - Learning Visually with Examples;
|
Physical database design
Product Manual: IBM DB2 Universal Database Administration Guide: Planning (1.86MB)
Get Adobe® Reader®
Ch 5
pp 89 to 136
|
9 |
Physical Database Design - Performance Tuning |
DB2 Universal Database Programming Fundamentals (CF10)
Unit 8: Performance Tuning
DB2 Universal Database Advanced Programming (CF11)
Unit 8: Advanced Performance
DB2 UDB for Linux, UNIX and Windows Programming Using Java (CG11)
Unit 7: Performance Considerations
IBM DB2 Universal Database V8.1 System Administration (L1-626)
Module 12: Performance Monitoring
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database
Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 12: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e;
Several chapters: DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Chapter 16: Understanding DB2 - Learning Visually with Examples;
|
Monitoring DB2 Activities
Tutorial: DB2 UDB V8.1 Database Administration: Part 4 Monitoring DB2 Activities
Part 4
pp 1 to 62
|
10 |
Data Mining
|
|
Relational Database Management System
DB2 Universal Database Enterprise Server Edition (ESE)
PLUS
Discover Relationships
DB2 Intelligent Miner Modeling
Apply Relationships
DB2 Intelligent Miner Scoring
View & Evaluate Results
DB2 Intelligent Miner Visualization
|
Chapter 14 : IBM Data Warehousing: With IBM Business Intelligence Tools |
Enhance Your Business Applications: Simple Integration of Advanced Data Mining Functions
Redbook: Enhance Your Business Applications: Simple Integration of Advanced Data Mining Functions (5.62MB)
Get Adobe® Reader®
Ch 1, 2 and 3
pp 1-49
Mining Your Own Business in Health Care Using DB2 Intelligent Miner for Data
Mining Your Own Business in Telecoms using DB2 Intelligent Miner for Data
EIP Information Mining In A Nutshell
Solving Business Problems with DB2Intelligent Miner
Easy Mining
Procedures for DB2 Intelligent Miner
Easy Mining Procedures
for DB2 Intelligent Miner
provide an easy-to-use SQL interface for the main steps of the data-mining process. In particular, they contain stored procedures for the basic mining functions such as classification, clustering, or discovery of association rules and procedures for general, "higher-level" mining concepts such as the discovery of a prediction model or the detection of outliers in a table. This set of procedures is (or will be) complemented by some important preprocessing operations (such as the computation of a data model for customer segmentation) and some utility procedures.
http://www.alphaworks
.ibm.com
/tech/imeasymining
DB2 Intelligent Miner: Comprehensive
Guide to IBM DB2 Intelligent Miner,
Version 8.2
http://www-128.ibm.com
/developerworks/db2
/library/techarticle
/dm-0506nicolussi/
|
11 |
Information Storage and Retrieval Import Data
|
DB2 Universal Database Programming Fundamentals (CF10)
Unit 7. Managing Test Data
IBM DB2 UDB for Oracle DBAs (L1-251)
Module 8 Data Migration Methods Loading Tables
IBM DB2 Universal Database V8.1 System Administration (L1-626)
Module 8 Data Movement Utilities
DB2 Universal Database Administration Workshop for Windows (CF23)
5.1 Export/Import Utilities
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 10: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 7: DB2 UDB v8.1 Handbook for Linux, UNIX, and Windows, 1/e
Chapter 12: Understanding DB2 - Learning Visually with Examples;
|
|
12 |
Information Storage and Retrieval - Security
|
Introduction to IBM DB2 Universal Database (FN625)
Module 2: Security and Instances
DB2 Universal Database Administration Workshop (CF23)
Unit 11: Security
IBM DB2 Universal Database V8.1 System Administration (L1-626)
Module 15: Security
|
Small Medium Client Server
DB2 Express-C
Large Client-server
DB2 Universal Database Enterprise Server Edition (ESE)
Informix Dynamic Server (IDS)
|
Chapter 4: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e;
Chapter 4: Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e;
Chapter 10: Understanding DB2 - Learning Visually with Examples;
|
DB2 Security
Tutorial: DB2 UDB V8.1 Database Administration: Part 2 Data Placement
Part 2
page 1 to 22
Tutorial: DB2
UDB V8.1 Family
Fundamental: Part
2 DB2 Security
Server Management
Tutorial: DB2 UDB V8.1 Database Administration: Part 1 Server Management
Part 1
pp 1 to 45
|
