From 4dbf54f9e277fe55354a2598c69859d0c83c3735 Mon Sep 17 00:00:00 2001
From: Greg Wilson <gvwilson@third-bit.com>
Date: Fri, 29 Nov 2013 15:21:39 -0500
Subject: [PATCH] Updating SQL notes and guide

---
 sql/novice/guide.md |  3 +++
 sql/novice/index.md | 25 +++++++++++++++----------
 2 files changed, 18 insertions(+), 10 deletions(-)

diff --git a/sql/novice/guide.md b/sql/novice/guide.md
index 705f9b5..22fb503 100644
--- a/sql/novice/guide.md
+++ b/sql/novice/guide.md
@@ -54,3 +54,6 @@ Teaching Notes
         so we have a better idea of what to teach and how to teach it.
     3.  NoSQL databases are as different from each other as they are from relational databases.
         Until a leader emerges, it isn't clear *which* NoSQL database we should teach.
+
+*   Run `sqlite3 survey.db < gen-survey-database.sql`
+    to re-create survey database before loading notebooks.
diff --git a/sql/novice/index.md b/sql/novice/index.md
index 3d889b7..babcbe7 100644
--- a/sql/novice/index.md
+++ b/sql/novice/index.md
@@ -23,16 +23,21 @@ and why they insist on structuring data in certain ways.
 
 Topics
 ------
-* [Selecting Data](01-select.html)
-* [Sorting and Removing Duplicates](02-sort-dup.html)
-* [Filtering](03-filter.html)
-* [Calculating New Values](04-calc.html)
-* [Missing Data](05-null.html)
-* [Aggregation](06-agg.html)
-* [Combining Data](07-join.html)
-* [Creating and Modifying Data](08-create.html)
-* [Programming with Databases](09-prog.html)
+*   [Selecting Data](01-select.html)
+*   [Sorting and Removing Duplicates](02-sort-dup.html)
+*   [Filtering](03-filter.html)
+*   [Calculating New Values](04-calc.html)
+*   [Missing Data](05-null.html)
+*   [Aggregation](06-agg.html)
+*   [Combining Data](07-join.html)
+*   [Creating and Modifying Data](08-create.html)
+*   [Programming with Databases](09-prog.html)
 
 See Also
 --------
-* [Instructor's Guide](guide.html)
+*   [Instructor's Guide](guide.html)
+
+Resources
+---------
+*   `gen-survey-database.sql`: re-generate survey database used in examples.
+*   `sqlitemagic.py`: IPython Notebook plugin to support SQLite interaction.
-- 
2.26.2