From a938c94bbfe00b10be0e90b9ee0d9cd7d0634ce1 Mon Sep 17 00:00:00 2001 From: mo khan Date: Sun, 19 Jan 2020 16:03:12 -0700 Subject: Add unit 5 notes --- doc/unit-5.md | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 doc/unit-5.md (limited to 'doc') 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 -- cgit v1.2.3