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

Oracle SQL 12c    |    Beginner
  • 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.