10 Databases

We use databases to store and retrieve data. Check out database basics to become familiar the common types and structures.

• Most of our database connection is completed through fpr_db_conn()
• We use the DBI package to connect to databases. Follow the examples on how to connect to a database using DBI.
• There are many remote databases that we can connect to. The most common ones are our Postgres database, locak Sqlites,

10.1 SQL

• Structured query language (SQL) is used to interact with databases. Follow the examples on how to write SQL queries.

  • Remember that order and case matter when using SQL!
  • Check out dbplyr for a another way to learn and use SQL