In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data. Finally, you will use extracted data from websites using scraping techniques. These skills will allow you to work effectively when data is not readily available, or when spatial queries are required to extract useful information from databases.
This course is part of the Python, Bash and SQL Essentials for Data Engineering Specialization
5,610 already enrolled
Offered By
About this Course
25,164 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 4 in the
Intermediate Level
Some experience with Python programming (<1 year)
Approx. 19 hours to complete
English
What you will 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.
Skills you will gain
- Database (DBMS)
- Python Programming
- Web Scraping
- MySQL
- SQL
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 4 in the
Intermediate Level
Some experience with Python programming (<1 year)
Approx. 19 hours to complete
English
Offered by
Syllabus - What you will learn from this course
5 hours to complete
Working with Data in Python
5 hours to complete
19 videos (Total 62 min), 4 readings, 2 quizzes
5 hours to complete
Python Scripting and SQL
5 hours to complete
15 videos (Total 56 min), 2 readings, 1 quiz
5 hours to complete
Web Scraping using Python
5 hours to complete
15 videos (Total 65 min), 3 readings, 1 quiz
4 hours to complete
Working with MySQL
4 hours to complete
11 videos (Total 37 min), 2 readings, 1 quiz
Reviews
- 5 stars79.59%
- 4 stars14.28%
- 1 star6.12%
TOP REVIEWS FROM SCRIPTING WITH PYTHON AND SQL FOR DATA ENGINEERING
by BMAug 28, 2022
This provides the essentials of data engineering and analysis.
by CQOct 20, 2022
Covered great Python. data engineering techniques as well as using SQLite and MySQL in VSCode
About the Python, Bash and SQL Essentials for Data Engineering Specialization

Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.