Python for Everybody (Video/PY4E) show

Python for Everybody (Video/PY4E)

Summary: These are the video lectures to supplement the textbook 'Python for Everybody: Exploring Information' and its associated web site www.py4e.com

Join Now to Subscribe to this Podcast
  • Visit Website
  • RSS
  • Artist: Dr. Charles Russell Severance
  • Copyright: Dr. Charles R. Severance, CC-BY-NC

Podcasts:

 15.4 Database Key Types | File Type: audio/mpeg | Duration: 245

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

 15.4 Database Key Types | File Type: audio/mpeg | Duration: 245

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

 15.4 Database Key Types | File Type: audio/mpeg | Duration: 245

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 | File Type: audio/mpeg | Duration: 691

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.5 Representing Relationships in Database Tables | File Type: audio/mpeg | Duration: 691

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.5 Representing Relationships in Database Tables | File Type: audio/mpeg | Duration: 691

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 | File Type: audio/mpeg | Duration: 629

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.6 Multi-Table Retrieval using JOIN | File Type: audio/mpeg | Duration: 629

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.6 Multi-Table Retrieval using JOIN | File Type: audio/mpeg | Duration: 629

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.

 Worked Example: Multiple Tracks | File Type: audio/mpeg | Duration: 838

We work through a track data example with four tables.

 Worked Example: Multiple Tracks | File Type: audio/mpeg | Duration: 838

We work through a track data example with four tables.

 Worked Example: Multiple Tracks | File Type: audio/mpeg | Duration: 838

We work through a track data example with four tables.

 15.7 Many-to-Many Relationships | File Type: audio/mpeg | Duration: 793

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.

 15.7 Many-to-Many Relationships | File Type: audio/mpeg | Duration: 793

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.

 15.7 Many-to-Many Relationships | File Type: audio/mpeg | Duration: 793

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.

Comments

Login or signup comment.