PostgreSQL Fundamentals/ INMS Data ImportLESSON 19 OF 28Log inSubscribe
Concept: Constraints lesson slide
LESSON 19 OF 28 · IN THE FULL COURSE

This one's part of the full course

Good to see you. This one's in the full course

4 lessons are free to watch right now, no account needed. If they click, grab the course and every lesson is yours to keep.

You've seen how I teach. The other 24 lessons are in the full course, and your progress comes with you.

WATCH THESE FREE, NO ACCOUNT NEEDEDYOUR FREE LESSONS

Already bought it? Log in and it picks up right here.

Your progress comes with you the moment you buy.

INMS Data Import · LESSON 19

Concept: Constraints

THE COURSE, END TO ENDNow playingDoneAheadYou are hereFree to watchIn the full course
Introduction
Extraction
Find the Flybys
INMS Data Import
Analysis
ABOUT THIS LESSON

We have a number of constraints on our table and we really should understand what they do at a deeper level. In this video we’ll dive into the constraint code below.

create table inms(
  id bigserial primary key,
  created_at timestamp not null,
  altitude numeric(9,2) not null check(altitude > 0),
  source text not null check(source in('osi','csn','osnb','osnt'))
  mass numeric(6,3) not null check(mass >=0.125 and mass < 100),
  high_sensitivity_count int not null check(high_sensitivity_count > 0),
  low_sensitivity_count int not null check(low_sensitivity_count > 0)
);
28lessons across 5 sections
4free to watch right now
Foreverbuy it once, it's yours for life

28 lessons · 2.1 hours · all done

You finished PostgreSQL Fundamentals.

Every lesson, start to finish. That takes some doing, and you did it. Now go build something with it.

Cheers! Rob