本章主要介绍了结构化查询语言SQLSQL 是对数据库中的数据进行组织、管理和检索 的工具。SQL语言是使用关系模型的数据库 应用语言,本章以VFP为基础讲述SQL的基 本概念及其语句的基本用法

▪ 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）

Transaction-Processing Monitors Transactional Workflows High-Performance Transaction Systems Main memory databases Real-Time Transaction Systems Long-Duration Transactions Transaction management in multidatabase systems

Temporal Data Spatial and Geographic Databases Multimedia Databases Mobility and Personal Databases

Performance Tuning Performance Benchmarks Standardization E-Commerce Legacy Systems

Structure of XML Data XML Document Schema Querying and Transformation Application Program Interfaces to XML Storage of XML Data XML Applications

Relevance Ranking Using Terms Relevance Using Hyperlinks Synonyms., Homonyms, and Ontologies Indexing of Documents Measuring Retrieval Effectiveness Web Search Engines Information Retrieval and Structured Data Directories

Decision Support Systems Data Warehousing Data Mining Classification Association Rules Clustering