• Online, Self-Paced
Course Description

Frequently when retrieving data stored in the Oracle database it needs to be converted, manipulated, or aggregated. In this course you will learn about the Oracle conversion functions, conditional expressions, and how to report aggregated data using group functions. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Learning Objectives

Conversion and Conditional Functions

  • start the course
  • 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
  • describe elements of the Date Format Model in SQL
  • use the TO_CHAR Function to convert a number to a character datatype in a SQL statement
  • Use the TO_NUMBER and TO_DATE function 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 pertaining to null values
  • use the NVL and NVL2 function when working with null values in a SQL statement
  • use the NULLIF and COALESCE functions when working with null values in a SQL statement
  • use 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

 

Aggregated Data and Group Functions

  • describe how to use group functions to return one result based on a set of rows in a SQL statement
  • use the AVG and SUM functions to group numeric data in a SQL statement
  • use the MIN and MAX functions to group numeric, character, and date data types in a SQL statement
  • use the COUNT and COUNT DISTINCT functions in a SQL statement
  • work with null values when grouping a set of rows in a SQL statement
  • create groups of data in a SQL statement

 

Using GROUP BY

  • describe how to create groups of data and work with the GROUP BY clause in a SQL statement
  • use with the GROUP BY clause on multiple columns in a SQL statement
  • describe illegal queries when using the GROUP BY function in a SQL statement
  • use the HAVING clause to restrict grouped rows returned in a SQL statement
  • use nesting of group functions to a depth of two functions in a SQL statement

 

Practice: Functions and Conditional Expressions

  • write SQL statements using the TO_CHAR, TO_DATE, DECODE functions and the CASE Expression

 

Practice: Working with Group Functions

  • write SQL statements using the GROUP BY and HAVING 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.