Restricting Output
Oracle 12c
| Beginner
- 10 videos | 44m 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 34sAfter 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
-
2. Character Strings and Dates4m 37sIn this video, find out how to use character strings and dates in a WHERE clause in a SQL statement. FREE ACCESS
-
3. Comparison Operators3m 5sIn this video, learn how to use comparison operators in a WHERE clause in a SQL statement. FREE ACCESS
-
4. BETWEEN and IN Operators4m 16sTo use the BETWEEN and IN operators in a WHERE clause in a SQL statement: FREE ACCESS
-
5. LIKE Operator and Combining Wildcard Characters3m 47sIn this video, you will use the LIKE operator and combine wildcard characters in a WHERE clause of a SQL statement. FREE ACCESS
-
6. NULL and Logical Operator Conditions2m 57sDuring this video, you will learn how to use the NULL and logical operator conditions in a WHERE clause in a SQL statement. FREE ACCESS
-
7. AND, OR, and NOT Operators7m 21sIn this video, learn how to use the AND, OR, and NOT operators in a WHERE clause in a SQL statement. FREE ACCESS
-
8. Rules of Precedence4m 47sIn this video, find out how to define the rules of precedence in a WHERE clause in a SQL statement. FREE ACCESS
-
9. ORDER BY Clause5m 14sLearn how to use the ORDER BY clause to sort the data returned by a SQL statement. FREE ACCESS
-
10. SQL Row Limiting Clause5m 13sIn 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.
