sql-tutorial/index.html at gh-pages · OpenTechSchool/sql-tutorial · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<!doctype html>
<html>

<head>
  <title>Working with SQL databases</title>
  <link rel=stylesheet href="http://fonts.googleapis.com/css?family=Averia+Serif+Libre:300,400">
  <link rel=stylesheet href=style.css>
  <meta http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<body>

<h1>Working with SQL databases</h1>

<p>Welcome to the OTS beginner's course on SQL databases. To get started install the <a href="installationguide.html">required software</a> and download the <a href="databaseOTS.sqlite">database</a> needed to solve the excercises.</p>

<p>If you have done so, you can start with the first part, the <a href="chapter1.html">introduction</a>.</p>

<h2>Chapter overview</h2>


<ol>
<li><a href="chapter1.html">Introduction</a></li>
<li><a href="chapter2.html">SQL basics</a></li>
<li><a href="chapter3.html">The theft of the Mona Lisa</a></li>
<li><a href="chapter4.html">Who was the string puller? - Data quality and aggregation functions</a></li>
<li><a href="chapter5.html">Advanced topics</a></li>
<li><a href="chapter6.html">Entering data</a></li>
</ol>


<h2>Resources</h2>

<p><a href="databaseOTS.sqlite">Sample database (to be opened with sqlite)</a></p>

<p><a href="installationguide.html">Installation guide</a></p>

<p><a href="solutions.html">Solutions to the excercises</a></p>

<p><a href="http://en.wikibooks.org/wiki/Structured_Query_Language">SQL wikibook. Very good.</a></p>

<p><a href="databaseOTS.sql">SQL script to create the sample database <strong>(not required for the tutorial)</strong></a></p>


</body>
</html>