index.html

<HTML>
<HEAD>
   <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
   <META NAME="Author" CONTENT="Bobo">
   <META NAME="GENERATOR" CONTENT="Mozilla/4.04 [en] (Win95; I) [Netscape]">
   <TITLE>SQL</TITLE>
</HEAD>

<!-- Using to include HTML from other files -->
<script src="http://www.w3schools.com/lib/w3data.js"></script>

<BODY>

<h1>SQL Workshop</h1>

Updated: Fri May  4 09:59:46 PDT 2018

<br>
<br>

Download and install this software:
<a href="http://sqlitebrowser.org/">http://sqlitebrowser.org/</a>

<br>
<br>

Download this database:
<a href="stocks.sqlite">stocks.sqlite</a> (~ 40 MB)

<br>
<br>

Day 3 Questions
<a href="day3_questions.pdf">day3_questions.pdf</a>

<br>
<br>

Day 3 Solutions
<a href="day3_solutions.pdf">day3_solutions.pdf</a>

<br>
<br>


Day 2 Questions
<a href="day2_questions.pdf">day2_questions.pdf</a>

<br>
<br>

Day 2 Solutions
<a href="day2_solutions.pdf">day2_solutions.pdf</a>

<br>
<br>


Day 1 Questions
<a href="day1_questions.pdf">day1_questions.pdf</a>

<br>
<br>

Day 1 Solutions
<a href="day1_solutions.pdf">day1_solutions.pdf</a>

<br>
<br>

<a href="https://docs.google.com/presentation/d/1mLDoKMtlt90U98jfB6A00nRuiMA4POXp6c_g7YORRMM/edit?usp=sharing">Slides Explaining Joins</a>

<br>
<br>

Notes Explaining Joins
<a href="join_notes.pdf">join_notes.pdf</a>

<br>
<br>

Cheatsheet
<a href="sql_cheatsheet.pdf">sql_cheatsheet.pdf</a>

<br>
<br>

Reference
<a href="http://swcarpentry.github.io/sql-novice-survey/">http://swcarpentry.github.io/sql-novice-survey/</a>

<br>
<br>

To take your skills to the next level, including some theory, this is a great free online class from Stanford:
<a href="https://lagunita.stanford.edu/courses/Home/Databases/Engineering/about">https://lagunita.stanford.edu/courses/Home/Databases/Engineering/about</a>

<br>
<br>


</BODY>
</HTML>