Fall 2023 online training courses delivered by ACENET: SQL for Humanities, Social Sciences, and Librarians--November 15 and 22, 2023
This two-part session is the second of our beginner-level Humanities and Social Sciences data organization and analysis series. Many web applications, research project websites, and library and archival repositories store data in relational databases. A relational database can help you keep your data separate from your analysis, improve quality control of data entry, reduce duplication of data, and improve your ability to search across large and complex datasets. Structured Query Language, or SQL, is a powerful language used to search and manipulate relational databases. This workshop teaches participants about relational databases and SQL using SQLite. You will learn how to write queries in SQL and how to use aggregate functions to combine data. It uses examples and challenges from the Humanities, Social Sciences, and library research fields and uses materials. There are no prerequisites.