The Four-Year Degree Isn't Dying — It's Evolving

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

Design Databases With PostgreSQL

via Codecademy Path

Go to class Write review
Noble Desktop Ad

Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes

Learn More → Boot.dev Ad

Stuck in Tutorial Hell? Learn Backend Dev the Right Way

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off your first 3 months — limited time.
Unlock All Certificates
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.

Syllabus

  • What Is A Database?
    • Let's get started by learning what a database is and how to set one up on your own computer.
  • What Can I Do With A Database?
    • Learn how to write basic queries to get information out of the databases you're working with.
  • How Do I Make And Populate My Own Database?
    • Learn how to properly design a database by learning about database schemas, relationships, and keys.
  • 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.
  • How Do I Make Sure My Database Stays Fast?
    • Learn how to optimize your database by using indexes and normalization.

Reviews

Start your review of Design Databases With PostgreSQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.