SQL Data Types and Schemas Integrity Constraints Authorization Embedded SQL Dynamic SQL Functions and Procedural Constructs** Recursive Queries** Advanced SQL Features**

Data Definition Basic Query Structure Set Operations Aggregate Functions Null Values Nested Subqueries Complex Queries Views Modification of the Database Joined Relations**

Structure of Relational Databases Fundamental Relational-Algebra-Operations Additional Relational-Algebra-Operations Extended Relational-Algebra-Operations Null Values Modification of the Database

Reasoning with MVDs Higher normal forms Join dependencies and PJNF DKNF

Basic Concepts Tree-Structure Diagrams Data-Retrieval Facility Update Facility Virtual Records Mapping of Hierarchies to Files The IMS Database System

Basic Concepts Data-Structure Diagrams The DBTG CODASYL Model DBTG Data-Retrieval Facility DBTG Update Facility DBTG Set-Processing Facility Mapping of Networks to Files

《数据库系统》课程参考资料：DB2 SQL指南 IBM DB2 Universal Database SQL Reference Volume 2 Version 8（2/2）

7.1程序设计基础 7.2程序的控制结构 7.3程序模块 7.4程序的调试 7.5一个结构化程序设计的实例

《数据库系统》课程参考资料：DB2 SQL指南 IBM DB2 Universal Database SQL Reference Volume 1 Version 8（1/2）

5.1表的建立 5.2表的显示与维护 5.3表的排序与索引 5.4表的统计与计算 5.5多个表的操作