Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Changing Data: PostgreSQL: Uncharted

Courses PostgreSQLChanging Data

Changing Data

Insert, update, delete, return, upsert, and group related PostgreSQL changes into transactions.

PostgreSQL
Unit 8 of 12
10 lessons
93 min
220 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

10 total

1Inserting RowsInsert one complete row with an explicit column list.CodeConcept8 min20 XPOpen
2Inserting ManyInsert several literal rows and copy rows produced by a SELECT query.CodeConcept10 min20 XPOpen
3Updating RowsUpdate a selected group of rows with an expression based on each current value.CodeConcept8 min20 XPOpen
4The WHERE You ForgotPredict how an UPDATE or DELETE changes when its WHERE clause is omitted.InteractiveConcept7 min20 XPOpen
5Deleting RowsDelete one intended row while respecting foreign-key protection.CodeConcept9 min20 XPOpen
6RETURNING What ChangedReturn identifying fields plus the previous and new row images from an update.CodeConcept8 min20 XPOpen
7Insert or Update: ON CONFLICTUse an upsert to insert new points or add them to an existing unique row.CodeConcept10 min20 XPOpen
8All or Nothing: TransactionsRoll back a rehearsal, then commit two dependent balance changes as one unit.CodeConcept10 min20 XPOpen
9Changing Data WorkoutInsert a customer, an order, and its items inside one transaction.CodePractice11 min20 XPOpen
10Changing Data Mastery CheckCombine inserts, scoped changes, an upsert, RETURNING, and a transaction.CodeMastery check12 min40 XPOpen

Building Tables Queries Inside Queries