Oracle Database 12c R2 SQL: Restricting and Sorting Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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.



Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 12c R2 SQL: Restricting and Sorting Data

  • 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

    • Course Number:
    it_dfosfd_11_enus

    Expertise Level
    Beginner