Introduction to Databases with SQLite

Managing data has become increasingly important in the Humanities and Social Sciences. Databases provide a powerful tool to allow for the storage, structuring and analysis of large amounts of data. In this workshop we will use SQLite, a flexible open-source database, to learn some of the basic concepts of database design and usage.

In this workshop you will learn:

Basic database design 

Importing and exporting data 

Querying datasets 

Analysing your data 

Due to high demand for our training events, our cancellation and no-show policy applies to bookings for this event. Click here for details of this policy.

You might be interested in

Graphic for a workshop titled ‘Data Viscualisation’ The background is a collage of historical printed text with an overlaid image of a wolf. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner

Digital Method of the Month: Data Visualisation

Graphic for a workshop titled ‘Foundations of Webscraping.’ The background is a black-and-white photograph of students working together in a design studio with maps and models. A large teal ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Collecting Data from the Web: Foundation of Webscraping

Graphic for an event titled ‘BYOD Festival.’ The background is a black-and-white photograph of people sitting around a table, drinking tea and playing cards. A large magenta ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Bring Your Own Data (BYOD) Fest

Graphic for a workshop titled ‘An Introduction to Deep Learning for Image Classification.’ The background is a sepia photograph of people working at desks in a large hall with overhead lamps. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Silent Disco: Computer Vision for the Humanities: An Introduction to Deep Learning for Image Classification

Graphic for a workshop titled ‘Using Prompting Efficiently for Research.’ The background shows an aged, torn book page with visible text. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Using Prompting Efficiently for Research

black and white photograph of a person drinking tea out of a flaks on top of a hill.

CDCS December Fika

graphic of a black and white Christmas tree background with colourful baubles and snowflakes. The text "Dorothy Berry, CDCS Annual Lecture 2025" is overlayed."

CDCS Annual Lecture 2025

Graphic for a workshop titled ‘Geospatial Data and GIS’ The background is a collage of historical printed text with an overlaid image of a wolf. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Digital Method of the Month: Geospatial Data and GIS

Graphic for a workshop titled ‘Creating Choropleth Maps with Python and Folium.’ The background is a sepia photograph of people working at desks in a large hall with overhead lamps. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Silent Disco: Creating Choropleth Maps with Python and Folium

Graphic for a workshop titled ‘Getting Started with Inferential Statistics.’ The background is a black-and-white photograph of people studying in a library with partitioned desks. A large teal ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Getting Started with Inferential Statistics

an old map of Acotland with the text "Jennifer Smith & Brian Aitken, Project deep Dive"

Who Speaks Scots Where: What Crowdsourcing Reveals

Graphic for a workshop titled ‘Using API for Research.’ The background is a black-and-white photograph of people working with printing equipment and patterned sheets. A large magenta ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Using API for Research