Restricting Output
Oracle 12c
10 Videos | 45m 49s - Earns a Badge
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
-
1.Limiting Selected Rows and Using the WHERE Clause3m 34s
-
2.Character Strings and Dates4m 37s
-
3.Comparison Operators3m 5s
-
4.BETWEEN and IN Operators4m 16s
-
5.LIKE Operator and Combining Wildcard Characters3m 47s
-
6.NULL and Logical Operator Conditions2m 57s
-
7.AND, OR, and NOT Operators7m 21s
-
8.Rules of Precedence4m 47s
-
9.ORDER BY Clause5m 14s
-
10.SQL Row Limiting Clause5m 13s
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.
