When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Certificate?

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.

Extract, Transform, and Load Data

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

Instructors: Stacey McBrine

5,555 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

39 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.

39 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

91%

of learners achieved a positive career outcome

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.

Module details

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 videosTotal 66 minutes

Course Intro: Extract, Transform, and Load Data3 minutes
Structure of Data7 minutes
Terms Describing Portions of Data3 minutes
Big Data5 minutes
Data Sources6 minutes
Public APIs and Web Scraping7 minutes
Data Read from Cloud Storage4 minutes
Extract, Transform, and Load (ETL)8 minutes
CSV Files4 minutes
SQL Queries7 minutes
NoSQL Queries6 minutes
Data Consolidation and Joins6 minutes

7 readingsTotal 60 minutes

Overview2 minutes
Get help and meet other learners. Join your Community!5 minutes
Open Datasets20 minutes
Guidelines for Reading Data from CSV Files3 minutes
Guidelines for Extracting Data with Database Queries10 minutes
Inner Join Example15 minutes
Guidelines for Consolidating Data from Multiple Sources5 minutes

1 assignmentTotal 30 minutes

Extracting Data30 minutes

1 discussion promptTotal 5 minutes

Reflect on What You've Learned5 minutes

3 ungraded labsTotal 95 minutes

Reading Data from CSV Files20 minutes
Extracting Data with Database Queries45 minutes
Consolidating Data from Multiple Sources30 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 videosTotal 55 minutes

Data Preparation and Cleaning7 minutes
Types of Data and Data Operations7 minutes
Continuous vs. Discrete Variables5 minutes
Data Parsing2 minutes
Data Irregularities9 minutes
Correction of Data Formats and Date Conversion9 minutes
Deduplication4 minutes
Word Embedding8 minutes
Image Data Representation4 minutes

7 readingsTotal 60 minutes

Overview2 minutes
Guidelines for Parsing Data3 minutes
Guidelines for Handling Irregular and Unusable Data10 minutes
Guidelines for Correcting Data Formats15 minutes
Guidelines for Deduplicating Data5 minutes
Text Data Transformation Techniques15 minutes
Guidelines for Transforming Data10 minutes

1 assignmentTotal 30 minutes

Transforming Data30 minutes

1 discussion promptTotal 5 minutes

Reflect on What You've Learned5 minutes

4 ungraded labsTotal 145 minutes

Handling Irregular and Unusable Data20 minutes
Correcting Data Formats30 minutes
Deduplicating Data20 minutes
Handling Textual Data75 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 videosTotal 25 minutes

Data Loading Considerations5 minutes
Data Loading: Databases3 minutes
Data Loading: DataFrames6 minutes
Data Loading: Text Files4 minutes
ETL Endpoints4 minutes
Data Loading: Visualization Tools2 minutes

7 readingsTotal 55 minutes

Overview2 minutes
Guidelines for Loading Data into Databases5 minutes
Guidelines for Loading Data into DataFrames3 minutes
Guidelines for Loading Data into Text Files15 minutes
Guidelines for Configuring ETL Endpoints5 minutes
Guidelines for Loading Data into Visualization Tools5 minutes
Exploring Data Visualization Tools20 minutes

1 assignmentTotal 30 minutes

Loading Data30 minutes

1 discussion promptTotal 5 minutes

Reflect on What You've Learned5 minutes

3 ungraded labsTotal 60 minutes

Loading Data into a Database20 minutes
Loading Data into a DataFrame20 minutes
Exporting Data to a CSV File20 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 Courses26,033 learners

Offered by

CertNexus

Extract, Transform, and Load Data

Extract, Transform, and Load Data

Skills you'll gain

Details to know

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

Build your Data Analysis expertise

There are 4 modules in this course

Extract Data

What's included

Transform Data

What's included

Load Data

What's included

Apply What You've Learned

What's included

Earn a career certificate

Instructors

Offered by

Explore more from Data Analysis

Data Extract, Transform, and Load in Power BI

ETL Testing Basics for Databases

The Path to Insights: Data Models and Pipelines

Extract, Transform and Load Data in Power BI

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Learner reviews

Unlock access to 10,000+ courses with a subscription

Advance your career with an online degree

Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Certificate?

More questions