Extract, Transform, and Load Data 

Course Intro: Extract, Transform, and Load Data

Structure of Data

Terms Describing Portions of Data

Big Data

Data Sources

Public APIs and Web Scraping

Data Read from Cloud Storage

Extract, Transform, and Load (ETL)

CSV Files

SQL Queries

NoSQL Queries

Data Consolidation and Joins

Overview

Open Datasets

Guidelines for Reading Data from CSV Files

Guidelines for Extracting Data with Database Queries

Inner Join Example

Guidelines for Consolidating Data from Multiple Sources

Extracting Data

Data Preparation and Cleaning

Types of Data and Data Operations

Continuous vs. Discrete Variables

Data Parsing

Data Irregularities

Correction of Data Formats and Date Conversion

Deduplication

Word Embedding

Image Data Representation

Overview

Guidelines for Parsing Data

Guidelines for Handling Irregular and Unusable Data

Guidelines for Correcting Data Formats

Guidelines for Deduplicating Data

Text Data Transformation Techniques

Guidelines for Transforming Data

Transforming Data

Data Loading Considerations

Data Loading: Databases

Data Loading: DataFrames

Data Loading: Text Files

ETL Endpoints

Data Loading: Visualization Tools

Overview

Guidelines for Loading Data into Databases

Guidelines for Loading Data into DataFrames

Guidelines for Loading Data into Text Files

Guidelines for Configuring ETL Endpoints

Guidelines for Loading Data into Visualization Tools

Exploring Data Visualization Tools

Loading Data