MISSION 367

Querying SQLite from R

Learn how to query a SQLite database from R.

Objectives

  • How to run SQL queries using RSQLite in R.

Mission Outline

1. Overview
2. Introduction to the Data
3. Connecting to the Database
4. Running Queries With Our Connection
5. Limitations of dbGetQuery()
6. Cleaning Up After Ourselves
7. Using the Whole Workflow
8. Wrapping Up The Connection
9. Next Steps
10. Takeaways

sql-fundamentals

Course Info:

SQL Fundamentals for R Users

Beginner

The average completion time for this course is 3 –4-hours.

This course requires a basic subscription and includes four missions and one guided project.  It is the fifth course in the ​Data Analyst in R Path​​​

START LEARNING FREE

Take a Look Inside