OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
edX logo

Scripting with Python and SQL for Data Engineering

Alfredo Deza

In this course, part of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will gain the skills to work effectively with data using Python and SQL. You will learn to:

Read more

In this course, part of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will gain the skills to work effectively with data using Python and SQL. You will learn to:

  • Leverage Python's powerful data structures to load, manipulate, and analyze data
  • Create robust Python scripts to automate data processing tasks
  • Utilize SQLite to store and retrieve data from within your Python scripts
  • Extract data from websites using web scraping techniques and persist it in databases
  • Work with MySQL databases using modern tools like VSCode to execute queries and manage data

Whether you are a data engineer, analyst, or aspiring data professional, this course will equip you with the essential skills to efficiently handle data and drive meaningful insights in today's data-driven world.

Enroll now

What's inside

Learning objectives

  • Manipulate data using python's built-in data structures
  • Create python scripts to automate data tasks
  • Use sqlite to store and query data in python
  • Extract data from websites via web scraping
  • Execute mysql queries and operations in vscode
  • Import and export data in mysql databases

Syllabus

Here is the course structure formatted with bullets for each module:
Module 1: Working with Data in Python (5 hours)
\- Videos (Total 62 minutes):
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Designed for beginners, this course lays the foundational knowledge and core skills for those seeking to enter the field of data engineering
Taught by experienced professionals in data engineering, this course conveys real-world applications and practical techniques
Delves into the practical applications of Python, Bash, and SQL, equipping learners with industry-standard tools for data analysis and engineering
May require supplemental learning for those with limited programming experience, as it assumes some prior knowledge

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical python and sql for data engineering

According to students, this course receives largely positive feedback, consistently praised for its practical, real-world applicability and effective instruction. Learners particularly value the hands-on labs and the comprehensive coverage of essential topics like Python scripting, SQLite, web scraping, and MySQL. While many find the course well-structured and foundational for data engineering, some reviewers noted the pace can be fast and it may assume prior Python knowledge, making it more suitable for those with a basic understanding than complete beginners.
Provides a solid base in Python, SQL, and web scraping.
"Offers an excellent foundational understanding for aspiring data engineers."
"The course comprehensively covers essential tools like SQLite, MySQL, and web scraping."
"I now have a solid foundation in scripting and database integration for data engineering roles."
Instructor provides clear, concise, and knowledgeable explanations.
"The instructor is clear, concise, and explains complex concepts really well."
"Alfredo Deza is fantastic; his explanations are easy to follow and very helpful."
"I found the instructor very effective in conveying the core ideas of the course."
Labs are highly effective for reinforcing concepts.
"The hands-on labs effectively reinforce learning, making the concepts stick."
"The Jupyter notebooks and practical projects are the strongest part of the course for me."
"I appreciated the ungraded labs; they were key to solidifying my understanding of the material."
Delivers immediately applicable skills for data engineering.
"This course is very practical and immediately applicable to real-world scenarios."
"Extremely useful. It covers scripting, databases, and offers real-world applications."
"I learned how to automate data processing tasks, which has been incredibly useful in my work."
Course pace can be fast, requiring prior Python and SQL basics.
"I felt the course was rushed, and some explanations were superficial, requiring prior Python knowledge."
"This course assumes too much prior knowledge, making it challenging for true beginners."
"I found the pace a bit too quick, especially in certain sections; I had to rewatch videos multiple times."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Scripting with Python and SQL for Data Engineering with these activities:
Join a study group or online forum for Python and data engineering discussions
Engage with peers and experts in the field by actively participating in discussions, sharing knowledge, and collaborating on projects.
Browse courses on Python
Show steps
  • Identify and join relevant study groups or online forums
  • Participate in discussions, ask questions, and share your insights
  • Collaborate on projects or group challenges
Review basic Python skills
Let's brush up on the fundamentals of Python programming to ensure you have the necessary foundational skills for this course.
Browse courses on Python
Show steps
  • Review variables and data types
  • Practice writing and executing simple Python scripts
  • Create a few basic functions and classes
Complete an online Python tutorial
Deepen your understanding of Python by following a guided tutorial that covers data structures and their applications.
Browse courses on Python
Show steps
  • Identify a reputable online tutorial or course
  • Follow the tutorial step-by-step, practicing the concepts
  • Complete any exercises or assignments provided in the tutorial
Five other activities
Expand to see all activities and additional details
Show all eight activities
Attend a Python workshop focused on data engineering
Advance your knowledge and skills in Python and data engineering by attending a specialized workshop led by industry experts.
Browse courses on Python
Show steps
  • Research and identify relevant workshops
  • Register and attend the workshop
  • Actively participate in discussions, demos, and hands-on exercises
Solve Python coding challenges
Challenge yourself with Python coding challenges to reinforce your grasp of data structures and algorithms.
Browse courses on Python
Show steps
  • Join an online coding platform like LeetCode or HackerRank
  • Select coding challenges appropriate to your skill level
  • Solve the challenges, referring to documentation or online forums when needed
Create a Python script to automate a data processing task
Solidify your Python skills by creating a project that leverages data manipulation and automation techniques.
Browse courses on Python
Show steps
  • Identify a data processing task that can be automated
  • Design a solution using Python and appropriate libraries
  • Write the Python script, incorporating functions and data structures as needed
  • Test and refine the script to ensure accurate and efficient data processing
Develop a dashboard to visualize data using Python
Combine your Python skills with data visualization techniques to create an interactive dashboard that effectively communicates data insights.
Browse courses on Python
Show steps
  • Gather and clean the necessary data
  • Choose an appropriate Python library for data visualization
  • Design and develop the dashboard layout and visualizations
  • Deploy the dashboard for sharing and presentation
Participate in a Python-based hackathon or competition
Engage in a competitive environment to showcase your Python skills and expand your knowledge in practical applications of data science or machine learning.
Browse courses on Python
Show steps
  • Identify and register for an appropriate hackathon or competition
  • Form a team or work individually on the challenge
  • Develop a solution using Python and relevant technologies
  • Present or submit your solution for evaluation

Career center

Learners who complete Scripting with Python and SQL for Data Engineering will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Scripting with Python and SQL for Data Engineering.
Python Data Analysis
Most relevant
Introduction to C# Programming and Unity
Most relevant
Python Data Representations
Most relevant
Python Data Visualization
Most relevant
SQL for Data Science
Most relevant
Delivery Problem
Most relevant
Data Analytics Foundations for Accountancy I
Most relevant
Introduction to Graph Theory
Most relevant
Combinatorics and Probability
Most relevant

edX Buyer Protection & Guarantee

Verified partner policies & purchase protections

World-Class University Partner
Free Trial & Audit

Free Audit Track Available

Free audit track available for most courses, giving open access to video lectures, course readings, and assignments at no charge.

Return & Refund Policy

14-Day Full Refund Window

14-day full refund available up to 14 days after course start or 14 days after payment (whichever comes second, up to 6 months max), provided verified certificate has not yet been earned.

Buyer Protections

Verified Academic & Industry Partner

University-backed credentials authored by elite institutions like Harvard, MIT, and Oxford, with tamper-proof certificate verification.

Key Purchase Protections
Free audit track for open learning access
14-day money-back guarantee on verified certificates
Prestigious university credentials (Harvard, MIT)
Automatic unenrollment refund process via dashboard
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
3 to 6 hours per week for 4 weeks
Level
Introductory
Via
edX
Institution
Pragmatic AI Labs
Instructor
Alfredo Deza
Language
English
Transcript
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Designed for beginners, this course lays the foundational knowledge and core skills for those seeking to enter the field of data engineering
Taught by experienced professionals in data engineering, this course conveys real-world applications and practical techniques
Delves into the practical applications of Python, Bash, and SQL, equipping learners with industry-standard tools for data analysis and engineering
May require supplemental learning for those with limited programming experience, as it assumes some prior knowledge
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Scripting with Python and SQL for Data Engineering.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser