skill PathDesign Databases With PostgreSQL

Data is only as useful as the database it’s stored in. With PostgreSQL, you can design an elegant relational database management system that’s a breeze to use. That’s why it’s the industry standard used by AWS — making it not only popular with data scientists but backend engineers, too.

To start this skill Path, sign up for Codecademy Pro.

30 hours


PostgreSQL, SQL, Databases, Back-End, Indexes, Normalization


Beginners welcome

For those who want to

  • Create their own databases from scratch
  • Optimize a database
  • Learn best practices for database design


Certificate of Completion

What will you be able to do?

Here are just a few things you’ll be able to do with this skill.

What will you be able to do?

Here are just a few things you’ll be able to do with this skill.

Design Elegant Databases

Learn how to design a database that’s a perfect fit for your data.

Optimize Your Database

Understand the pros and cons of indexes to make your database as fast as possible.

Run PostgreSQL

Set up a database server on your own computer for easy access.

You really feel like there's nothing you can't learn, which in turn builds so much confidence in your skills and gives the momentum to keep learning.

Codecademy Learner

How are Skill Paths different?

Get a specialized skill.

Want to level up at work? Gain a practical, real-world skill that you can use right away to stand out at your job.

Get step-by-step guidance.

We guide you through exactly where to start and what to learn next to build a new skill.

Get there quickly.

We’ve hand-picked the content in each Skill Path to fast-track your journey and help you gain a new skill in just a few months.

Codecademy Pro

To get Skill Paths, sign up for Codecademy Pro. With Pro, you’ll have unlimited access to everything you need to take your learning to the next level.

Codecademy Pro on desktop and mobile devices

Ready to learn a whole new skill?