Skip to content

Commit

Permalink
Regenerating
Browse files Browse the repository at this point in the history
  • Loading branch information
gvwilson committed May 15, 2015
1 parent b00ac86 commit 13ea431
Show file tree
Hide file tree
Showing 3 changed files with 42 additions and 12 deletions.
4 changes: 2 additions & 2 deletions index.html
Original file line number Diff line number Diff line change
Expand Up @@ -32,11 +32,11 @@ <h1 class="title">Databases and SQL</h1>
<p>Three common options for storage are text files, spreadsheets, and databases. Text files are easiest to create, and work well with version control, but then we would have to build search and analysis tools ourselves. Spreadsheets are good for doing simple analyses, but they don’t handle large or complex data sets well. Databases, however, include powerful tools for search and analysis, and can handle large, complex data sets. These lessons will show how to use a database to explore the expeditions’ data.</p>
<div id="prerequisites" class="prereq panel panel-warning">
<div class="panel-heading">
<h2 id="prerequisites" class="prereq panel panel-warning"><span class="glyphicon glyphicon-education"></span>Prerequisites</h2>
<h2><span class="glyphicon glyphicon-education"></span>Prerequisites</h2>
</div>
<div class="panel-body">
<p>If SQLite is being used from the shell, learners will need to be able to navigate directories and run simple commands from the command line. If a GUI such as the Firefox SQLite plugin is being used, learners will need to know how to install browser plugins (and have permission to do so).</p>
<p>Check the <a href="discussion.html">discussion page</a> for database setup instructions</p>
<p>Check <a href="discussion.html">Discussion</a> for database setup instructions</p>
</div>
</div>
<h2 id="topics">Topics</h2>
Expand Down
32 changes: 28 additions & 4 deletions motivation.html
Original file line number Diff line number Diff line change
Expand Up @@ -27,14 +27,38 @@ <h1 class="var-title"></h1>
</div>

<!-- Begin slides. Just make elements with a class of slide. -->
<section id="why-use-sql-and-databases" class="slide level2">
<h1>Why use SQL and Databases?</h1>
<p>Handling complex or large-volume data can outstrip the capabilities of spreadsheets or plain text files.</p>
<section id="how-to-store-data" class="slide level2">
<h1>How to Store Data?</h1>
<p>Three common options for storage are text files, spreadsheets, and databases.</p>
</section>
<section id="text" class="slide level2">
<h1>Text</h1>
<ul>
<li>Easy to create, work well with version control</li>
<li>But then we have to build search and analysis tools ourselves</li>
</ul>
</section>
<section id="spreadsheets" class="slide level2">
<h1>Spreadsheets</h1>
<ul>
<li>Good for simple analyses</li>
<li>But don’t handle large or complex data sets well</li>
</ul>
</section>
<section id="databases" class="slide level2">
<h1>Databases</h1>
<blockquote>
<h3>database (dā’tə-bās’) noun</h3>
<p>“A collection of data arranged for ease and speed of search and retrieval by a computer” - The American Heritage® Science Dictionary</p>
</blockquote>
<ul>
<li>Include powerful tools for search and analysis</li>
<li>Can handle large, complex data sets.</li>
</ul>
</section>
<section id="next-steps" class="slide level2">
<h1>Next Steps</h1>
<p><a href="01-select.html">Here we go!</a></p>
<!-- A more cogent discussion would be good here -->
</section>
<!-- End slides. -->

Expand Down
18 changes: 12 additions & 6 deletions motivation.md
Original file line number Diff line number Diff line change
Expand Up @@ -3,23 +3,29 @@ layout: slides
title: Databases and SQL
subtitle: Motivation
---
## How to Store Data?

## Why use SQL and Databases?
Three common options for storage are text files, spreadsheets, and databases.

Three common options for storage are text files, spreadsheets, and databases. Text files are easiest to create, and work well with version control, but then we would have to build search and analysis tools ourselves. Spreadsheets are good for doing simple analyses, but they don’t handle large or complex data sets well. Databases, however, include powerful tools for search and analysis, and can handle large, complex data sets. These lessons will show how to use a database to explore the expeditions’ data.
## Text

## The Problem
* Easy to create, work well with version control
* But then we have to build search and analysis tools ourselves

We want to store information in a way that will make search and analysis easy.
## Spreadsheets

* Good for simple analyses
* But don't handle large or complex data sets well

## Databases

> ### database (dā'tə-bās') noun {.callout}
> "A collection of data arranged for ease and speed of search and retrieval by a computer"
> - The American Heritage® Science Dictionary
* Include powerful tools for search and analysis
* Can handle large, complex data sets.

## Next Steps

[Here we go!](01-select.html)

<!-- A more cogent discussion would be good here -->

0 comments on commit 13ea431

Please sign in to comment.