Duke University
Scripting with Python and SQL for Data Engineering
Duke University

Scripting with Python and SQL for Data Engineering

This course is part of Python, Bash and SQL Essentials for Data Engineering Specialization

Taught in English

Some content may not be translated

Alfredo Deza
Kennedy Behrman
Noah Gift

Instructors: Alfredo Deza

10,297 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.5

(75 reviews)

Intermediate level

Recommended experience

23 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Extract data from different sources and map it to Python data structures.

  • Design Scripts to connect and query a SQL database from within Python.

  • Apply scraping techniques to read and extract data from a website.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.5

(75 reviews)

Intermediate level

Recommended experience

23 hours (approximately)
Flexible schedule
Learn at your own pace

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

Placeholder

Build your subject-matter expertise

This course is part of the Python, Bash and SQL Essentials for Data Engineering Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • 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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

This week, you will learn how to effectively use Python’s data structures to load, persist, and iterate over data. You will apply these data structures to solve different problems when working with popular data formats like JSON.

What's included

19 videos8 readings2 quizzes1 discussion prompt2 ungraded labs

This week, you will learn how to use Python scripting techniques to work with SQL. You will create a database, store data, and query that data with SQL from Python.

What's included

15 videos7 readings1 quiz3 ungraded labs

This week, you will learn how to efficiently extract data from the web. You will learn how to use a scraping library to read data from websites and identify and extract specific values from it.

What's included

15 videos7 readings1 quiz2 ungraded labs

This week, you will learn how to use a modern development environment and editor to connect to a MySQL database server, execute queries and perform database operations.

What's included

18 videos7 readings1 quiz5 ungraded labs

Instructors

Instructor ratings
4.2 (10 ratings)
Alfredo Deza
Duke University
24 Courses49,029 learners

Offered by

Duke University

Recommended if you're interested in Data Analysis

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

Showing 3 of 75

4.5

75 reviews

  • 5 stars

    69.33%

  • 4 stars

    20%

  • 3 stars

    4%

  • 2 stars

    1.33%

  • 1 star

    5.33%

PB
4

Reviewed on May 26, 2023

MB
5

Reviewed on Aug 29, 2022

CQ
5

Reviewed on Oct 21, 2022

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

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

Advance your career with an online degree

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

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

Upskill your employees to excel in the digital economy

Frequently asked questions