Course

You'll learn how to:

Start this course today

Build hands-on data skills with interactive exercises and projects.

Sign up

About this course

Learn about the SQL database Postgres and find out what data engineering is all about in our Postgres for Data Engineers course.

In this course, we will explore why moving to Postgres helps you and your team share data more effectively and you will practice implementing a database using best practices in security and fast query speeds.

You will learn about the Postgres database and what makes it different from SQLite, proper datatypes for your data and why having proper datatypes is important, how to manage tables in Postgres, and more. You will also install PostgreSQL on your own machine and learn how to work with psycopg2, a Python database API for Postgres that allows you to interact with Postgres databases using Python.

At the end of the course, you’ll complete a project in which you will work on a real-life example of storing storm data in a Postgres database. This project is a chance for you to combine the skills you learned in this course and practice storing complex data into a Postgres database. This project also serves as a portfolio project that you can showcase for potential future employers to demonstrate your data engineering skills.

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.

Lessons in this course

Loading lessons....

Thousands of learners have changed their careers with Dataquest

97%

Learners who recommend
Dataquest for career advancement

4.9 stars

Dataquest rating on
G2Crowd and SwitchUp

$30k

Average salary boost
for learners who complete a path

Join a community of 1M+ data learners on Dataquest

1

Sign up for a free account

Get access to hundreds of free lessons.

2

Choose a course or path

Start anywhere, from beginner topics to advanced concepts.

3

Learn with hands-on exercises

Learn with real data and build your experience.

Apply your skills

Create projects, build your portfolio, and build your career.

Sign up today

or