Skip to content

Commit 217807b

Browse files
meatballsmeatballs
committed
Rebuild site
1 parent 9d18d95 commit 217807b

17 files changed

Lines changed: 115 additions & 319 deletions

File tree

‎chapters/01/index.html‎

Lines changed: 0 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -165,18 +165,6 @@ <h1 id="Create-A-Database">Create A Database<a class="anchor-link" href="#Create
165165
</footer>
166166

167167

168-
<script>
169-
((window.gitter = {}).chat = {}).options = {
170-
room: 'sql_python_tutorial/Lobby'
171-
};
172-
</script>
173-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
174-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
175-
crossorigin="anonymous"></script>
176-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
177-
crossorigin="anonymous"></script>
178-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
179-
crossorigin="anonymous"></script>
180168
</body>
181169

182170
</html>

‎chapters/02/index.html‎

Lines changed: 57 additions & 69 deletions
Large diffs are not rendered by default.

‎chapters/03/index.html‎

Lines changed: 6 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -93,8 +93,8 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
9393
<p>To add data, we use an 'INSERT' statment.</p>
9494
<p>We specify the columns for which we have data and then the values for the record we want to create.</p>
9595
<p>In our case, we'll provide values for the flight name, timestamp and the teperature, pressure and humidity readings but we'll leave the accelerometer columns to have the default value of 0:</p>
96-
<div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">readings</span><span class="p">(</span><span class="n">flight</span><span class="p">,</span> <span class="n">ts</span><span class="p">,</span> <span class="n">temp</span><span class="p">,</span> <span class="n">pressure</span><span class="p">,</span> <span class="n">humidity</span><span class="p">)</span>
97-
<span class="k">VALUES</span> <span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span> <span class="s1">&#39;2015-01-01 09:00:00&#39;</span><span class="p">,</span> <span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">1020</span><span class="p">,</span> <span class="mi">40</span><span class="p">)</span>
96+
<div class="highlight"><pre><span></span><span class="k">INSERT</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="n">readings</span><span class="p">(</span><span class="n">flight</span><span class="p">,</span><span class="w"> </span><span class="n">ts</span><span class="p">,</span><span class="w"> </span><span class="n">temp</span><span class="p">,</span><span class="w"> </span><span class="n">pressure</span><span class="p">,</span><span class="w"> </span><span class="n">humidity</span><span class="p">)</span><span class="w"></span>
97+
<span class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;2015-01-01 09:00:00&#39;</span><span class="p">,</span><span class="w"> </span><span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">1020</span><span class="p">,</span><span class="w"> </span><span class="mi">40</span><span class="p">)</span><span class="w"></span>
9898
</pre></div>
9999
<p>Let's execute that statement:</p>
100100

@@ -142,10 +142,10 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
142142
</div><div class="inner_cell">
143143
<div class="text_cell_render border-box-sizing rendered_html">
144144
<p>A single INSERT statement can create multiple records:</p>
145-
<div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">readings</span><span class="p">(</span><span class="n">flight</span><span class="p">,</span> <span class="n">ts</span><span class="p">,</span> <span class="n">temp</span><span class="p">,</span> <span class="n">pressure</span><span class="p">,</span> <span class="n">humidity</span><span class="p">)</span>
146-
<span class="k">VALUES</span>
147-
<span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span> <span class="s1">&#39;2015-01-01 09:01:00&#39;</span><span class="p">,</span> <span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">1019</span><span class="p">,</span> <span class="mi">40</span><span class="p">),</span>
148-
<span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span> <span class="s1">&#39;2015-01-01 09:02:00&#39;</span><span class="p">,</span> <span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">1019</span><span class="p">,</span> <span class="mi">41</span><span class="p">)</span>
145+
<div class="highlight"><pre><span></span><span class="k">INSERT</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="n">readings</span><span class="p">(</span><span class="n">flight</span><span class="p">,</span><span class="w"> </span><span class="n">ts</span><span class="p">,</span><span class="w"> </span><span class="n">temp</span><span class="p">,</span><span class="w"> </span><span class="n">pressure</span><span class="p">,</span><span class="w"> </span><span class="n">humidity</span><span class="p">)</span><span class="w"></span>
146+
<span class="k">VALUES</span><span class="w"></span>
147+
<span class="w"> </span><span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;2015-01-01 09:01:00&#39;</span><span class="p">,</span><span class="w"> </span><span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">1019</span><span class="p">,</span><span class="w"> </span><span class="mi">40</span><span class="p">),</span><span class="w"></span>
148+
<span class="w"> </span><span class="p">(</span><span class="s1">&#39;hab1&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;2015-01-01 09:02:00&#39;</span><span class="p">,</span><span class="w"> </span><span class="mi">25</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">1019</span><span class="p">,</span><span class="w"> </span><span class="mi">41</span><span class="p">)</span><span class="w"></span>
149149
</pre></div>
150150
<p>Let's execute this statment too so that our table has three records in total:</p>
151151

@@ -274,18 +274,6 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
274274
</footer>
275275

276276

277-
<script>
278-
((window.gitter = {}).chat = {}).options = {
279-
room: 'sql_python_tutorial/Lobby'
280-
};
281-
</script>
282-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
283-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
284-
crossorigin="anonymous"></script>
285-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
286-
crossorigin="anonymous"></script>
287-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
288-
crossorigin="anonymous"></script>
289277
</body>
290278

291279
</html>

‎chapters/04/index.html‎

Lines changed: 0 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -247,18 +247,6 @@ <h1 id="Look-At-The-Data">Look At The Data<a class="anchor-link" href="#Look-At-
247247
</footer>
248248

249249

250-
<script>
251-
((window.gitter = {}).chat = {}).options = {
252-
room: 'sql_python_tutorial/Lobby'
253-
};
254-
</script>
255-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
256-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
257-
crossorigin="anonymous"></script>
258-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
259-
crossorigin="anonymous"></script>
260-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
261-
crossorigin="anonymous"></script>
262250
</body>
263251

264252
</html>

‎chapters/05/index.html‎

Lines changed: 5 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -177,14 +177,14 @@ <h1 id="Change-The-Data">Change The Data<a class="anchor-link" href="#Change-The
177177
</div><div class="inner_cell">
178178
<div class="text_cell_render border-box-sizing rendered_html">
179179
<p>In an UPDATE statement, we define the table containing the records we want to change, the columns we want to change and the new values for those columns:</p>
180-
<div class="highlight"><pre><span></span><span class="k">UPDATE</span> <span class="n">readings</span>
181-
<span class="k">SET</span> <span class="n">pressure</span> <span class="o">=</span> <span class="mi">1021</span><span class="p">,</span> <span class="n">humidity</span> <span class="o">=</span> <span class="mi">42</span>
180+
<div class="highlight"><pre><span></span><span class="k">UPDATE</span><span class="w"> </span><span class="n">readings</span><span class="w"></span>
181+
<span class="k">SET</span><span class="w"> </span><span class="n">pressure</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">1021</span><span class="p">,</span><span class="w"> </span><span class="n">humidity</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">42</span><span class="w"></span>
182182
</pre></div>
183183
<p>If we were to run this statement, it would update all the records in our table.</p>
184184
<p>Let's imagine we only wanted to change one of them. To do that, we need to include a 'WHERE' clause:</p>
185-
<div class="highlight"><pre><span></span><span class="k">UPDATE</span> <span class="n">readings</span>
186-
<span class="k">SET</span> <span class="n">pressure</span> <span class="o">=</span> <span class="mi">1021</span><span class="p">,</span> <span class="n">humidity</span> <span class="o">=</span> <span class="mi">42</span>
187-
<span class="k">WHERE</span> <span class="n">flight</span> <span class="o">=</span> <span class="s1">&#39;hab1&#39;</span> <span class="k">and</span> <span class="n">humidity</span> <span class="o">=</span> <span class="mi">41</span>
185+
<div class="highlight"><pre><span></span><span class="k">UPDATE</span><span class="w"> </span><span class="n">readings</span><span class="w"></span>
186+
<span class="k">SET</span><span class="w"> </span><span class="n">pressure</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">1021</span><span class="p">,</span><span class="w"> </span><span class="n">humidity</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">42</span><span class="w"></span>
187+
<span class="k">WHERE</span><span class="w"> </span><span class="n">flight</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="s1">&#39;hab1&#39;</span><span class="w"> </span><span class="k">and</span><span class="w"> </span><span class="n">humidity</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">41</span><span class="w"></span>
188188
</pre></div>
189189
<p>Let's execute this statement and use pandas to show us the updated result:</p>
190190

@@ -376,18 +376,6 @@ <h1 id="Change-The-Data">Change The Data<a class="anchor-link" href="#Change-The
376376
</footer>
377377

378378

379-
<script>
380-
((window.gitter = {}).chat = {}).options = {
381-
room: 'sql_python_tutorial/Lobby'
382-
};
383-
</script>
384-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
385-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
386-
crossorigin="anonymous"></script>
387-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
388-
crossorigin="anonymous"></script>
389-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
390-
crossorigin="anonymous"></script>
391379
</body>
392380

393381
</html>

‎chapters/06/index.html‎

Lines changed: 0 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -416,18 +416,6 @@ <h1 id="Delete-Some-Data">Delete Some Data<a class="anchor-link" href="#Delete-S
416416
</footer>
417417

418418

419-
<script>
420-
((window.gitter = {}).chat = {}).options = {
421-
room: 'sql_python_tutorial/Lobby'
422-
};
423-
</script>
424-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
425-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
426-
crossorigin="anonymous"></script>
427-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
428-
crossorigin="anonymous"></script>
429-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
430-
crossorigin="anonymous"></script>
431419
</body>
432420

433421
</html>

‎chapters/07/index.html‎

Lines changed: 1 addition & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -141,7 +141,7 @@ <h1 id="Dynamic-SQL">Dynamic SQL<a class="anchor-link" href="#Dynamic-SQL">&#182
141141
<div class="prompt input_prompt">In&nbsp;[3]:</div>
142142
<div class="inner_cell">
143143
<div class="input_area">
144-
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">from</span> <span class="nn">collections</span> <span class="k">import</span> <span class="n">namedtuple</span>
144+
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">from</span> <span class="nn">collections</span> <span class="kn">import</span> <span class="n">namedtuple</span>
145145

146146
<span class="n">Reading</span> <span class="o">=</span> <span class="n">namedtuple</span><span class="p">(</span><span class="s1">&#39;Reading&#39;</span><span class="p">,</span> <span class="s1">&#39;flight, ts, temp, pressure, humidity&#39;</span><span class="p">)</span>
147147

@@ -325,18 +325,6 @@ <h1 id="Dynamic-SQL">Dynamic SQL<a class="anchor-link" href="#Dynamic-SQL">&#182
325325
</footer>
326326

327327

328-
<script>
329-
((window.gitter = {}).chat = {}).options = {
330-
room: 'sql_python_tutorial/Lobby'
331-
};
332-
</script>
333-
<script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer></script>
334-
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN"
335-
crossorigin="anonymous"></script>
336-
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
337-
crossorigin="anonymous"></script>
338-
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
339-
crossorigin="anonymous"></script>
340328
</body>
341329

342330
</html>

0 commit comments

Comments
 (0)