Ethics of public and patient involvement in research: Governance, democracy and social justice

This course was run as part of the University of Otago, Public Health Summer School 2019. It builds on the popular Introduction to Data Ethics held as part of the 2018 PHSS.

It provides a critical overview of current debates and ethical challenges regarding patient and public involvement in research (PPI), specifically in relation to biobanks and the sharing, linking and/or re-use of health-related information and data (both quantitative and qualitative).

Watch this space for future courses.

Introduction to SQL – NZSSN

The New Zealand Social Statistics Network (NZSSN) runs a two day course introductory course on SQL.

Course outline

Day 1
We start with a short introduction to database technologies, covering the basic structure of a database and the usefulness of the SQL relational database model. We dive into SQL coding, beginning with easy examples and the most useful data manipulation queries: Joining tables, using unique identifiers, selecting, projecting, aggregating, ordering data and doing top-k searches.
By the end of day 1 we will have plenty of practice in using basic SQL queries to efficiently extract useful datasets and to export them to R, SAS, Stata, or other statistical software.

Day 2
This is a chance to apply our day-1 knowledge to the Microsoft SQL Management Studio coding environment commonly used to access the IDI. We start with a brief introduction to the IDI and the important peculiarities of this system, from both the research and database usage perspectives. We then learn some intermediate SQL: Nested queries, unioning, grouping, creating views, built-in functions and anything we have time for (including creating our own basic T-SQL stored procedures). The goal will be to practice using these queries to greatly speed up and simplify the process of extracting useful data from a database.

Future dates for this course are not currently scheduled.