Extract, Transform, and Load Data

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Extract, Transform, and Load Data

Name: Extract, Transform, and Load Data
Rating: 4.7894736842105265 (38 reviews)

This course is part of CertNexus Certified Data Science Practitioner Professional Certificate

Instructors: Stacey McBrine

5,475 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

38 reviews

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

38 reviews

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

3 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the CertNexus Certified Data Science Practitioner Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from CertNexus

There are 4 modules in this course

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.

The first truly hands-on technical phase of the data science process is actually a combination of related tasks known as extract, transform, and load (ETL). This is where you, the data science practitioner, start to mold and shape the data so that it can be as useful as possible for the later steps in the data science process. In this course, you'll go through each ETL task in order, starting with "E" (extract).

What's included

12 videos7 readings1 assignment1 discussion prompt3 ungraded labs

12 videos Total 66 minutes

Course Intro: Extract, Transform, and Load Data 3 minutes
Structure of Data 7 minutes
Terms Describing Portions of Data 3 minutes
Big Data 5 minutes
Data Sources 6 minutes
Public APIs and Web Scraping 7 minutes
Data Read from Cloud Storage 4 minutes
Extract, Transform, and Load (ETL) 8 minutes
CSV Files 4 minutes
SQL Queries 7 minutes
NoSQL Queries 6 minutes
Data Consolidation and Joins 6 minutes

7 readings Total 60 minutes

Overview 2 minutes
Get help and meet other learners. Join your Community! 5 minutes
Open Datasets 20 minutes
Guidelines for Reading Data from CSV Files 3 minutes
Guidelines for Extracting Data with Database Queries 10 minutes
Inner Join Example 15 minutes
Guidelines for Consolidating Data from Multiple Sources 5 minutes

1 assignment Total 30 minutes

Extracting Data 30 minutes

1 discussion prompt Total 5 minutes

Reflect on What You've Learned 5 minutes

3 ungraded labs Total 95 minutes

Reading Data from CSV Files 20 minutes
Extracting Data with Database Queries 45 minutes
Consolidating Data from Multiple Sources 30 minutes

The next step in the ETL process is transformation. You'll spend this next module adjusting your data so that it's in a more useful state.

What's included

9 videos7 readings1 assignment1 discussion prompt4 ungraded labs

9 videos Total 55 minutes

Data Preparation and Cleaning 7 minutes
Types of Data and Data Operations 7 minutes
Continuous vs. Discrete Variables 5 minutes
Data Parsing 2 minutes
Data Irregularities 9 minutes
Correction of Data Formats and Date Conversion 9 minutes
Deduplication 4 minutes
Word Embedding 8 minutes
Image Data Representation 4 minutes

7 readings Total 60 minutes

Overview 2 minutes
Guidelines for Parsing Data 3 minutes
Guidelines for Handling Irregular and Unusable Data 10 minutes
Guidelines for Correcting Data Formats 15 minutes
Guidelines for Deduplicating Data 5 minutes
Text Data Transformation Techniques 15 minutes
Guidelines for Transforming Data 10 minutes

1 assignment Total 30 minutes

Transforming Data 30 minutes

1 discussion prompt Total 5 minutes

Reflect on What You've Learned 5 minutes

4 ungraded labs Total 145 minutes

Handling Irregular and Unusable Data 20 minutes
Correcting Data Formats 30 minutes
Deduplicating Data 20 minutes
Handling Textual Data 75 minutes

The last step in the ETL process is loading. In this module, you'll take the data you transformed and put it into a destination format and location, where it will be ready for you to work on as the project progresses.

What's included

6 videos7 readings1 assignment1 discussion prompt3 ungraded labs

6 videos Total 25 minutes

Data Loading Considerations 5 minutes
Data Loading: Databases 3 minutes
Data Loading: DataFrames 6 minutes
Data Loading: Text Files 4 minutes
ETL Endpoints 4 minutes
Data Loading: Visualization Tools 2 minutes

7 readings Total 55 minutes

Overview 2 minutes
Guidelines for Loading Data into Databases 5 minutes
Guidelines for Loading Data into DataFrames 3 minutes
Guidelines for Loading Data into Text Files 15 minutes
Guidelines for Configuring ETL Endpoints 5 minutes
Guidelines for Loading Data into Visualization Tools 5 minutes
Exploring Data Visualization Tools 20 minutes

1 assignment Total 30 minutes

Loading Data 30 minutes

1 discussion prompt Total 5 minutes

Reflect on What You've Learned 5 minutes

3 ungraded labs Total 60 minutes

Loading Data into a Database 20 minutes
Loading Data into a DataFrame 20 minutes
Exporting Data to a CSV File 20 minutes

You'll work on a project in which you'll apply your knowledge of the material in this course to a practical scenario.

What's included

1 peer review1 ungraded lab

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Instructor ratings

(8 ratings)

Stacey McBrine

8 Courses 25,023 learners

Offered by

CertNexus

Explore more from Data Analysis

Status: Free Trial
Microsoft
Data Extract, Transform, and Load in Power BI
Course
Status: Preview
Coursera
ETL Testing Basics for Databases
Course
Status: Free Trial
Google
The Path to Insights: Data Models and Pipelines
Course
Status: Free Trial
Microsoft
Extract, Transform and Load Data in Power BI
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
84.21%
4 stars
13.15%
3 stars
0%
2 stars
2.63%
1 star
0%

Showing 3 of 38

Reviewed on Apr 16, 2024

The course provides knowledge from basic about ETL and its db

Reviewed on Aug 24, 2024

Ce cours est très utile pour apprendre le processus d'ETL.

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.