Predefined FunctionsΒΆ

Let us go through the functions that can be used while processing the data. These are typically applied on columns to get derived values from existing column values.

  • Overview of Functions

  • Validating Functions

  • String Manipulation Functions

  • Date Manipulation Functions

  • Overview of Numeric Functions

  • Data Type Conversion

  • Handling NULL Values

  • Using CASE and WHEN

  • Query Example - Word Count

Exercise - Partitioned Tables Overview of Functions