Merging Data
Selects and filters
Combining data horizontally and vertically.
Renaming and joins
Left joins and anti-joins
Abstract data, SQL databases, and normalization.
Tidyverse to SQL equivalencies.
Self joins
The Pleiades dataset: Real-world modeling and SQL querying
Writing SQL queries.
Nests and deeply structured data
Where can you use list columns?
Working with database systems
Exercises: joins and nesting.