This class will review and expand on basic techniques for querying data in SQL. We will introduce subqueries and aliases, explore core SQL functions in greater depth, and demonstrate how to use SQL in combination with other data analysis tools such as Python and Pandas.
To follow along with class exercises, you'll need to be able to run basic SQL commands: (SELECT, WHERE, GROUP BY, HAVING) and basic Python commands in a Jupyter Notebook.
Do you need help with any of these prerequisites? Register here for an upcoming "Programming & Pizza" session.
Thursday, August 10 at 1:00pm to 3:00pm
Parnassus Library, CL221-222
530 Parnassus Avenue, San Francisco, CA 94143-0840