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

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 09 Application Development

▪ Semi-Structured Data ▪ Object Orientation ▪ Textual Data ▪ Spatial Data

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 06 Database Design Using the E-R Model

▪ Accessing SQL From a Programming Language ▪ Functions and Procedures ▪ Triggers ▪ Recursive Queries ▪ Advanced Aggregation Features

▪ Join Expressions ▪ Views ▪ Transactions ▪ Integrity Constraints ▪ SQL Data Types and Schemas ▪ Index Definition in SQL ▪ Authorization

▪ Structure of Relational Databases ▪ Database Schema ▪ Keys ▪ Schema Diagrams ▪ Relational Query Languages ▪ The Relational Algebra

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 01 Introduction（Avi Silberschatz Henry F. Korth S. Sudarshan）