Python for Everybody (Audio/PY4E)

57 episodes - English - Latest episode: over 7 years ago - ★★★★★ - 55 ratings

These are the audio lectures to supplement the textbook 'Python for Everybody: Exploring Information' and its associated web site www.py4e.com. There is also a video podcast of this material.

How To Education Technology python python3 py4e intro introductory beginning data datamining programming
Homepage Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Episodes

15.4 Database Key Types

September 29, 2016 01:00 - 4 minutes - 245 Bytes

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

September 29, 2016 00:00 - 11 minutes - 691 Bytes

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

September 28, 2016 23:00 - 10 minutes - 629 Bytes

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

September 28, 2016 22:00 - 13 minutes - 793 Bytes

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.

16.1 Visualizing Map Data

September 28, 2016 21:00 - 6 minutes - 403 Bytes

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

September 28, 2016 20:00 - 11 minutes - 684 Bytes

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

September 28, 2016 19:00 - 6 minutes - 418 Bytes

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