Oracle Database 12c - Introduction to SQL: Data Conversion and Aggregating Data Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level 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
Expertise Level
Beginner