Extract Data-Overview
Course Intro: Extract, Transform, and Load Data
()
Overview
Get help and meet other learners in this course. Join your discussion forums!
Extract Data-Fundamental Data Concepts
Structure of Data
()
Terms Describing Portions of Data
()
Big Data
()
Extract Data-Extract Data from Different Sources
Data Sources
()
Open Datasets
Public APIs and Web Scraping
()
Data Read from Cloud Storage
()
Extract, Transform, and Load (ETL)
()
CSV Files
()
Guidelines for Reading Data from CSV Files
Extract Data-Query Data
SQL Queries
()
NoSQL Queries
()
Guidelines for Extracting Data with Database Queries
Extract Data-Consolidate Data
Data Consolidation and Joins
()
Inner Join Example
Guidelines for Consolidating Data from Multiple Sources
Transform Data-Overview
Overview
Transform Data-Data Preparation and Data Types
Data Preparation and Cleaning
()
Types of Data and Data Operations
()
Continuous vs. Discrete Variables
()
Data Parsing
()
Guidelines for Parsing Data
Transform Data-Handle Irregular, Unusable, and Incorrectly Formatted Data
Data Irregularities
()
Guidelines for Handling Irregular and Unusable Data
Correction of Data Formats and Date Conversion
()
Guidelines for Correcting Data Formats
Transform Data-Deduplicate Data
Deduplication
()
Guidelines for Deduplicating Data
Transform Data-Transform Text and Image Data
Word Embedding
()
Text Data Transformation Techniques
Image Data Representation
()
Guidelines for Transforming Data
Load Data-Overview
Overview
Load Data-Load Data into Databases
Data Loading Considerations
()
Data Loading: Databases
()
Guidelines for Loading Data into Databases
Load Data-Load Data into DataFrames
Data Loading: DataFrames
()
Guidelines for Loading Data into DataFrames
Load Data-Load Data into Text Files
Data Loading: Text Files
()
Guidelines for Loading Data into Text Files
Load Data-Leverage ETL Endpoints and Visualization Tools
ETL Endpoints
()
Guidelines for Configuring ETL Endpoints
Data Loading: Visualization Tools
()
Guidelines for Loading Data into Visualization Tools
Exploring Data Visualization Tools