Learning Outcomes:
Students will gain knowledge and experience of Structured Query Language (SQL), and demonstrate the ability to create and query a structured database containing the chosen dataset for their research project.
Students will develop a research question and project plan to be approved by module staff.
Indicative Module Content:
Workshop content:
Creation of structured databases using MySQL
Basics of database structures: tables, variable types, keys etc.
Construction of queries using MySQL syntax
Querying databases through R and Python, using e.g. SQLAlchemy, RSQL