Enterprise Data Wrangling with SQL and Python

Enterprise Data Wrangling with SQL and Python

Instructor: Tareq Nasralah

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

8 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

8 hours to complete

Flexible schedule

Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

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

There are 4 modules in this course

Welcome to Enterprise Data Wrangling with SQL and Python. This course will cover data wrangling principles and techniques for business. Key topics include data extraction, profiling, cleansing, integration, transformation, and automating data processes for business purposes. In the course, you will apply principles and techniques using data transformation tools, programming languages, and data process automation tools. The course offers you an opportunity to learn how to embed appropriate communication mechanisms for collaboration to identify and resolve real-world data challenges revealed in datasets and business processes, creating business value in today’s disparate computing and dynamic business environment.

In this module, you will learn about the structure of relational databases and how to use SQL queries for information retrieval, focusing on single-row and group functions. In the next module, you will build upon this foundation by exploring data manipulation and data joining techniques.

What's included

6 videos17 readings1 assignment

6 videosTotal 17 minutes

Meet Your Faculty2 minutes
Relational Database Data Structure3 minutes
Unique Values 3 minutes
Constraints5 minutes
Working with Text Values2 minutes
TIMESTAMP 3 minutes

17 readingsTotal 85 minutes

Course Introduction2 minutes
Syllabus - Enterprise Data Wrangling with SQL and Python10 minutes
Academic Integrity1 minute
Data Wrangling Key Questions 2 minutes
Data Wrangling Steps5 minutes
Relational Databases2 minutes
Key SQL Concepts10 minutes
Overview of Predefined Functions2 minutes
Single-Row vs. Group Functions10 minutes
Overview of Single-Row Functions1 minute
Common Examples of Single-Row Functions5 minutes
Uses of Single-Row Functions4 minutes
Single-Row Function Example10 minutes
Overview of Group Functions1 minute
Common Examples of Group Functions4 minutes
Uses of Group Functions6 minutes
Group Function Example10 minutes

1 assignmentTotal 45 minutes

Assess Your Learning: Introduction to Data Wrangling and Relational Databases45 minutes

The module also highlights how effective data manipulation and joining contribute to the broader goals of data wrangling and preparation, ensuring that data is both well-organized and ready for analysis.

What's included

22 readings1 assignment

22 readingsTotal 146 minutes

Data Manipulation Overview2 minutes
DML Core Operations10 minutes
INSERT5 minutes
Update10 minutes
Delete8 minutes
TCL Core Operations1 minute
Commit3 minutes
Rollback5 minutes
Summary Table10 minutes
Data Joining Overview2 minutes
Summary Table with Notes10 minutes
Data Joining Types Overview10 minutes
Inner Join Overview4 minutes
Inner Join Example10 minutes
Join Overview4 minutes
Left Join Example10 minutes
Right Join Overview4 minutes
Right Join Example10 minutes
Full Outer Join Overview4 minutes
Full Outer Join Example10 minutes
Cross Join Overview4 minutes
Cross Join Example10 minutes

1 assignmentTotal 45 minutes

Assess Your Learning: Managing and Retrieving Data with SQL45 minutes

In this module, you will learn how to explore datasets using Python. You’ll practice techniques to inspect dataset structure (rows, columns, and data types), and detect missing, invalid, or inconsistent data. You will also learn how to generate descriptive statistics and distribution summaries, as well as interpret profiling results to guide data cleansing and improve overall data quality.

What's included

2 videos13 readings1 assignment

2 videosTotal 6 minutes

Data Profiling3 minutes
Data Profiling Example3 minutes

13 readingsTotal 61 minutes

Data Profiling Overview10 minutes
Discovering Data Structure Overview2 minutes
Rows and Columns7 minutes
Data Type7 minutes
Non-Null Entries7 minutes
Discovering Data Content Overview3 minutes
Summary Statistics4 minutes
Descriptive Statistics4 minutes
Frequency Distribution4 minutes
Missing Values3 minutes
Duplicate Data3 minutes
Incorrect or Ambiguous Data4 minutes
Data Profiling3 minutes

1 assignmentTotal 15 minutes

Assess Your Learning: Data Profiling and Discovery15 minutes

By the end of this module, you will be able to apply practical data cleansing techniques to improve data quality and make your analysis more accurate and trustworthy.

What's included

2 videos11 readings1 assignment

2 videosTotal 3 minutes

Data Cleansing1 minute
Data Cleansing to Handle Outliers2 minutes

11 readingsTotal 29 minutes

Data Cleansing Overview2 minutes
Overview of Types of Data Issues2 minutes
Missing Values3 minutes
Duplicates3 minutes
Inconsistent Formats3 minutes
Outliers and Anomalies3 minutes
Incorrect or Invalid Values3 minutes
Data Types Conversions3 minutes
Filtering3 minutes
Data Cleansing Example2 minutes
Congratulations! 2 minutes

1 assignmentTotal 25 minutes

Assess Your Learning: Data Cleansing25 minutes

Instructor

Tareq Nasralah

Northeastern University

1 Course1 learner

Offered by

Northeastern University

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

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 purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.