Table of Contents
SQL: Data Definition Views Integrity Constraints
Updates
SQL is More Than Just a Query Language
Creating Relations
Destroying and Altering Relations
Creating and Destroying Indexes
Integrity Constraints
Integrity Constraints (Review)
Primary and Candidate Keys (Review)
Primary and Candidate Keys (Review)
Foreign Keys (Review)
General Constraints
Constraints Over Multiple Relations
SQL DML: Inserting New Records
SQL DML: Deleting Records
Modifying Records
Enforcing Referential Integrity
Referential Integrity in SQL/92
Views
Queries on Views
Updates on Views
Updatable Views
Advantages of Views
GRANT and REVOKE of Privileges
Grant and Revoke (continued)
Varying granularity of security control
Summary of SQL’s DDL
Summary (Contd.)
|