diff options
| -rw-r--r-- | doc/unit-5.md | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/doc/unit-5.md b/doc/unit-5.md new file mode 100644 index 0000000..142015c --- /dev/null +++ b/doc/unit-5.md @@ -0,0 +1,32 @@ +# Unit 5 + +Labs 2: Tables, Views, SQL Queries and Triggers + +## Section 1: SQL as a Data Definition Language (DDL) + +Read Chapter 6: Introduction to SQL + +* Origins of the SQL standard +* The SQL Environment +* Defining a database in SQL + +## Section 2: SQL as a Data Manipulation Language (DML) + +Read Chapter 6: Introduction to SQL + +* "Inserting, updating and deleting data" +* "Internal schema definition in RDBMS's" +* "Processing single tables" + +Terms: + +* scalar aggregate +* vector aggregate +* virtual table +* dynamic view +* materialized view + +## Section 3: Advanced SQL and Data Control Commands + +Read Chapter 7: Advanced SQL +* all sections |