AllonData Academy, Simplify the Complexity

Single-Row Functions

36 items

  • CASE / Conditional Logic2 items
    • CASE
    • IF
  • Character Functions15 items
    • UPPER()
    • LOWER()
    • INITCAP()
    • SUBSTR()
    • INSTR()
    • LPAD()
    • RPAD()
    • LTRIM()
    • RTRIM()
    • TRIM()
    • CONCAT()
    • REPLACE()
    • TRANSLATE()
    • REVERSE()
    • LENGTH()
  • Number Functions5 items
    • ROUND()
    • TRUNC()
    • MOD()
    • POWER()
    • ABS()
  • Date Functions9 items
    • CURRENT_DATE()
    • DATE_ADD()
    • DATE_SUB()
    • DATE_DIFF()
    • DATE_TRUNC()
    • EXTRACT()
    • LAST_DAY()
    • FORMAT_DATE()
    • PARSE_DATE()
  • Conversion Functions2 items
    • CAST()
    • EXTRACT()
  • General / NULL Functions3 items
    • IFNULL()
    • NULLIF()
    • COALESCE()
Full curriculumDownload Curriculum