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

Oracle SQL 12c    |    Beginner
  • 13 videos | 1h 6m 54s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 42 users Rating 4.7 of 42 users (42)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 5m 44s
    Upon completion of this video, you will be able to describe the use of implicit and explicit data conversion within SQL statements. FREE ACCESS
  • 5m 22s
    In this video, find out how to use the TO_CHAR function to convert a date to a character data type in an SQL statement. FREE ACCESS
  • Locked
    3.  Date Format Model
    5m 51s
    Learn about elements of the Date Format Model in SQL. FREE ACCESS
  • Locked
    4.  Use the TO_CHAR Function with Numbers
    5m 20s
    In this video, you will learn how to use the TO_CHAR function to convert a number to a character data type in an SQL statement. FREE ACCESS
  • Locked
    5.  TO_NUMBER and TO_DATE Functions
    5m 1s
    Learn how to use the TO_NUMBER and TO_DATE functions to convert character data types to number or date formats in SQL statements. FREE ACCESS
  • Locked
    6.  Use TO_CHAR and TO_DATE with RR Date Format
    4m 38s
    In this video, you will learn how to use the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in a SQL statement. FREE ACCESS
  • Locked
    7.  General Functions
    4m 21s
    Upon completion of this video, you will be able to describe general functions when working with data and how they pertain to NULL values. FREE ACCESS
  • Locked
    8.  NVL and NVL2 Functions
    5m 22s
    In this video, learn how to use the NVL and NVL2 functions when working with NULL values in SQL statements. FREE ACCESS
  • Locked
    9.  NULLIF and COALESCE Functions
    7m 21s
    During this video, you will learn how to use the NULLIF and COALESCE functions when working with NULL values in SQL statements. FREE ACCESS
  • Locked
    10.  Conditional Expressions
    2m 6s
    Find out how to use the IF-THEN-ELSE logic in a SQL statement to describe conditional expressions. FREE ACCESS
  • Locked
    11.  CASE Expression
    5m 18s
    In this video, you will use the CASE expression to facilitate a conditional inquiry in a SQL statement. FREE ACCESS
  • Locked
    12.  Using the DECODE Function
    3m 28s
    In this video, find out how to use the DECODE function to make conditional inquiry in a SQL statement. FREE ACCESS
  • Locked
    13.  Exercise: Apply Conversions
    7m 4s
    Find out how to apply conversions and conditional functions. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Oracle Database Administration
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Channel Oracle RAC
Channel Oracle Database 12c: RAC and Grid Infrastructure Administration
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
Course Relational Database Concepts
Rating 4.4 of 649 users Rating 4.4 of 649 users (649)
Course Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Rating 4.5 of 36 users Rating 4.5 of 36 users (36)