Week 2 Topic – Importing Data

Topic – Importing Data

In week 2 we will start working with data sets. There are a lot of data sets available throughout the internet and we will be using these data sets in assignments for this course, You will learn to import data from an external source and as the course progresses you will learn how to manipulate and analyze this data.

Reading and Reference Materials

Data Sets – these our sources of data that I like to use in various assignments. There are thousands of useful data that are freely available on the internet. You will use many of these in your assignments.

Reference – US Government Data Sets – http://www.data.gov/

Reference – Medicare Data Sets – https://data.medicare.gov/

Reference – CDC Data Sets – http://www.cdc.gov/datastatistics/

You are learning one method to import data in this assignment (the import wizard) – you should read this article which covers multiple methods to insert data http://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/ – you will very likely need to use these other techniques in the future.

Lectures

Lecture – Importing Data Into SQL Server

Lecture – Preparing a Flat File for Database Import

SQL Server Central FAQ on transferring Excel Data (requires SQL Server Central login) https://www.simple-talk.com/sql/ssis/importing-excel-data-into-sql-server-via-ssis-questions-you-were-too-shy-to-ask/?utm_source=ssc&utm_medium=weblink&utm_content=ssisquestions

Assignment

Week 2 Assignment