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.YOU MIGHT ALSO LIKE
Rating 5.0 of 1 users
(1)
