Training: An Introduction to Databases using SQLite

* Please bring your own laptop/device to this workshop *

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 amount 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

 

Digital Scholarship Centre

Digital Scholarship Centre, 6th floor

Main Library 

University of Edinburgh 

Edinburgh EH8 9LJ

You might be interested in

An illustrative collage with & symbol and some patterns in squares

Modelling Unstructured Data with Bert

A collage image of historical material

Silent Disco: Understanding and Creating Word Embeddings

An illustrative collage with & symbol and a historical item

Getting Started with Bayesian Statistics

An illustrative collage with & symbol and old graphs

Getting Started with Regression in R

An illustrative collage with & symbol and a maths graph

Linear Mixed Effects Modelling

A collage image of historical material

Digital Method of the Month. Statistics: How to pick the right method

A collage image of historical material

Data Analysis Workflow Design

UoE archival image with training event title

Systematic Literature Review with R

Historical UoE image with title of the event

Good Data Visualisation with R

A collage image of historical material

Analysing Spatial Dynamics with GIS and R

An illustrative collage with & symbol and an old photograph

Explainable Machine Learning (XAI)

A collage image of historical material

A Gentle Introduction to Causal Inference