Python For Everybody (audio/py4e)

We talk briefly about how applications can be built over time to depend on services provide other applications.

We explore using a Google API that can be used to query location data and parse the JSON that is returned.

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

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.

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.

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.

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.

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

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

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.

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.

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.

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.

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