Hi, you are logged in as , if you are not , please click here

SQL Database Management Software Edinburgh

Info
Location
Extras
Contact
More Info

Course Information

adrce

Course Summary

Database systems are increasingly being used for working with medical data and enable the rapid querying of complex data in health and social care.

This short course will introduce the theory behind the relational data model and enable participants to gain an understanding on how data can be modelled and stored in a relational database system and what different data types are used.

Through a series of practical-driven sessions using real-life data, students will learn how to load existing data in a contemporary relational database management system and how to craft simple and complex queries for analysing the data. By the end of the course, students will be able to load, format and export data in a format suitable for analysis by common statistical packages.

Target Audience:

Course suitable for epidemiologists, medical statisticians and other researchers working with electronic health records data.

Further course details can be found here.

 

More information regarding our courses can be found here.

 

Podcast for some of our previous courses can be found here.

Course Code

ADRCE-Training041 Denaxas

Course Date

30th January 2018

Places Available

12

Course Leader

Dr Spiros Denaxas and Dr Arturo González-Izquierdo
Course Description

Course Contents:

  • Introduction to contemporary relational database management systems (RDBMS), main components of architecture
  • Critical appraisal for RDBMS’s, comparison with traditional file-based approaches
  • Relational modelling and algebra, conceptual database design
  • Main RDBMS data types, choosing the right data type for the right field
  • Data definition SQL: create, describe, select...
  • Simple SELECT queries across single tables, SORT, GROUP
  • Basic error checking
  • Multi-table queries
  • Creating custom reports
  • Combining results (UNION, INTERSECT)
  • UPDATE
  • Subqueries
  • INDEX
  • Entities
  • Attributes
  • Relationships
  • By the end of the course, participants will:
  • understand the relational data model, data types and basic data modeling techniques
  • learn how to pre-format and load their data in a database system

learn how to create simple and complex queries using SQL

How would you rate your experience today?

How can we contact you?

What could we do better?

   Change Code