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

Oracle SQL 12c
  • 13 Videos | 1h 16m 40s
  • Includes Assessment
  • Earns a Badge
Likes 21 Likes 21
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Locked
    1. 
    Types of SQL Functions and Single-Row Functions
    5m 19s
  • Locked
    2. 
    Character Functions
    2m 12s
  • Locked
    3. 
    Case Conversion Functions
    3m 29s
  • Locked
    4. 
    Character Manipulation Functions
    9m 45s
  • Locked
    5. 
    Nesting Functions
    5m 5s
  • Locked
    6. 
    Numeric ROUND and TRUNC Functions
    6m 47s
  • Locked
    7. 
    MOD Function
    3m 29s
  • Locked
    8. 
    Working with Dates and the RR Date Format
    4m 54s
  • Locked
    9. 
    SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP
    5m 27s
  • Locked
    10. 
    Arithmetic Operators in Dates
    3m 7s
  • Locked
    11. 
    Date Manipulation Functions
    7m 16s
  • Locked
    12. 
    Using Numeric ROUND and TRUNC Functions with Dates
    4m 11s
  • Locked
    13. 
    Exercise: Use Character, Number, and Date Functions
    9m 40s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 53 Likes 53  
Likes 56 Likes 56