Learn SQL equivalents of data-wrangling tools beyond the basic “five verbs”; particularly “joins”, and get some practice combining the fundamental ingredients into productive queries – and getting used to some of the “quirks” of SQL’s requirements about query structure – to access data from large databases stored on a remote server in a resource-efficient way.
We need to load packages and set up a connection to the server again. We’ll again do some work with the
For convenience here is the list of basic verbs again (make sure you’ve copied the
.png files from the
originals folder to your project folder):
Remember: Verbs lower in the list must appear after verbs higher in the list when constructing queries.
SQL translation summary again: