NOTE: Please register for this workshop using your UC email address.

This course will provide an introduction to SQL, the structured query language used to access relational databases.  In this workshop, you'll learn how to import data into a database, run queries, filter results, aggregate data, and join multiple tables based on a common element.  The focus of this class is on gaining familiarity with the SQL language for basic data analysis.  

For more information on this workshop, including software and setup requirements, please see the CLE course page at:

https://courses.ucsf.edu/course/view.php?id=4401

Note: This workshop will be offered online over UCSF Zoom. You will receive an email with a zoom link from libcal prior to the start of the workshop. 

Digital Humanities Sequence

This sequence is designed for people with no prior programming experience. The workshops start with core python and sql before moving into more advanced or specialized topics in digital humanities, with an emphasis on text analysis and machine learning. 

You are welcome to take any of these workshops without attending the entire series. No formal pre-reqs are enforced, but if you are new to Python or SQL, you’ll get the core programming skills necessary for the later workshops by attending Intro to Python Part 1 and Part 2 along with Intro to SQL. 

Registration Links: 

• Intro to Python Part 1:
  • https://calendars.library.ucsf.edu/event/11946795
• Intro to Python Part 2:
  • https://calendars.library.ucsf.edu/event/11946839
• Intro to SQL:
  • https://calendars.library.ucsf.edu/event/11946900
• Data Analysis with Python, Pandas, and SQL:
  • https://calendars.library.ucsf.edu/event/11947263
• Intro to Unix:
  • https://calendars.library.ucsf.edu/event/11947161
• Reading Data from APIs with Python, Pandas, and SQL:
  • https://calendars.library.ucsf.edu/event/11947321
• Machine Learning with Python and Scikit-Learn:
  • https://calendars.library.ucsf.edu/event/11947452
• Python Background for Text Analysis and Natural Language Processing:
  • https://calendars.library.ucsf.edu/event/11947471
• Machine Learning for Document Classification and Sentiment Analysis:
  • https://calendars.library.ucsf.edu/event/11947489
• Google Cloud Tools, BiqQuery, and VertexAI:
  • https://calendars.library.ucsf.edu/event/11947492