Relational
Database Management Systems
for Epidemiologists
UC Berkeley Center for Infectious Disease Preparedness
[Download PDF] | [Go to Home Page] | [Go to Courses Page]
All data files (except for the oswego dataset) were created for the exercises in our courses. All personal information referred to in the data are fictitious and are not intended to refer to any person living or dead. Any such reference is coincidental and unintentional. The data were created to mimic real world datasets that one may encounter in an outbreak situation in order to illustrate and highlight the use of the course material.
These materials are a work in progress. If you have any questions about these materials or note any errors in the content, please contact:
Wayne
Enanoria, PhD, MPH
Center for Infectious Disease
Preparedness
University of California at Berkeley
1918
University Avenue, 4th Floor
Berkeley, CA 94720
Phone:
(510) 643-4934
Email: enanoria@berkeley.edu
|
Topic |
Exercise |
Data |
|---|---|---|
|
Starting the Process [PDF] [OpenOffice.org] |
Exercise 1 [PDF] [OpenOffice.org] SARS forms [PDF] (last accessed 07.20.04 from CDC) |
none |
|
Entity-Relationship Diagrams [PDF] [OpenOffice.org] |
Exercise 2 [PDF] [OpenOffice.org] |
none |
|
Normalization [PDF] [OpenOffice.org] |
Exercise 3 [PDF] [OpenOffice.org] |
none |
|
Setting up a database in MS Access [PDF] [OpenOffice.org] |
Exercise 4 [PDF] [OpenOffice.org] |
none |
|
SQL Part I: Retrieving data from a table [PDF] [OpenOffice.org] |
Exercise 5 [PDF] [OpenOffice.org] Exercise 5 Answers [PDF] [OpenOffice.org] |
|
|
SQL Part II: Summarizing and grouping data [PDF] [OpenOffice.org] Joins in Action [PDF] [OpenOffice.org] |
Exercise 6 [PDF] [OpenOffice.org] Exercise 6 Answers [PDF] [OpenOffice.org] |
|
|
SQL Part III: Subqueries [PDF] [OpenOffice.org] |
Exercise 7 [PDF] [OpenOffice.org] Exercise 7 Answers (given in the exercise) |
|
|
SQL Part IV: Table/row modifications [PDF] [OpenOffice.org] |
Exercise 8 [PDF] [OpenOffice.org] Exercise 8 Answers [PDF] [OpenOffice.org] |
|
|
Open Database Connectivity [PDF] [OpenOffice.org] |
Exercise 9 [PDF] [OpenOffice.org] |
Download oswego dataset. |
|
Generating Reports [PDF] [OpenOffice.org] |
Exercise 10 [PDF] [OpenOffice.org] |
Field Data Types [doc]
PROC SQL Example in SAS (courtesy of Jean Tsu-Ying Kuo and Hepei Chen, graduates of the Master's Program in Biostatistics)
|
Topic |
Exercise |
Data |
|---|---|---|
|
Creating Data Entry Screens [PPT] |
Workshop I [PDF] |
none |
|
Creating Check Codes [PPT] |
||
|
Entering and Editing Records [PPT] |
Workshop II Description [doc] Workshop II Data Forms [PDF] |
|
|
Descriptive Epidemiology and Simple Analysis [PPT] |
||
|
Creating Variables, Manipulating Data and Working with Output [PPT]
|
Workshop III [doc] |
|
|
Data Management [PPT] |
||
|
Generating Reports [PPT] |
none |
none |
This page was created on 6 September 2004.