• Online, Self-Paced
Course Description

Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.

Learning Objectives

Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions

  • describe the use of implicit and explicit data conversion within SQL statements
  • use the TO_CHAR function to convert a date to a character data type in a SQL statement
  • demonstrate elements of the Date Format Model in SQL
  • use the TO_CHAR function to convert a number to a character data type in a SQL statement
  • use the TO_NUMBER and TO_DATE functions to convert a character data type to a number or date format in a SQL statement
  • use the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in a SQL statement
  • describe general functions when working with data and how it pertains to NULL values
  • use the NVL and NVL2 functions when working with NULL values in a SQL statement
  • use the NULLIF and COALESCE functions when working with NULL values in a SQL statement
  • describe conditional expressions to provide the use of the IF-THEN-ELSE logic in a SQL statement
  • use the CASE expression to facilitate a conditional inquiry in a SQL statement
  • use the DECODE function to facilitate conditional inquiry in a SQL statement
  • apply conversions and conditional functions

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.