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

• 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)

• Slides

  • Pythonlearn-15-Databases.pptx

• References

  • Chapter 15: Python and Databases
  • Python for Everybody Database Handout
• 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)