COURSE

Postgres for Data Engineers

Learn about the SQL database, Postgres

This course teaches the basics of a Postgres database, a prominent database for data analysts, data scientists, and data engineers.

By the end of this course, you'll be able to:

  • Understand why moving to Postgres helps you and your team share data more effectively.
  • Create tables with Postgres from a CSV file.
  • Implement a database using best practices in security and fast query speeds.
postgres-for-data-engineers

Course Info:

Postgres for Data Engineers

Intermediate

The average completion time for this course is 10-hours.

This course requires a premium subscription. This course includes 1 free mission, 4 paid missions, 1 installation tutorial and 1 guided project.  It is the 1st course in the Data Engineer path.

START LEARNING FREE

Learn About the Postgres Database

Intro to Postgres

Learn what makes Postgres a powerful analytics database and its similarities to SQLite.

VIEW MISSION

Creating Tables

Learn how to create tables with popular data types in Postgres.

VIEW MISSION

Managing Created Tables

Learn how to manage created tables with new data.

VIEW MISSION

Loading and Extracting Data with Tables

Practice making requests to an API that requires authentication.

VIEW MISSION

User and Database Management

Learn how to manage your users and databases with Postgres.

VIEW MISSION

Project: PostgreSQL Installation

Learn how to install PostgreSQL and the Psycopg2 library.

VIEW MISSION

Storing Storm Data

Learn how to work on a real life example of storing a complex dataset in a Postgres database.

VIEW MISSION