Scripting with Python and SQL for Data Engineering (Coursera)

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.

Course 3 of 4 in the Python, Bash and SQL Essentials for Data Engineering Specialization.

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.

Syllabus

WEEK 1

Working with Data in Python

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.

WEEK 2

Python Scripting and SQL

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.

WEEK 3

Web Scraping using Python

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.

WEEK 4

Working with MySQL

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.