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: select single column multiple columns distinct values in a column limit the number of records returned handle NULL values and filter columns using the following operators WHERE AND, or & NOT BETWEEN IN LIKE Libraries, Code & Data We will use the following libraries in this post: