![]() |
Review of Preparing Data |
|
Assigned Reading
Presentations
AssignmentInstruction 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:
Task 1: Download Microsoft SQL Server. LinkedIn(r) Learning► Instruction for SSMS 2017► Video► Patruni's Teach One►
Task 2: Download and clean data. Download data in three/four zipped files. You can focus on the entire data or focus on the data for patients who have at least 365 days of encounters. For password contact your instructor. By opening this file you agree not to share the file with anyone else. Unzip the files twice, first to get to the directory and then to get to the actual file. Link to the data into Access or read the data into Microsoft SQL server. We recommend you use SQL server. To create the database, open SQL server and right click on the database and start a new database. Right click on the database, select "Tasks," select "Import Data," select "Flat File Source" as the source of the data, change file type to "CSV Files," browse to where you unzipped the files, indicate that field names are in the first row, select as destination "SQL Server Native Client" file type. Massive Data► >365 Days Data, Access Code► SQL Code to Merge Files► Create Database► Visual Guide to Read SQL►
|
Copyright © 2021 Farrokh Alemi, Ph.D. Most recent revision 02/05/2021. This page is part of the course on Electronic Health Record Configuration and Data Analysis. |