15.6 Multi-Table Retrieval using JOIN
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.
28 Syys 201610min
Worked Example: Multiple Tracks
We work through a track data example with four tables.
28 Syys 201613min
15.7 Many-to-Many Relationships
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.
28 Syys 201613min
Worked Example: Many-to-Many
We extend the Twitter example to represent friends using Many-to-Many relationships.
28 Syys 201621min
16.1 Visualizing Map Data
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.
27 Syys 20166min
Worked Example: Retrieving Geocoded Data
Worked Example: Retrieving Geocoded Data
27 Syys 201613min
16.2 Building a Web Search Engine
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 a...
27 Syys 201611min
Worked Example: A Web Crawler
Worked Example: A Web Crawler
27 Syys 201617min
