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
Assignments
COP4709 Spring 2013 Assignments - Week 2 assignment.
Comments (0)
You don't have permission to comment on this page.