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.
