Week 6 - Programming with databases
Learning objectives
- Understand the basic database programming model
- Access a DuckDB database from Python and R
- Understand how to use the Python/Pandas and R/dbplyr convenience functions
Slides and other materials
Coding transcripts:
Resources
https://peps.python.org/pep-0249/
- Common Python-RDBMS API
https://duckdb.org/docs/api/python/overview
- Python DuckDB module
-
- R dbplyr documentation