From 27c1f8280cdec309fdda0a3adc1b98f668038262 Mon Sep 17 00:00:00 2001 From: Greg Wilson Date: Fri, 29 Nov 2013 10:15:17 -0500 Subject: [PATCH] Updating index files W. Trevor King: I removed everything except the sql/novice changes from the original b23e277 [1]. [1]: https://github.com/swcarpentry/bc/commit/b23e2772153844b1d8e1ee09b439653847a05ede --- sql/novice/index.md | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 sql/novice/index.md diff --git a/sql/novice/index.md b/sql/novice/index.md new file mode 100644 index 0000000..aaa8ac5 --- /dev/null +++ b/sql/novice/index.md @@ -0,0 +1,34 @@ +--- +layout: lesson +root: ../.. +title: Using Databases and SQL +level: novice +--- +Almost everyone has used spreadsheets, +and almost everyone has eventually run up against their limitations. +The more complicated a data set is, +the harder it is to filter data, +express relationships between different rows and columns, +or handle missing values. + +Databases pick up where spreadsheets leave off. +While they are not as simple to use if all we want is the sum of a dozen numbers, +they can do a lot of things that spreadsheets can't, +on much larger data sets, +faster. +And even if we never need to create a database ourselves, +knowing how they work will help us understand why so many of the systems we use +behave the way we do, +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) -- 2.26.2