Oracle Database 12c R2 SQL: Restricting & Sorting Data

Oracle SQL 12c    |    Beginner
  • 12 Videos | 59m 40s
  • 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.