本文概述了SQL查询语言的基础，包括数据定义语言（DDL），用于定义、删除和修改关系模式；数据操作语言（DML），用于查询信息、插入、删除和修改元组等。此外还介绍了SQL的完整性视图定义、事务控制、授权等功能。
2.2.1 Introduction to SQL
- overview of the SQL Query Language
- Data-definition language(DDL)
defining relation schemas, deleting relation, and modifying relation schemas.
- Date-manipulation language(DML)
query information, insert tuple, delete tuple, modify tuple
- integrity
- view definition
- transaction control
- embedded SQL and dynamic SQL
- authorization
- Data-definition language(DDL)
- SQL Data Definition
- Basic Structure of SQL Queries
- Additional Basic Operations
- Set Operations
- Null Values
- Aggregate Functions
- Nested Subqueries
- Modification of the Database
扫一扫
688
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
