Databases
Databases give us very fast random access to large amounts of data. There is a lot of material in this chapter as we learn the Structured Query Language (SQL).
Slides
Videos
- Databases - Part 1 (15:41)
- Databases - Single Table SQL - Part 2 (10:07)
- Worked Example: Emaildb.py (13:39)
- Databases - Complex Models - Part 3 (8:44)
- Databases - Relationships - Part 4 (4:06)
- Databases - Foreign Keys - Part 5 (11:32)
- Databases - JOIN - Part 6 (10:30)
- Worked Example: Tracks.py - (7:56)
- Databases - Many-to-Many - Part 7 (13:13)
- Worked Example: Roster.py (11:27)
References
Discussions
- Databases (Login Required)
Tools
- Autograder: Single Table SQL (Login Required)
- Quiz: Single Table SQL (Login Required)
- Autograder: Counting Email in a Database (Login Required)
- Autograder: Multi-Table Database - Tracks (Login Required)
- Quiz: Data Modeling (Login Required)
- Autograder: Many Students in Many Courses (Login Required)
- Quiz: Many to Many (Login Required)