Digital Method of the Month: Organising Data via Databases
Hybrid
Have you seen a presentation on digital research methods and wondered if they are applicable to your work? Are you interested in learning new digital skills but unsure where to start?
This is the right place for you!
The digital method of the month meeting is a safe space to freely discuss the practicalities of learning and implementing a new digital skill in your research.
Each month, we select a method, and we have an honest and practical discussion on what it takes to learn and master it. How much time will it take to get the basics? What are the software options available? What are the most common pitfalls? Where can you find more info on the subject?
The method of this month is Databases.
Relational Databases collect information in a structured way and enforce relationships about what goes in and out. This provides additional control over editing processes and will reduce data entry time and errors. In a relational database, data in a table can be related according to common keys or concepts. Relationships are a logical connection between different tables and are defined based on the interaction among the tables.
Non-relational databases offer flexibility over different file formats and inputs. They allow a blank canvas for your data needs and, though they require additional expertise to set up and operate, facilitate complex data transformation. Data can be stored much like a relational database, but can also be stored with differences in structure and design. Data is located via keys or similar codes that can be retrieved in automated ways, such as through Python and R, or through a UI.
This conversation will be led 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 prior knowledge of the topic is required/expected, and the trainer will cover the basics of the method. Further workshops are delivered in the Silent Disco to provide hands-on experience of the data discussed.
Learning Outcomes
- To engage in discussions about the use of databases in research
- To have access to a source of information and online materials on SQL and non-SQL databases
Skills
By attending this course, you will familiarise yourself with the following skills:
- Understanding the uses and limitations of using databases in research
- Applicability of different types of databases
Explore More Training
Return to the Training Homepage to see other available events
Room 4.35, Edinburgh Futures Institute
This room is on Level 4, in the North East side of the building.
When you enter via the level 2 East entrance on Middle Meadow Walk, the room will be on the 4th floor straight ahead.
When you enter via the level 2 North entrance on Lauriston Place underneath the clock tower, the room will be on the 4th floor to your left.
When you enter via the level 0 South entrance on Porters Walk (opposite Tribe Yoga), the room will be on the 4th floor to your right.
