Introduction to SQL for Clinical Researchers

This workshop provides an introduction to databases and the Structured Query Language (SQL) for clinical researchers. Topics covered include:

• Introduction to databases.
• Normalization and data modeling.
• Introduction to SQL.
• Recognizing bad data.
• Documentation and metadata.
• In-class programming exercises using a mock clinical database.

Prior to attending this workshop, participants should install one of the following SQL clients to run example queries in real time:

• DBeaver: Available for Windows, Mac and *NIX
• SQL Server Management Studio (SSMS): Windows only

The procedure for connecting to the sandbox database will be given by the instructor.