Silent Disco: Introduction to Databases and SQL
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 workshop we will use SQLite, a flexible open-source database, to learn some of the basic concepts of database design and usage.
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 workshop, and to help with installation, troubleshooting or other issues.
This is a beginner level event. No previous knowledge on the topic is required/expected and the trainer will cover the basics of the method.
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 prior to the course start date, so please make sure to do so in advance.
This Silent Disco will be facilitated by Lucia Michielin.
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.
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.
Learning Outcomes:
- Understand the basics of relational database design.
- Familiarise with the process of importing and exporting data.
- Perform queries and analyse data contained in a relational database.
If you're interested in other training on data analysis, have a look at the following:
- Digital Method of the Month: Statistical Methods - Linear Modelling
- Introduction to Statistics and Descriptive Statistics
- Interactive Analysis Reports with R Markdown
- A Gentle Introduction to Causal Inference
- Null Hypothesis Testing in R
- Introduction to Bayesian Statistics
- Regression and Mixed Effects Modelling
