Add unit 5 notes

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