Using Data Acquisition Methods
Goals
- Identify different file formats.
- Work with public data.
- Collect data.
- Integrate data into tables.
- Identify types of data systems and software.
- Explain the processes of extracting, transforming, and loading data.
Identify Different File Formats
- Delimited Files
- Flat Files
- File Extensions
Work with Public Data
- Public Data
- Generated Data
- Synthetic Data
- Finding Public and Publicly Available Data
- Creating a Data Set from Census Data
Collect Data
- Building a Survey and Collecting Data
- Research Questions
- Data Sources and Collection Methods
- Sampling and Observations
- Creating Data Collections with Surveys
Integrate Data into Tables
- Data Definition Language (DDL)
- Creating Databases
- Altering Databases
- Creating Tables
- Altering Tables
- Deleting Tables
- TRUNCATE Command
- Creating Views
Identify Types of Data Systems and Software
- Application Programming Interface (API)
- Web Service
- Web Scraping
- Web Scraping with Python
- Machine Data
- Metadata
- Log Data