
6. questions

If you use RStudio and your company has a database team that supports dplyr access to well-managed relational databases, then you're probably fine in dplyr.

If you're managing a database or building a new one for your company, you'll almost certainly be asked to do it using SQL, not dplyr. dplyr supports decent queries; SQL provides a full suite of implementation-dependent optimizations for building and managing databases.

My goal this week was to give you a small taste of relational database work. If you sort of like it, then you could consider collaborating with the database team at your company. If you don't like it, walk away happily with a good, basic understanding of relational data. 