Overview of The SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database

The Need for Databases Data Models Relational Databases Database Design Storage Manager Query Processing Transaction Manager [美] 西尔伯沙茨（Abrahm Silberschatz），[美] 科思（Henry F.Korth），[美] 苏达尔（S.Sudarshan） Database System Concepts Sixth Edition Avi Silberschatz Henry F. Korth S. Sudarshan McGraw-Hill ISBN 0-07-352332-1 Face The Real World of Database Systems Fully Equipped

《数据库系统概念 Database System Concepts》原书教学资源（第六版，附录，英文版）Network Model

《数据库系统概念 Database System Concepts》原书教学资源（第六版，附录，英文版）Advanced Relational Database Design

《数据库系统概念 Database System Concepts》原书教学资源（第五版，PPT课件讲稿，英文版）Chapter 24 Advanced Data Types

Heterogeneous and Homogeneous Databases Distributed Data Storage Distributed Transactions Commit Protocols Concurrency Control in Distributed Databases Availability Distributed Query Processing Heterogeneous Distributed Databases Directory Systems

Centralized and Client-Server Systems Server System Architectures Parallel Systems Distributed Systems Network Types

Decision Support Systems Data Analysis and OLAP Data Warehousing Data Mining

Lock-Based Protocols Timestamp-Based Protocols Validation-Based Protocols Multiple Granularity Multiversion Schemes Insert and Delete Operations Concurrency in Index Structures

Introduction Transformation of Relational Expressions Catalog Information for Cost Estimation Statistical Information for Cost Estimation Cost-based optimization Dynamic Programming for Choosing Evaluation Plans Materialized views