Preparing Data

Assigned Reading

• Read chapter 2 in Big Data in Health Care: Statistical Analysis of Electronic Health Record Read►

Presentations

• Introduction to SQL
  • Types of SQL commands Slides► YouTube►
  • Creating tables in Microsoft Server SQL Read► Slides► YouTube►
  • Select command Slides► YouTube►
  • GROUP BY command Slides► YouTube►
  • WHERE and HAVING commands Slides► Read► YouTube►
  • Introduction to joins Slides► YouTube► Read►
  • RANK and row numbers Slides► YouTube►
  • Date functions Slides► YouTube►
  • Text manipulation Slides► YouTube►
  • SQL code for cleaning the data Slides► YouTube►

Assignment

Instruction for Submission of Assignments: Assignments should be submitted directly on Blackboard.  In rare situations assignments can be sent directly by email to the instructor. Submission should follow these rules:

1. Submit your answers in a Jupyter Notebook Download► YouTube► Slides►
2. Submit you answers in Blackboard.

Question 1: Create your database in All of US.