Monthly Subscription Starting at AED 99 + VAT

Extract, Transform, and Load Data
  • Level Professional
  • Duration 15 hours
  • Course by CertNexus
  • Offered by

About

This course is designed for business and data professional seeking to learn the first technical phase of the data science process known as Extract, Transform and Load or ETL. Learners will be taught how to collect data from multiple sources so it is available to be transformed and cleaned and then will dive into collected data sets to prepare and clean data so that it can later be loaded into its ultimate destination. In the conclusion of the course learners will load data into its ultimate destination so that it can be analyzed and modeled. The typical student in this course will have experience working with data and aptitude with computer programming.

Modules

Overview

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course Intro: Extract, Transform, and Load Data

2 Readings

  • Overview
  • Get help and meet other learners. Join your Community!

Fundamental Data Concepts

    • 3 Videos
Show info about module content

3 Videos

  • Structure of Data
  • Terms Describing Portions of Data
  • Big Data

Extract Data from Different Sources

    • 5 Videos
    • 2 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Reading Data from CSV Files

5 Videos

  • Data Sources
  • Public APIs and Web Scraping
  • Data Read from Cloud Storage
  • Extract, Transform, and Load (ETL)
  • CSV Files

2 Readings

  • Open Datasets
  • Guidelines for Reading Data from CSV Files

Query Data

    • 2 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Extracting Data with Database Queries

2 Videos

  • SQL Queries
  • NoSQL Queries

1 Readings

  • Guidelines for Extracting Data with Database Queries

Consolidate Data

    • 1 Videos
    • 2 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Consolidating Data from Multiple Sources

1 Videos

  • Data Consolidation and Joins

2 Readings

  • Inner Join Example
  • Guidelines for Consolidating Data from Multiple Sources

Evaluate What You've Learned

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Extracting Data

1 Discussions

  • Reflect on What You've Learned

Overview

    • 1 Readings
Show info about module content

1 Readings

  • Overview

Data Preparation and Data Types

    • 4 Videos
    • 1 Readings
Show info about module content

4 Videos

  • Data Preparation and Cleaning
  • Types of Data and Data Operations
  • Continuous vs. Discrete Variables
  • Data Parsing

1 Readings

  • Guidelines for Parsing Data

Handle Irregular, Unusable, and Incorrectly Formatted Data

    • 2 Videos
    • 2 Readings
    • 2 Lab
Show info about module content

2 Labs

  • Handling Irregular and Unusable Data
  • Correcting Data Formats

2 Videos

  • Data Irregularities
  • Correction of Data Formats and Date Conversion

2 Readings

  • Guidelines for Handling Irregular and Unusable Data
  • Guidelines for Correcting Data Formats

Deduplicate Data

    • 1 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Deduplicating Data

1 Videos

  • Deduplication

1 Readings

  • Guidelines for Deduplicating Data

Transform Text and Image Data

    • 2 Videos
    • 2 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Handling Textual Data

2 Videos

  • Word Embedding
  • Image Data Representation

2 Readings

  • Text Data Transformation Techniques
  • Guidelines for Transforming Data

Evaluate What You've Learned

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Transforming Data

1 Discussions

  • Reflect on What You've Learned

Overview

    • 1 Readings
Show info about module content

1 Readings

  • Overview

Load Data into Databases

    • 2 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Loading Data into a Database

2 Videos

  • Data Loading Considerations
  • Data Loading: Databases

1 Readings

  • Guidelines for Loading Data into Databases

Load Data into DataFrames

    • 1 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Loading Data into a DataFrame

1 Videos

  • Data Loading: DataFrames

1 Readings

  • Guidelines for Loading Data into DataFrames

Load Data into Text Files

    • 1 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Exporting Data to a CSV File

1 Videos

  • Data Loading: Text Files

1 Readings

  • Guidelines for Loading Data into Text Files

Leverage ETL Endpoints and Visualization Tools

    • 2 Videos
    • 3 Readings
Show info about module content

2 Videos

  • ETL Endpoints
  • Data Loading: Visualization Tools

3 Readings

  • Guidelines for Configuring ETL Endpoints
  • Guidelines for Loading Data into Visualization Tools
  • Exploring Data Visualization Tools

Evaluate What You've Learned

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Loading Data

1 Discussions

  • Reflect on What You've Learned

Project

    • 1 PeerReview
    • 1 Lab
Show info about module content

1 Peer Review

  • Online Retailer: Extracting, Transforming, and Loading Data

1 Labs

  • Course 2 Project

Auto Summary

Unlock the foundational phase of the data science process with the "Extract, Transform, and Load Data" course, tailored for business and data professionals. Dive into the essential techniques of ETL (Extract, Transform, Load), gaining proficiency in collecting, preparing, and cleaning data from multiple sources to ensure it is ready for analysis and modeling. Guided by experienced Coursera instructors, this professional-level course spans 900 minutes of in-depth content, covering practical skills from data extraction to its final loading destination. Ideal for those already familiar with data handling and computer programming, this course equips learners with the tools needed to seamlessly integrate and manage vast datasets. Choose between Starter and Professional subscription plans to suit your learning needs and embark on a transformative journey to mastering ETL processes in the realm of Big Data and Analytics.

Stacey McBrine
Instructors

Stacey McBrine

Sarah Haq
Instructors

Sarah Haq