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:

Beginner

The median completion time for this course is 3.5 hours. ​View Details​​​

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