Predefined Functions

Let us go through the pre-defined functions available in Postgresql.

• Overview of Pre-Defined Functions

• String Manipulation Functions

• Date Manipulation Functions

• Overview of Numeric Functions

• Data Type Conversion

• Handling Null Values

• Using CASE and WHEN

• Exercises - Pre-Defined Functions

Here are the key objectives of this section.

• How to use official documentation of Postgres to get syntax and symantecs of the pre-defined functions?

• Understand different categories of functions

• How to use functions effectively using real world examples?

• How to manipulate strings and dates?

• How to deal with nulls, convert data types etc?

• Self evaluate by solving the exercises by using multiple functions in tandem.