BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Springshare//LibCal//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-TIMEZONE:America/Los_Angeles
X-PUBLISHED-TTL:PT15M
BEGIN:VEVENT
DTSTART:20250418T160000Z
DTEND:20250418T180000Z
DTSTAMP:20250418T000000Z
SUMMARY:Intro to SQL for Data Analysis
DESCRIPTION:This workshop will introduce participants to the core concepts 
 of SQL (Structured Query Language) for querying and manipulating relational 
 databases. Attendees will learn how to write basic SQL queries to retrieve 
 data using the SELECT statement\, filter records with WHERE clauses\, and 
 perform aggregation using functions like COUNT\, SUM\, and AVG. The session 
 will also cover how to combine data from multiple tables using JOIN 
 operations. By the end of the workshop\, participants will be equipped with 
 the foundational SQL skills needed to query and analyze relational 
 data.\n\nNote: This workshop will be offered in person at the UCSF FAMRI 
 Library at Mission Bay and online through UCSF Zoom. You will receive an 
 email from LibCal with room information and Zoom link prior to the start of 
 the workshop. \n\n \n\nWorkshop Series: Data and Document Analysis with 
 Python\, SQL\, and AI\n\nThis series is designed for researchers\, staff\, 
 and students who want to learn Python from the ground up\, focusing on data 
 analysis\, document analysis\, and AI-based research. Throughout the 
 workshops\, we’ll dive into various data types—including numerical 
 data\, health data\, text\, and images/videos—and explore analysis 
 techniques like regression\, classification\, and sentiment analysis. 
 We’ll put a particular focus on text analysis\, especially analyzing 
 documents from our industry document library.\n\nAs programming evolves\, 
 so does the way we learn it. While we’ll introduce AI-assisted 
 programming earlier in the series than in past workshop series\, we’ll 
 still start with the basics. The early workshops (Intro to Python Parts 1 & 
 2 and Intro to SQL) will use AI sparingly. As the series moves forward\, 
 we’ll dive into topics like web APIs\, text analysis\, natural language 
 processing\, machine learning\, regression\, document analysis\, and AI 
 system interaction\, with more AI-driven techniques along the way.\n \n\n
LOCATION:Virtual\, Online
ORGANIZER;CN="Geoffrey Boushey":MAILTO:Geoffrey.Boushey@ucsf.edu
CATEGORIES:Data Science, Programming
CONTACT;CN="Geoffrey Boushey":MAILTO:Geoffrey.Boushey@ucsf.edu
STATUS:CONFIRMED
UID:LibCal-14211877
URL:https://calendars.library.ucsf.edu/event/14211877
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR