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

egghead.io

Get Started With PostgreSQL

via egghead.io

Overview

It’s amazing how much you can accomplish with a basic knowledge of SQL. In this course we’ll learn how to store lots of information (many millions of things!) and answer nearly any question we might have about that information (on the order of milliseconds!)
We’ll learn enough to make you say you “know SQL” -- table creation, inserts, selects, updates, deletes, aggregations, indexes, joins, and constraints. Along the way we’ll model real world problems so that you can see just how powerful SQL will make you!
If you’re interested in the Postgres client that is used in this course you can download it here to check it out and follow along.

Syllabus

  • Create a Postgres Table
  • Insert Data into Postgres Tables
  • Filter Data in a Postgres Table with Query Statements
  • Update Data in Postgres
  • Delete Postgres Records
  • Group and Aggregate Data in Postgres
  • Sort Postgres Tables
  • Ensure Uniqueness in Postgres
  • Use Foreign Keys to Ensure Data Integrity in Postgres
  • Create Foreign Keys Across Multiple Fields in Postgres
  • Enforce Custom Logic with Check Constraints in Postgres
  • Speed Up Postgres Queries with Indexes
  • Find Intersecting Data with Postgres’ Inner Join
  • Select Distinct Data in Postgres

Taught by

Brett Cassette

Reviews

4.3 rating at egghead.io based on 73 ratings

Start your review of Get Started With PostgreSQL

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.