Data Analysis with SQL and Python
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. Bring your laptop!
Prerequisites: 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. These prerequisites can be met by taking SQL for Beginners and Intro to Python parts 1 & 2.
Do you need help with any of these prerequisites? Register here for an upcoming "Programming & Pizza" session.
When you register, the Library reserves class space for you. Since many of our classes have a waitlist, please cancel your registration if you can no longer attend.
Related LibGuide: Reproducible Data Management by Ariel Deardorff
- Friday, February 9, 2018
- 10:00am - 12:00pm
- Mission Hall 1406
- Mission Bay