-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
259 lines (239 loc) · 14.6 KB
/
index.html
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Programming and Database Fundamentals for Data Scientists (EAS 503) — EAS503 Programming and Database Fundamentals for Data Scientists 2017 documentation</title>
<link rel="stylesheet" href="_static/alabaster.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: './',
VERSION: '2017',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true,
SOURCELINK_SUFFIX: '.txt'
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<script type="text/javascript" src="https://cdn.mathjax.org/mathjax/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<link rel="index" title="Index" href="genindex.html" />
<link rel="search" title="Search" href="search.html" />
<link rel="stylesheet" href="_static/custom.css" type="text/css" />
<meta name="viewport" content="width=device-width, initial-scale=0.9, maximum-scale=0.9" />
</head>
<body role="document">
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<div class="section" id="programming-and-database-fundamentals-for-data-scientists-eas-503">
<h1>Programming and Database Fundamentals for Data Scientists (EAS 503)<a class="headerlink" href="#programming-and-database-fundamentals-for-data-scientists-eas-503" title="Permalink to this headline">¶</a></h1>
<p><a class="reference external" href="http://www.seas.buffalo.edu/">School of Engineering and Applied Sciences</a>, University at Buffalo</p>
<p>Fall Semester 2017-2018 academic year</p>
<div class="toctree-wrapper compound">
</div>
<div class="section" id="instructors">
<h2>Instructors<a class="headerlink" href="#instructors" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
<li><a class="reference external" href="http://www.cse.buffalo.edu/~chandola">Varun Chandola</a> (lead instructor; chandola[at]buffalo.edu)</li>
<li><a class="reference external" href="http://www.buffalo.edu/directory/user/sreelekh?query=lam&affiliation=&qualifier=general&perpage=10&start=10">Sreelekha Guggilam</a> (teaching assistant; sreelekh[at]buffalo.edu)</li>
</ul>
</div>
<div class="section" id="meeting-times-and-locations">
<h2>Meeting times and locations<a class="headerlink" href="#meeting-times-and-locations" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
<li>Tuesdays: 10.00 AM - 01.00 PM, <a class="reference external" href="https://www.google.com/maps/place/Bell+Hall/@43.0015276,-78.7870329,15z/data=!4m2!3m1!1s0x0:0x2970918a7d62e386?sa=X&ved=0ahUKEwiP9ZXJss_VAhVn8IMKHfx9Dw8Q_BIIbzAK">250 Bell Hall</a>.</li>
<li>Instructor Office Hours: Wednesdays from 10.00 PM - 11.00 PM, 304 Davis Hall..</li>
<li>TA Office Hours: Thursdays from 01.00 PM - 05.00 PM, 250 Bell Hall.</li>
</ul>
</div>
<div class="section" id="prerequisites">
<h2>Prerequisites<a class="headerlink" href="#prerequisites" title="Permalink to this headline">¶</a></h2>
<p>None</p>
</div>
<div class="section" id="course-materials">
<h2>Course materials<a class="headerlink" href="#course-materials" title="Permalink to this headline">¶</a></h2>
<p><a class="reference external" href="http://nbviewer.jupyter.org/github/ubdsgroup/eas503ubcourse/tree/master/notebooks/">Jupyter Notebooks</a></p>
</div>
<div class="section" id="reference-texts">
<h2>Reference Texts<a class="headerlink" href="#reference-texts" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
<li>Python Programming: An Introduction to Computer Science, Zelle [ISBN-10: 1590280288]</li>
<li>Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Database Systems: The Complete Book</li>
</ul>
</div>
<div class="section" id="grading">
<h2>Grading<a class="headerlink" href="#grading" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
<li>Programming Assignments (4) - 10% each</li>
<li>Final Exam - 30%</li>
<li>Final Project - 30%</li>
</ul>
</div>
<div class="section" id="final-exam">
<h2>Final Exam<a class="headerlink" href="#final-exam" title="Permalink to this headline">¶</a></h2>
<p>TBA</p>
</div>
<div class="section" id="class-schedule">
<h2>Class schedule<a class="headerlink" href="#class-schedule" title="Permalink to this headline">¶</a></h2>
<table border="1" class="docutils">
<colgroup>
<col width="3%" />
<col width="62%" />
<col width="35%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">Week</th>
<th class="head">Topic</th>
<th class="head">Homework assigned</th>
</tr>
</thead>
<tbody valign="top">
<tr class="row-even"><td colspan="3"><ul class="first last simple">
<li>Introduction*</li>
</ul>
</td>
</tr>
<tr class="row-odd"><td>1</td>
<td><a class="reference download internal" href="_downloads/CourseIntroduction.pdf" download=""><code class="xref download docutils literal"><span class="pre">Course</span> <span class="pre">Introduction</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td colspan="3"><em>Programming Fundamentals</em></td>
</tr>
<tr class="row-odd"><td>2</td>
<td><a class="reference download internal" href="_downloads/Introduction.pptx" download=""><code class="xref download docutils literal"><span class="pre">Programming</span> <span class="pre">Basics</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td>3</td>
<td><a class="reference download internal" href="_downloads/PythonDataTypes.pdf" download=""><code class="xref download docutils literal"><span class="pre">Data</span> <span class="pre">Types</span></code></a></td>
<td> </td>
</tr>
<tr class="row-odd"><td>4</td>
<td><a class="reference download internal" href="_downloads/ControlStructures.pdf" download=""><code class="xref download docutils literal"><span class="pre">Control</span> <span class="pre">Structures</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td>5</td>
<td><a class="reference download internal" href="_downloads/BuiltinFunctions.pdf" download=""><code class="xref download docutils literal"><span class="pre">Built-in</span> <span class="pre">Functions</span></code></a></td>
<td> </td>
</tr>
<tr class="row-odd"><td>6</td>
<td><a class="reference download internal" href="_downloads/Classes.pdf" download=""><code class="xref download docutils literal"><span class="pre">Classes</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td colspan="3"><em>Database Fundamentals</em></td>
</tr>
<tr class="row-odd"><td>7</td>
<td><a class="reference download internal" href="_downloads/DatabaseIntroduction.pdf" download=""><code class="xref download docutils literal"><span class="pre">Relational</span> <span class="pre">Database</span> <span class="pre">Basics</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td>8</td>
<td><a class="reference download internal" href="_downloads/RelationalAlgebra.ppt" download=""><code class="xref download docutils literal"><span class="pre">Relational</span> <span class="pre">Algebra</span></code></a></td>
<td> </td>
</tr>
<tr class="row-odd"><td>9</td>
<td><a class="reference download internal" href="_downloads/SQL.ppt" download=""><code class="xref download docutils literal"><span class="pre">Using</span> <span class="pre">SQL</span></code></a></td>
<td> </td>
</tr>
<tr class="row-even"><td>10</td>
<td><a class="reference download internal" href="_downloads/Index.ppt" download=""><code class="xref download docutils literal"><span class="pre">Database</span> <span class="pre">Indexes</span></code></a></td>
<td> </td>
</tr>
<tr class="row-odd"><td>11</td>
<td><a class="reference download internal" href="_downloads/PythonSQL.ppt" download=""><code class="xref download docutils literal"><span class="pre">Embedding</span> <span class="pre">SQL</span> <span class="pre">in</span> <span class="pre">Python</span></code></a></td>
<td> </td>
</tr>
</tbody>
</table>
</div>
<div class="section" id="how-to-submit-homeworks">
<h2>How to submit homeworks<a class="headerlink" href="#how-to-submit-homeworks" title="Permalink to this headline">¶</a></h2>
<p>TBA</p>
</div>
<div class="section" id="expectations">
<h2>Expectations<a class="headerlink" href="#expectations" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
<li>Students are expected to act in a professional manner. A student’s grade may be reduced due to unprofessional or disruptive behavior. Examples include coming to class late, texting (or otherwise using your cell phone) during class, your cell phone ringing during class and/or exams, etc.</li>
<li>Homework assignments will be assigned for each module. Homework assignments are due at the beginning of class.</li>
<li>Homework and programming assignments will be graded and returned to students.</li>
<li>Late submission of assignments will receive a grade of zero.</li>
<li>Students are encouraged to discuss assignments and share ideas, but each student must independently write and submit their own solution.</li>
<li>Makeup exams will be given in the following circumstances only:
1. You contact the instructor prior to the exam
2. You have a valid and documented reason to miss the exam</li>
</ul>
</div>
<div class="section" id="accessibility-services-and-special-needs">
<h2>Accessibility Services and Special Needs<a class="headerlink" href="#accessibility-services-and-special-needs" title="Permalink to this headline">¶</a></h2>
<p>If you have a disability and may require some type of instructional and/or examination accommodation, please inform me early in the semester so that we can coordinate the accommodations you may need. If you have not already done so, please contact the Office of Accessibility Services (formerly the Office of Disability Services) University at Buffalo, 25 Capen Hall, Buffalo, NY 14260-1632; email: stu-accessibility@ buffalo.edu Phone: 716-645-2608 (voice); 716-645-2616 (TTY); Fax: 716-645-3116; and on the web at <a class="reference external" href="http://www.buffalo.edu/accessibility/">http://www.buffalo.edu/accessibility/</a>. All information and documentation is confidential. The University at Buffalo and the School of Engineering and Applied Sciences are committed to ensuring equal opportunity for persons with special needs to participate in and benefit from all of its programs, services and activities.</p>
</div>
<div class="section" id="academic-integrity">
<h2>Academic Integrity<a class="headerlink" href="#academic-integrity" title="Permalink to this headline">¶</a></h2>
<p>This course will operate with a zero-tolerance policy regarding cheating and other forms of academic dishonesty. Any act of academic dishonesty will subject the student to penalty, including the high probability of failure of the course (i.e., assignment of a grade of “F”). It is expected that you will behave in an honorable and respectful way as you learn and share ideas. Therefore, recycled papers, work submitted to other courses, and major assistance in preparation of assignments without identifying and acknowledging such assistance are not acceptable. All work for this course must be original for this course. Please be familiar with the University and the School policies regarding plagiarism. Read the Academic Integrity Policy and Procedure for more information: <a class="reference external" href="http://undergrad-catalog.buffalo.edu/policies/course/integrity.shtml">http://undergrad-catalog.buffalo.edu/policies/course/integrity.shtml</a>. Visit the Senior Vice Provost for Academic Affairs web page for the latest information at <a class="reference external" href="http://vpue.buffalo.edu/policies/">http://vpue.buffalo.edu/policies/</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="main navigation">
<div class="sphinxsidebarwrapper">
<h3><a href="#">Table Of Contents</a></h3>
<ul>
<li><a class="reference internal" href="#">Programming and Database Fundamentals for Data Scientists (EAS 503)</a><ul>
<li><a class="reference internal" href="#instructors">Instructors</a></li>
<li><a class="reference internal" href="#meeting-times-and-locations">Meeting times and locations</a></li>
<li><a class="reference internal" href="#prerequisites">Prerequisites</a></li>
<li><a class="reference internal" href="#course-materials">Course materials</a></li>
<li><a class="reference internal" href="#reference-texts">Reference Texts</a></li>
<li><a class="reference internal" href="#grading">Grading</a></li>
<li><a class="reference internal" href="#final-exam">Final Exam</a></li>
<li><a class="reference internal" href="#class-schedule">Class schedule</a></li>
<li><a class="reference internal" href="#how-to-submit-homeworks">How to submit homeworks</a></li>
<li><a class="reference internal" href="#expectations">Expectations</a></li>
<li><a class="reference internal" href="#accessibility-services-and-special-needs">Accessibility Services and Special Needs</a></li>
<li><a class="reference internal" href="#academic-integrity">Academic Integrity</a></li>
</ul>
</li>
</ul>
<div class="relations">
<h3>Related Topics</h3>
<ul>
<li><a href="#">Documentation overview</a><ul>
</ul></li>
</ul>
</div>
<div role="note" aria-label="source link">
<h3>This Page</h3>
<ul class="this-page-menu">
<li><a href="_sources/index.rst.txt"
rel="nofollow">Show Source</a></li>
</ul>
</div>
<div id="searchbox" style="display: none" role="search">
<h3>Quick search</h3>
<form class="search" action="search.html" method="get">
<div><input type="text" name="q" /></div>
<div><input type="submit" value="Go" /></div>
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="footer">
©2017, Varun Chandola.
|
Powered by <a href="http://sphinx-doc.org/">Sphinx 1.5.1</a>
& <a href="https://github.com/bitprophet/alabaster">Alabaster 0.7.9</a>
|
<a href="_sources/index.rst.txt"
rel="nofollow">Page source</a>
</div>
</body>
</html>