Silent Disco: Getting Started with SQL and non-SQL Databases

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.

 

Online

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 silent disco, we will demonstrate one system: SQLite, a flexible open-source database, to learn some of the basic concepts of database design and usage; MongoDB Compass, to demonstrate non-SQL databases. 

The workshop will take place via Microsoft Teams in a ‘Silent Disco’ format. Participants will work on the tutorial at their own pace. The facilitator will be available via Teams Chat to reply to any questions that arise during the event, and to help with installation, troubleshooting, or other issues. 

To attend this course, you will have to join the associated Microsoft Teams group. The link to join the group will be sent to attendees before the course start date, so please make sure to do so in advance. 

 

This course will be taught by Alex Crest. 

 

After taking part in this event, you may decide that you need some further help in applying what you have learnt to your research. If so, you can book a Data Surgery meeting with one of our training fellows. 

More details about Data Surgeries. 

Those who have registered to take part will receive an email with full details on how to get ready for this course. 

If you’re new to this training event format, or to CDCS training events in general, read more on what to expect from CDCS training. Here you will also find details of our cancellation and no-show policy, which applies to this event. 

 

Level  

This is a beginner-friendly course. No previous knowledge of the topic is required/expected, and the trainer will cover the basics of the method.   

 

Learning Outcomes 

  • Understand the basics of relational database design
  • Familiarise yourself with the process of importing and exporting data
  • Perform queries and analyse data contained in a relational database 

  

Skills  

By attending the course, you will gain the following skills: 

  • An understanding of the functionality and use of SQL databases
  • An understanding of the functionality and use of non-SQL databases 

 

 Explore More Training: 

 

Return to the Training Homepage to see other available events 

You might be interested in

A collage image of historical material

Digital Method of the Month: Machine Learning

An illustrative collage with & symbol and an old photograph

Explainable Machine Learning (XAI)

UoE archive image with title of the training event

Foundations of Machine Learning

Thumbnail with title of the training

Comparing Sentiment Analysis Models in R

An illustrative collage with & symbol and a historical item

Getting Started with Bayesian Statistics

A collage image of historical material

Using Local Language Models for Research

A collage of historical images and material

Getting Started with Data Analysis in Python

A collage image of historical material

Getting Started with Text Analysis with Python

A collage image of historical material

Beyond Social Networks: Advanced Uses of Gephi in Humanities Research