SQL Database Fundamentals for Data Analysis

REGISTRATION NOTES

Click register and then use your @berkeley.edu or @lbl.gov email address.
If you have trouble, you may need to log out of Zoom and log back in.
For help read more here: https://dlab.berkeley.edu/zoom-troubleshooting-tips

Location: Remote via Zoom. Link will be sent on the morning of the event.

Recordings: This D-Lab workshop will be recorded and made available to UC Berkeley participants for a limited time. Your registration for the event indicates your consent to having any images, comments and chat messages included as part of the video recording materials that are made available.

Start Time: D-Lab workshops start 10 minutes after the scheduled start time (“Berkeley Time”). We will admit all participants from the waiting room at that time.

Date & Time: This workshop:

• Mon Dec 9

Description

This workshop introduces the fundamentals of SQL, with a focus on using SQLite (the most ubiquitous database on the planet) for data science tasks. We'll explore how SQL can be used to query and manipulate relational databases, leveraging pandas to interact with the results in Python. This hands-on workshop includes exercises based on real-world datasets. Key Topics Covered:

• Navigate and understand the structure of a relational database.
• Become familiar with relational database concepts.
• Have basic understanding of SQL syntax (e.g., SELECT, FROM, WHERE clauses).
• Write SQL queries to select, filter, and sort data.
• Perform complex joins between tables to retrieve related data.
• Use aggregate functions to summarize data.