• Online, Self-Paced
Course Description

Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.

Learning Objectives

Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output   

  • identify the types of SQL functions in a SQL statement and describe single-row functions
  • use character functions in a SQL statement
  • use case conversion functions in a SQL statement
  • use character manipulation functions in a SQL statement
  • use nesting functions in a SQL statement
  • use numeric ROUND and TRUNC functions in a SQL statement
  • use the MOD function in a SQL statement
  • work with dates and the RR date format in a SQL statement
  • use the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
  • use arithmetic operators with dates in a SQL statement
  • use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statement
  • use the numeric ROUND and TRUNC functions with dates
  • write a SQL statements that use character, number, and date 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.