Week 7 - Programming with databases

Learning objectives

• Review: understand how the data model relates to queries
• Understand the basic database programming model
• Access an SQLite database from Python and R
• Understand how to use the Python/Pandas and R/dbplyr convenience functions

Slides and other materials

slides-07.pptx

Coding transcripts:

• transcript-07-mon.ipynb
• transcript-07-wed-python.ipynb
• transcript-07-wed-r.R

Resources

1. https://peps.python.org/pep-0249/

   • Common Python-RDBMS API

2. https://docs.python.org/3.11/library/sqlite3.html

   • Python SQLite module

3. https://dbplyr.tidyverse.org/

   • R dbplyr documentation

Homework

Little Bobby Tables

Who’s the culprit?

Characterizing egg variation

Who were the winners?