700 6部分
DB2 V8.1 Family Fundamentals 认证准备教程,第 1 部分:DB2 规划
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 2 部分:DB2 安全性
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 3 部分:访问 DB2 UDB 数据
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 4 部分:使用 DB2 UDB 数据
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 5 部分:使用 DB2 UDB 对象
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 6 部分:数据并发性
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/index.html
701 6部分
DB2 V8.1 Database Administration 认证准备教程,第 1 部分:服务器管理
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/index.html
DB2 V8.1 Database Administration 认证准备教程,第 2 部分:数据放置
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/index.html
DB2 V8.1 Database Administration 认证准备教程,第 3 部分:数据库访问
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/index.html
DB2 V8.1 Database Administration 认证准备教程,第 4 部分:监控 DB2 活动
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/index.html
DB2 V8.1 Database Administration 认证准备教程,第 5 部分:DB2 实用程序
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/index.html
DB2 V8.1 Database Administration 认证准备教程,第 6 部分:备份与恢复
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/index.html
DB2 V8.1 Family Fundamentals 认证准备教程,第 1 部分:DB2 规划
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu1.jpg)
![2.DB2 产品](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu2.jpg)
![3.DB2 工具](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu3.jpg)
![4.控制中心](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu4.jpg)
![5.配置助手(Configuration Assistant)](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu5.jpg)
![6.其它 DB2 工具](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu6.jpg)
![7.数据仓库](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu7.jpg)
![8.OLAP](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu8.jpg)
![9.参考资料和反馈](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert1v8/tutorial/imagemaster/menu9.jpg)
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu1.jpg)
![2.DB2 安全性](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu2.jpg)
![3.DB2 认证](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu3.jpg)
![4.DB2 权限](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu4.jpg)
![5.DB2 特权](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu5.jpg)
![6.结束语、参考资料及反馈](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert2v8/tutorial/imagemaster/menu6.jpg)
DB2 V8.1 Family Fundamentals 认证准备教程,第 3 部分:访问 DB2 UDB 数据
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu1.jpg)
![2.DB2 数据库由什么组成?](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu2.jpg)
![3.创建您的首个数据库](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu3.jpg)
![4.对您的 DB2 数据库编目](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu4.jpg)
![5.用控制中心(Control Center)操作 DB2 对象](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu5.jpg)
![6.创建和访问基本 DB2 对象](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu6.jpg)
![7.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert3v8/tutorial/imagemaster/menu7.jpg)
DB2 V8.1 Family Fundamentals 认证准备教程,第 4 部分:使用 DB2 UDB 数据
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu1.jpg)
![2.结构化查询语言(SQL)](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu2.jpg)
![3.数据控制语言(DCL)](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu3.jpg)
![4.数据定义语言(DDL)](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu4.jpg)
![5.数据操作语言(DML)](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu5.jpg)
![6.SQL 过程](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu6.jpg)
![7.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert4v8/tutorial/imagemaster/menu7.jpg)
DB2 V8.1 Family Fundamentals 认证准备教程,第 5 部分:使用 DB2 UDB 对象
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu1.jpg)
![2.数据类型](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu2.jpg)
![3.表](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu3.jpg)
![4.约束](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu4.jpg)
![5.视图](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu5.jpg)
![6.索引](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu6.jpg)
![7.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert5v8/tutorial/imagemaster/menu7.jpg)
DB2 V8.1 Family Fundamentals 认证准备教程,第 6 部分:数据并发性
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu1.jpg)
![2.事务](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu2.jpg)
![3.并发性和隔离级别](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu3.jpg)
![4.锁](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu4.jpg)
![5.影响锁定的因素](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu5.jpg)
![6.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert6v8/tutorial/imagemaster/menu6.jpg)
701 6部分
DB2 V8.1 Database Administration 认证准备教程,第 1 部分:服务器管理
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu1.jpg)
![2.DB2 实例](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu2.jpg)
![3.DB2 客户机/服务器连通性](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu3.jpg)
![4.DB2 安全性](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu4.jpg)
![5.调度作业](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu5.jpg)
![6.使用通知日志](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu6.jpg)
![7.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7011/tutorial/imagemaster/menu7.jpg)
DB2 V8.1 Database Administration 认证准备教程,第 2 部分:数据放置
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu1.jpg)
![2.创建数据库](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu2.jpg)
![3.使用模式](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu3.jpg)
![4.表空间状态](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu4.jpg)
![5.创建并操作各种 DB2 对象](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu5.jpg)
![6.DB2 存储三角](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu6.jpg)
![7.SMS 表空间](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu7.jpg)
![8.DMS 表空间](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu8.jpg)
![9.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7012/tutorial/imagemaster/menu9.jpg)
DB2 V8.1 Database Administration 认证准备教程,第 3 部分:数据库访问
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu1.jpg)
![2.使用 GUI 工具创建 DB2 任务](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu2.jpg)
![3.创建并管理索引](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu3.jpg)
![4.定义表的数据约束](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu4.jpg)
![5.创建并管理视图](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu5.jpg)
![6.访问系统目录表](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu6.jpg)
![7.强制数据唯一性](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu7.jpg)
![8.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7013/tutorial/imagemaster/menu8.jpg)
DB2 V8.1 Database Administration 认证准备教程,第 4 部分:监控 DB2 活动
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu1.jpg)
![2.捕获快照](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu2.jpg)
![3.捕获事件监视器数据](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu3.jpg)
![4.利用 Explain 分析 SQL](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu4.jpg)
![5.使用运行状况中心和内存可视化器](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu5.jpg)
![6.利用 DB2 控制器和查询巡视器](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu6.jpg)
![7.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7014/tutorial/imagemaster/menu7.jpg)
DB2 V8.1 Database Administration 认证准备教程,第 5 部分:DB2 实用程序
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu1.jpg)
![2.数据移动实用程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu2.jpg)
![3.DB2 EXPORT 实用程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu3.jpg)
![4.DB2 IMPORT 实用程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu4.jpg)
![5.DB2 LOAD 实用程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu5.jpg)
![6.DB2 维护实用程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu6.jpg)
![7.DB2 控制中心](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu7.jpg)
![8.DB2 顾问程序](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu8.jpg)
![9.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7015/tutorial/imagemaster/menu9.jpg)
DB2 V8.1 Database Administration 认证准备教程,第 6 部分:备份与恢复
https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/index.html
![1.简介](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu1.jpg)
![2.数据库恢复概念](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu2.jpg)
![3.DB2 日志](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu3.jpg)
![4.数据库和表空间备份](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu4.jpg)
![5.数据库和表空间恢复](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu5.jpg)
![6.数据库和表空间前滚](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu6.jpg)
![7.索引的重新创建](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu7.jpg)
![8.结束语](https://www6.software.ibm.com/developerworks/cn/dmdd/library/tutorials/campaign/db2cert7016/tutorial/imagemaster/menu8.jpg)