From 4dbf54f9e277fe55354a2598c69859d0c83c3735 Mon Sep 17 00:00:00 2001 From: Greg Wilson 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