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 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 ‘Getting Started with Descriptive Statistics.’ The background is a black-and-white photograph of people reading and working in a library. 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.

Getting Started with Descriptive Statistics

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 ‘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 ‘Text Classification in Practice: From Topic Models to Transformers.’ The background shows handwritten historical letters. 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.

Text Classification in Practice: From Topic Models to Transformers

Graphic for a workshop titled ‘Introduction to Geographical Data with QGIS.’ The background shows an old map of the world with detailed illustrations. 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.

Intro to Geographical Data with QGIS

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

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

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

Graphic for a workshop titled ‘An Introduction to Epistemic Network Analysis.’ The background shows an old manuscript with geometric diagrams and curved illustrations. 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.

From Qualitative Data to Quantified Connections – An Introduction to Epistemic Network Analysis

Graphic for a workshop titled ‘Data Wrangling and Manipulation with R.’ The background is a black-and-white photograph of a large classroom where people are sculpting and drawing statues. 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.

A Pipeline for Data Wrangling and Manipulation with R

Graphic for a workshop titled ‘Foundations of Sentiment Analysis.’ 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: Foundations of Sentiment Analysis