13.1 Data on the Web
2 min
We look at two different ways to format data for transmission across the network including JavaScript Object Notation (JSON) and eXtended Markup Language (XML).
13.2 eXtensible Markup Language (XML)
5 min
We look at how data is represented using the XML format.
13.3 XML Schema
14 min
We look at how we can use XML Schema to determine whether or not a particular bit of XML is valid.
13.4 JavaScript Object Notation
6 min
We learn about the popular JSON data format and how to handle the JSON data in Python.
13.5 Service Oriented Approach (SOA)
2 min
We talk briefly about how applications can be built over time to depend on services provide other applications.
13.6 Using Application Programming Interfaces
7 min
We explore using a Google API that can be used to query location data and parse the JSON that is returned.
13.7 Securing API Requests
10 min
We explore the use of OAuth to communicate sign requests to establish identity when using the Twitter API.
14.1 Object Oriented Definitions and Terminology
10 min
We look at how Python mentions objects in its documentation as well as talk about why philosophy of object-oriented programming. We explore some OOP terms like class, object, instance, method, and attribute.
14.2 Our First Class and Object
8 min
We look at how use create a new class in Python and then construct a new object from that class. We also look at some of the Python objects (like strings) that we have been using all along.
14.3 Object Life Cycle
6 min
We look at how we as the developers of a Python class can interact with the moment of construction and destruction of various objects created using the class.
14.4 Object Inheritance
7 min
We look at how we can make a new class by inheriting all of the attributes and methods of a parent class and then extend the new class with additional attributes and methods.
15.1 Relational Databases
15 min
We look at the history of database systems, learn the terminology of database systems, and review some of the common database systems that are in use.
15.2 Single Table SQL
10 min
We learn about how we can use Structured Query Language (SQL) to insert (create), read, update, and delete data in a single database table.
15.3 Building a Relational Model
8 min
We look at how we can take the various data elements that will be modeled in an application and distribute them across several tables efficiently. We learn about the basic rules of database design.
15.4 Database Key Types
4 min
We look at primary keys, logical keys and foreign keys. We look at how foreign keys are represented in the database.
15.5 Representing Relationships in Database Tables
11 min
We look at how we map a logical database model to a physical database model by adding columns and constraints to model the table-to-table relationships.
15.6 Multi-Table Retrieval using JOIN
10 min
We look at how to reconstruct complete views of the data when data is properly distributed across multiple tables and connected via foreign keys. We learn the JOIN operation and ON clause in SQL.
15.7 Many-to-Many Relationships
13 min
We look at how to build a connector table to represent many-to-many relationships such as students and courses in database tables. We also learn about composite primary keys.
Worked Example: Many-to-Many
21 min
We extend the Twitter example to represent friends using Many-to-Many relationships.
16.1 Visualizing Map Data
6 min
In this assignment we make use of the Google GeoCoding API to look up addresses, store the data in a database and then use Google Maps to visualize the data.
16.2 Building a Web Search Engine
11 min
We build a web crawler that retrieves web pages and links from those pages an copies the pages into the database. Once we have retrieved our web data we run a simple Page Rank algorithm on the data and visualize the results.
16.3 Processing Mail Data
6 min
We end where we started, processing email data. Except that this time it is a lot (nearly 1GB) of email data.
Worked Example: Cleaning and Modelling Mail Data
12 min
Worked Example: Cleaning and Modelling Mail Data