Oracle Database 12c R2 SQL: Restricting & Sorting Data

Oracle SQL 12c    |    Beginner
  • 12 videos | 59m 40s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
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

  • 3m 38s
    Upon completion of 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
  • 3m 44s
    In this video, you will use character strings and dates in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    3.  Comparison Operators
    4m 37s
    In this video, you will learn how to use comparison operators in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    4.  BETWEEN and IN Operators
    3m 39s
    In this video, learn how to use the BETWEEN and IN operators in a WHERE clause of a SQL statement. FREE ACCESS
  • Locked
    5.  LIKE Operator and Combining Wildcard Characters
    3m 33s
    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
    3m 43s
    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
    6m 11s
    In this video, you will learn how to use the AND, OR, and NOT operators in a WHERE clause of a SQL statement. FREE ACCESS
  • Locked
    8.  Rules of Precedence
    5m 33s
    In this video, you will learn about the rules of precedence in a WHERE clause in a SQL statement. FREE ACCESS
  • Locked
    9.  ORDER BY Clause
    4m 19s
    During this video, you will 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 7s
    Find out how to use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement. FREE ACCESS
  • Locked
    11.  Substitution Variables
    9m 39s
    Find out how to use substitution variables. FREE ACCESS
  • Locked
    12.  Exercise: Manipulating Data
    5m 58s
    Learn how to manipulate data using SQL. 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.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)
Course Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)
Course Saving Time by Setting Goals
Rating 4.5 of 6362 users Rating 4.5 of 6362 users (6362)
Course Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Rating 4.7 of 40 users Rating 4.7 of 40 users (40)