Lesson 6 of 8

Encapsulate logic with functions and procedures

Choose a reusable object without hiding logic unnecessarily.

42 minAdvanced SQL with PostgreSQL

By the end of this lesson

  • Distinguish function and procedure
  • Declare parameters and result
  • Test edge cases

SQL Pro

Continue with the right access

“Encapsulate logic with functions and procedures” 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.