Skill Path

Design Databases With PostgreSQL

Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.

Includes PostgreSQL, SQL, Databases, Back-End, Indexes, Normalization, and more.

To start this Skill Path, upgrade your plan.
This skill path includes
22,852 learners enrolled
This skill path includes

  • Skill level

    Beginner

  • Time to complete

    Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary
     
    13 hours

  • Projects

    10

  • Prerequisites

    None

About this skill path

Data is only as useful as the database it’s stored in. In this Skill Path, you will learn how to store and access relational data in PostgreSQL, an industry standard database management system used by AWS. Learn how to design efficient relational databases while using industry-standard techniques to maintain data integrity.

Skills you'll gain

  • Query databases using SQL
  • Design efficient PostgreSQL databases
  • Apply constraints to keep data intact

Syllabus

5 units • 11 lessons • 10 projects • 9 quizzes
  • 1

    What Is A Database?

    Let’s get started by learning what a database is and how to set one up on your own computer.

  • 2

    What Can I Do With A Database?

    Learn how to write basic queries to get information out of the databases you’re working with.

  • 3

    How Do I Make And Populate My Own Database?

    Learn how to properly design a database by learning about database schemas, relationships, and keys.

  • 4

    How Do I Make Sure My Database Stays Intact?

    Learn how to add constraints to your database! One of the advantages of databases is ensuring your data is entered in the format you expect.

  • 5

    How Do I Make Sure My Database Stays Fast?

    Learn how to optimize your database by using indexes and normalization.

  • Certificate of completion available with Plus or Pro

    Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.

The platform

Hands-on learning

Animated GIF of an AI provided error explanation within Codecademy's learning environment
An AI-generated hint within the instructions of a Codecademy project
Animated GIF of Codecademy's Job Readiness Checker tool generating a compatibility report for a senior software engineer role
Animated GIF of building a phone screen interview using Codecademy's Interview Simulator
A fill-in-the-blank JavaScript question in a Codecademy assessment
Explore features

Projects in this skill path

Earn a certificate of completion

Show your network you've done the work by earning a certificate of completion for each course or path you finish.
  • Show proofReceive a certificate that demonstrates you've completed a course or path.
  • Build a collectionThe more courses and paths you complete, the more certificates you collect.
  • Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.

Reviews from learners

  • The progress I have made since starting to use codecademy is immense! I can study for short periods or long periods at my own convenience - mostly late in the evenings.
    Chris
    Codecademy Learner @ USA
  • I felt like I learned months in a week. I love how Codecademy uses learning by practice and gives great challenges to help the learner to understand a new concept and subject.
    Rodrigo
    Codecademy Learner @ UK
  • Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.
    John-Andrew
    Codecademy Learner @ USA

Our learners work at

  • Google Logo
  • Meta Logo
  • Apple Logo
  • EA Logo
  • Amazon Logo
  • IBM Logo
  • Microsoft Logo
  • Reddit Logo
  • Spotify Logo
  • Uber Logo
  • YouTube Logo
  • Instagram Logo
How it works

Skill paths help you level-up

  1. 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.

  2. Get step-by-step guidance

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

  3. 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.

Ready to learn a new skill?

Get started on Design Databases With PostgreSQL with a free Codecademy account.

Looking for something else?

Related resources

Related courses and paths

Browse more topics

View full catalog

What's included in skill paths

  • Practice Projects

    Guided projects that help you solidify the skills and concepts you're learning.

  • Assessments

    Auto-graded quizzes and immediate feedback help you reinforce your skills as you learn.

  • Certificate of Completion

    Earn a document to prove you've completed a course or path that you can share with your network.
See pricing and plans