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
Udacity Ad

Master AI & Data—50% Off Udacity (Code CC50)

Learn More → Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.