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:
• Introduction to SQL and relational databases
• SQLite setup and integration with Python (pandas)
• Basic SQL operations: SELECT, WHERE, JOIN, GROUP BY, and more
• Querying SQLite databases with pandas
• Working with real-world datasets
Questions? Email: dlab-frontdesk@berkeley.edu