▪ Complex Data Types and Object Orientation ▪ Structured Data Types and Inheritance in SQL ▪ Table Inheritance ▪ Array and Multiset Types in SQL ▪ Object Identity and Reference Types in SQL ▪ Implementing O-R Features ▪ Persistent Programming Languages ▪ Comparison of Object-Oriented and Object-Relational Databases

3.1 Introduction 3.2 Setting Up the Database 3.3 Queries 3.4 View 3.5 Data manipulation 3.6 Security

佛山开放大学：《SQL Server 2000 程序设计》课程教学资源（PPT课件）第3章 表和表数据的操作

佛山开放大学：《SQL Server 2000 程序设计》课程教学资源（PPT课件）第12章 ODBC数据库应用程序开发

佛山开放大学：《SQL Server 2000 程序设计》课程教学资源（PPT课件）第8章 数据的备份和恢复

7.1 程序设计基础知识 7.2 流程控制语句 7.3 其它语句 7.4 内置函数 7.5 用户自定义函数

▪ Transaction Concept ▪ Transaction State ▪ Concurrent Executions ▪ Serializability ▪ Recoverability ▪ Implementation of Isolation ▪ Transaction Definition in SQL ▪ Testing for Serializability

Transaction Concept Transaction State Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL Testing for Serializability

Complex Data Types and Object Orientation Structured Data Types and Inheritance in SQL Table Inheritance Array and Multiset Types in SQL Object Identity and Reference Types in SQL Implementing O-R Features Persistent Programming Languages Comparison of Object-Oriented and Object-Relational Databases

Transaction Concept Transaction State Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL Testing for Serializability