Oracle Database 12c R2 SQL: Restricting & Sorting Data

Oracle SQL 12c    |    Beginner
  • 12 Videos | 1h 5m 10s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.

WHAT YOU WILL LEARN

  • describe the limiting of rows selected in a query and how to use the WHERE clause in a SQL statement
    use character strings and dates in a WHERE clause in a SQL statement
    use the comparison operators in a WHERE clause in a SQL statement
    use the BETWEEN and IN operators in a WHERE clause in a SQL statement
    use the LIKE operator and combine wildcard characters in a WHERE clause in a SQL statement
    use the NULL and logical operator conditions in a WHERE clause in a SQL statement
  • use the AND, OR, and NOT operators in a WHERE clause in a SQL statement
    define the rules of precedence in a WHERE clause in a SQL statement
    use the ORDER BY clause to sort the data returned by a SQL statement
    use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement
    use substitution variables
    manipulate data using SQL

IN THIS COURSE

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE