1+ <!DOCTYPE html>
2+ < html lang ="en ">
3+ < head >
4+ < meta charset ="utf-8 ">
5+ < meta name ="viewport " content ="width=device-width, initial-scale=1, shrink-to-fit=no ">
6+ < link href ="http://www.owencampbell.me.uk/images/favicon/favicon.ico " rel ="icon ">
7+
8+ < title > SQL for Python Programmers</ title >
9+
10+ < link rel ="stylesheet " href ="https://stackpath.bootstrapcdn.com/bootstrap/4.1.0/css/bootstrap.min.css ">
11+ < link href ="http://www.owencampbell.me.uk/theme/css/font-awesome.min.css " rel ="stylesheet ">
12+ < link rel ="stylesheet " href ="http://owencampbell.me.uk/sql_python_tutorial/static/styles.css ">
13+
14+
15+ < link rel ="stylesheet " href ="http://owencampbell.me.uk/sql_python_tutorial/static/notebook.css ">
16+
17+ </ head >
18+
19+ < body >
20+ < nav class ="navbar navbar-expand-md navbar-dark fixed-top bg-dark ">
21+
22+ < a class ="navbar-brand " href ="# "> SQL for Python Programmers</ a >
23+
24+ < button class ="navbar-toggler " type ="button " data-toggle ="collapse " data-target ="#navbarContent " aria-controls ="navbarContent " aria-expanded ="false " aria-label ="Toggle navigation ">
25+ < span class ="navbar-toggler-icon "> </ span >
26+ </ button >
27+
28+ < div class ="collapse navbar-collapse " id ="navbarContent ">
29+ < div class ="navbar-nav ">
30+ < a class ="nav-item nav-link " href ="/sql_python_tutorial/ "> < i class ="fa fa-home fa-fw " aria-hidden ="true " title ="home "> </ i > Home</ a >
31+ < a class ="nav-item nav-link mr-auto " href ="/sql_python_tutorial/chapters/ "> < i class ="fa fa-book fa-fw " aria-hidden ="true " title ="contents "> </ i > Contents</ a >
32+ < a class ="nav-item nav-link " href ="/sql_python_tutorial/pages/intro "> < i class ="fa fa-info-circle fa-fw " aria-hidden ="true " title ="introduction "> </ i > Introduction</ a >
33+ < a class ="nav-item nav-link " href ="/sql_python_tutorial/pages/howto "> < i class ="fa fa-gears fa-fw " aria-hidden ="true " title ="how to "> </ i > How To</ span > </ a >
34+ <!-- <a class="nav-item nav-link" href="/sql_python_tutorial/pages/primer"><i class="fa fa-database fa-fw" aria-hidden="true" title="primer"></i> Primer</a> -->
35+ </ div >
36+ < div class ="navbar-nav ml-auto ">
37+ < a class ="btn btn-link btn-lg " href ="https://twitter.com/opcampbell " title ="twitter "> < i class ="fa fa-twitter " aria-hidden ="true "> </ i > </ a >
38+ < a class ="btn btn-link btn-lg " href ="https://www.linkedin.com/in/owencampbell " title ="linkedin "> < i class ="fa fa-linkedin " aria-hidden ="true "> </ i > </ a >
39+ < a class ="btn btn-link btn-lg " href ="http://github.com/meatballs " title ="github "> < i class ="fa fa-github " aria-hidden ="true "> </ i > </ a >
40+ </ div >
41+ </ div >
42+ </ nav >
43+
44+ < main role ="main " class ="container ">
45+
46+ < div class ="row mt-3 mb-3 ">
47+ < div class ="col-sm ">
48+
49+ < a class ="btn btn-outline-primary btn-sm " href ="../10/ "> < i class ="fa fa-backward fa-fw " aria-hidden ="true "> </ i > Previous</ a >
50+
51+
52+ < span class ="float-right "> < a class ="btn btn-outline-primary btn-sm " href ="../12_Bulk/ "> Next < i class ="fa fa-forward fa-fw " aria-hidden ="true "> </ i > </ a > </ span >
53+
54+ </ div >
55+ </ div >
56+
57+ < div class ="row ">
58+ < div class ="col-sm-12 ">
59+ < div class ="cell border-box-sizing text_cell rendered "> < div class ="prompt input_prompt ">
60+ </ div >
61+ < div class ="inner_cell ">
62+ < div class ="text_cell_render border-box-sizing rendered_html ">
63+ < h1 id ="Create-A-View "> Create A View< a class ="anchor-link " href ="#Create-A-View "> ¶</ a > </ h1 >
64+ </ div >
65+ </ div >
66+ </ div >
67+
68+
69+ </ div >
70+ </ div >
71+
72+ < div class ="row mt-3 mb-3 ">
73+ < div class ="col-sm ">
74+
75+ < a class ="btn btn-outline-primary btn-sm " href ="../10/ "> < i class ="fa fa-backward fa-fw " aria-hidden ="true "> </ i > Previous</ a >
76+
77+
78+ < span class ="float-right "> < a class ="btn btn-outline-primary btn-sm " href ="../12_Bulk/ "> Next < i class ="fa fa-forward fa-fw " aria-hidden ="true "> </ i > </ a > </ span >
79+
80+ </ div >
81+ </ div >
82+
83+ </ main >
84+
85+
86+
87+ < footer class ="footer ">
88+ < div class ="container ">
89+ < span class ="text-muted ">
90+ < p class ="small ">
91+ This tutorial was inspired by a talk given by Dave Jones at < a href ="https://twitter.com/pythonnw "> Python North West</ a > .
92+ The flights database, and much of the SQL code, is taken, with grateful thanks,
93+ from the < a href ="https://waveform.org.uk/presentations/sql "> slides</ a > and
94+ < a href ="https://github.com/waveform80/presentations "> source code</ a > for that talk.
95+ < br />
96+ Many thanks also to < a href ="https://vknight.org/ "> Dr. Vincent Knight</ a > of < a href ="http://www.cardiff.ac.uk "> Cardiff University</ a > for the use of his
97+ < a href ="https://vknight.org/gt/ "> Game Theory Course Notes</ a > and their < a href ="https://github.com/drvinceknight/gt "> source code</ a > .
98+ </ p >
99+ </ span >
100+ </ div >
101+ </ footer >
102+
103+
104+ < script >
105+ ( ( window . gitter = { } ) . chat = { } ) . options = {
106+ room : 'sql_python_tutorial/Lobby'
107+ } ;
108+ </ script >
109+ < script src ="https://sidecar.gitter.im/dist/sidecar.v1.js " async defer > </ script >
110+ < script src ="https://code.jquery.com/jquery-3.2.1.slim.min.js " integrity ="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN " crossorigin ="anonymous "> </ script >
111+ < script src ="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js " integrity ="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q " crossorigin ="anonymous "> </ script >
112+ < script src ="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js " integrity ="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl " crossorigin ="anonymous "> </ script >
113+ </ body >
114+ </ html >
0 commit comments