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

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

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

Similar courses are unavailable at this time. Please try again later.
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