Course Details

Previous Page


Oracle Database 12c - Introduction to SQL: Data Conversion and Aggregating Data


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/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.

Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 12c - Introduction to SQL: Data Conversion and Aggregating Data

  • 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
  • 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
  • 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
  • write SQL statements using the TO_CHAR, TO_DATE, DECODE functions and the CASE Expression
  • write SQL statements using the GROUP BY and HAVING functions
  • Course Number:
    od_insq_a04_it_enus