Ementorhub

Scripting with Python and SQL for Data Engineering

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

Instructors: Alfredo Deza +2 more

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

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.

Skills you'll gain

Data Structures

Data Manipulation

Databases

Spatial Data Analysis

SQL

Python Programming

Data Capture

Scripting

JSON

Database Management

Data Storage Technologies

MySQL

Data Import/Export

Web Scraping

There are 4 modules in this course

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.

Python Scripting and SQL

Web Scraping using Python

Working with MySQL

Explore more from Data Analysis

Python, Bash and SQL Essentials for Data Engineering

Applied Data Analytics with Python and SQL

Databases and SQL for Data Science with Python

Python and Pandas for Data Engineering