4th Pharmacoepidemiology Research Network Symposium

Wednesday 21st November 2018, Arana College, University of Otago, Dunedin

Are you interested in the safety and utilisation of medicines and medical devices?  If so, you might like to attend a one-day symposium which is being hosted by the Pharmacoepidemiology Research Network, and sponsored by PHARMAC and Medsafe.

The keynote speaker will be Irene Petersen, Professor of Epidemiology and Health Informatics at University College London.  Professor Petersen has a number of research interests including the use of prescription medicines in pregnancy, physical health in people with severe mental illnesses, and the development of new methods for longitudinal imputation of missing data in electronic health records.

Other researchers will present the results of recently completed medicine safety and/or utilisation studies, discuss current investigations, and introduce upcoming projects.

To register, please go to: https://www.otago.ac.nz/pharmacoepidemiology/news/symposium/registration/


Introduction to SQL – NZSSN

NZSSN is running a two day course introductory course on SQL in Auckland on the 26-27th February, 2019.

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.

Click here to register!