Lecture Slides
| Number |
Date |
Description |
Video |
| Lecture 24 |
Mon, Nov 24 |
Triggers |
|
| Lecture 23 |
Wed, Nov 19 |
Views and Functions |
|
| Lecture 22 |
Mon, Nov 17 |
Webscraping and APIs |
|
| Lecture 21 |
Wed, Nov 12 |
Shapefiles |
|
| Lecture 20 |
Mon, Nov 10 |
GIS Types |
|
| Lecture 19 |
Wed, Nov 5 |
Text Mining |
|
| Lecture 18 |
Mon, Nov 3 |
Regular Expressions |
|
| Lecture 17 |
Mon, Oct 27 |
Pivot Tables |
|
| Lecture 16 |
Wed, Oct 22 |
Subqueries |
|
| Lecture 15 |
Mon, Oct 20 |
Window Functions |
|
| Lecture 14 |
Wed, Oct 15 |
Timing |
|
| Lecture 13 |
Mon, Oct 13 |
Transactions |
|
| Lecture 12 |
Wed, Oct 8 |
Data Cleaning |
|
| Lecture 11 |
Mon, Oct 6 |
Grouping Up! |
|
| Lecture 10 |
Wed, Oct 1 |
Examining Indexes |
|
| Lecture 9 |
Mon, Sep 29 |
How Constraining |
|
| Lecture 8 |
Mon, Sep 22 |
More Complicated Joins |
|
| Lecture 7 |
Wed, Sep 17 |
Basic Joins |
|
| Lecture 6 |
Mon, Sep 15 |
Aggregates |
|
| Lecture 5 |
Wed, Sep 10 |
Calculations |
|
| Lecture 4 |
Mon, Sep 8 |
Imports and Exports |
|
| Lecture 3 |
Wed, Sep 3 |
Data Types |
|
| Lecture 2 |
Wed, Aug 27 |
Being Selective |
|
| Lecture 1 |
Mon, Aug 25 |
Relational Databases |
|