Lesson 2 of 8

Modify data with a secure DML

Master INSERT, UPDATE, DELETE and UPSERT with a controlled perimeter.

36 minAdvanced SQL with PostgreSQL

By the end of this lesson

  • Preview a UPDATE
  • Use RETURNING
  • Write an idempotent UPSERT

SQL Pro

Continue with the right access

“Modify data with a secure DML” is included from SQL Pro.

30 free days of SQL Pro on registration, subject to the 32 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.