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