Sql

SQL for Data Science - Part 2

Introduction This is the fourth post in the series R & Databases. You can find the links to the other two posts of this series below: Quick Guide: R & SQLite Data Wrangling with dbplyr SQL for Data Science - Part 1 In this post, we will learn to aggregate data order data and group data Libraries, Code & Data We will use the following libraries in this post:

SQL for Data Science - Part 1

Introduction This is the third post in the series R & Databases. You can find the links to the other two posts of this series below: Quick Guide: R & SQLite Data Wrangling with dbplyr SQL for Data Science - Part 2 In this post, we will learn to: Libraries, Code & Data We will use the following libraries in this post: DBI RSQLite dbplyr All the data sets used in this post can be found here and code can be downloaded from here.