COURSE

SQL Fundamentals for R Users

Learn the basics of working with SQL databases for R Users.

By the end of this course, you'll be able to:

  • Work with databases using SQL.
  • Explore and analyze data in SQL.
  • Work through the R SQLite workflow.

START LEARNING

First mission free.

By creating an account you agree to accept our terms of use and privacy policy.

Learn SQL Fundamentals

Introduction to SQL

Learn the basics of SQL to explore a dataset.

Summary Statistics

Learn how to calculate summary statistics in SQL.

Group Summary Statistics

Learn how to compute statistics across groups.

Subqueries

Learn how to write complex, nested queries using subqueries.

Querying SQLite From R

Learn how to query a SQLite database from R.

Guided Project: Analyzing CIA Factbook Data Using SQLite and R

Practice the R SQLite workflow using CIA Factbook data.