Restricting Output

Oracle 12c    |    Beginner
  • 10 videos | 44m 49s
  • Earns a Badge
Likes 93 Likes 93
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.

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

IN THIS COURSE

  • Locked
    1.  Limiting Selected Rows and Using the WHERE Clause
    3m 34s
    After completing this video, you will be able to describe how to limit the rows selected in a query and how to use the WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    2.  Character Strings and Dates
    4m 37s
    In this video, find out how to use character strings and dates in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    3.  Comparison Operators
    3m 5s
    In this video, learn how to use comparison operators in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    4.  BETWEEN and IN Operators
    4m 16s
    To use the BETWEEN and IN operators in a WHERE clause in a SQL statement: FREE ACCESS
  • Locked
    5.  LIKE Operator and Combining Wildcard Characters
    3m 47s
    In this video, you will use the LIKE operator and combine wildcard characters in a WHERE clause of a SQL statement. FREE ACCESS
  • Locked
    6.  NULL and Logical Operator Conditions
    2m 57s
    During this video, you will learn how to use the NULL and logical operator conditions in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    7.  AND, OR, and NOT Operators
    7m 21s
    In this video, learn how to use the AND, OR, and NOT operators in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    8.  Rules of Precedence
    4m 47s
    In this video, find out how to define the rules of precedence in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    9.  ORDER BY Clause
    5m 14s
    Learn how to use the ORDER BY clause to sort the data returned by a SQL statement. FREE ACCESS
  • Locked
    10.  SQL Row Limiting Clause
    5m 13s
    In this video, learn how to use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, 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

Likes 239 Likes 239  
Course SQL Developer
Likes 285 Likes 285  
Likes 46 Likes 46