This class will introduce you to SQL and relational databases, two closely related tools for storing, searching, and analyzing data. We will cover the major features of SQL, including querying, filtering, and aggregating result sets. You'll learn how to join and merge data, and how to our organize your own data to make best use of a relational database.
To follow along with class exercises, you'll need to be able to run basic UNIX commands and execute Python statements through Jupyter notebook or CLI.
Do you need help with any of these prerequisites? Register for "Programming & Pizza" on June 8th: http://calendars.library.ucsf.edu/event/3329744
Please bring your own laptop.