Alle episoder

We explore the use of OAuth to communicate sign requests to establish identity when using the Twitter API.

Worked Example: Twitter and OAuth

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 ...

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 str...

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 th...

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...

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.

We learn about how we can use Structured Query Language (SQL) to insert (create), read, update, and delete data in a single database table.

We retrieve and store Twotter data in a database.

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...

We look at primary keys, logical keys and foreign keys. We look at how foreign keys are represented in the database.

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 relationship...

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 ...

We work through a track data example with four tables.

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 abou...

We extend the Twitter example to represent friends using Many-to-Many relationships.

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 th...

Worked Example: Retrieving Geocoded Data

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...

Worked Example: A Web Crawler

Worked Example: Running PageRank

Worked Example: Visualizing PageRank

We end where we started, processing email data. Except that this time it is a lot (nearly 1GB) of email data.

Worked Example: Retrieving Email Data

Worked Example: Cleaning and Modelling Mail Data

Worked Example: Visualizing Mail Data