Internal courses and training Workshop in Advanced Data Management

23-04-2024 9:00 am - 10:45 am Add to iCal
Campus Solna Wargentin lecture hall

Welcome to the third workshop in the series of “Advanced Data Management”

Title: Advanced Data Management: Accessing and Using the MEB Data Storage using SQL and the Registry Database.

09:00-09:45       Presentation: The registry database (Staffan Bergh, Vivekananda Lanka)

09:45-10:00       Coffee break

09:45-10:45       Demo: Running queries in the database (Staffan Bergh, Vivekananda Lanka)

Registration 

No registration required. You will be able to sign an attendance sheet for Phd students who need credit as DM workshop.

Target audience 

MEB PhD students, postdocs, researchers and other staff using registry data for research studies.

Description 

This workshop will give insights into how to access the MEB Data storage, with a focus on the registry database. We will briefly introduce SQL and the SQL server. We will also show examples of connecting to the database and running SQL, form R, SAS, Python and with Azure Data Studio.

Preparation 

For the Demo session, you will be able to ask questions and get help. We would be very interested in seeing your problems and code before the workshop – please contact Staffan and Vivekananda prior to the workshop.

This workshop is organised by the DM group at MEB.

Contact

Anna Johansson Statistician;Assistant Professor