Oracle Database 12c R2 SQL: Restricting & Sorting Data
Oracle SQL 12c
| Beginner
- 12 videos | 59m 40s
- Includes Assessment
- Earns a Badge
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 38sUpon 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 44sIn this video, you will use character strings and dates in a WHERE clause in a SQL statement. FREE ACCESS
-
3. Comparison Operators4m 37sIn this video, you will learn how to use comparison operators in a WHERE clause in a SQL statement. FREE ACCESS
-
4. BETWEEN and IN Operators3m 39sIn this video, learn how to use the BETWEEN and IN operators in a WHERE clause of a SQL statement. FREE ACCESS
-
5. LIKE Operator and Combining Wildcard Characters3m 33sIn 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 Conditions3m 43sDuring 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 Operators6m 11sIn this video, you will learn how to use the AND, OR, and NOT operators in a WHERE clause of a SQL statement. FREE ACCESS
-
8. Rules of Precedence5m 33sIn this video, you will learn about the rules of precedence in a WHERE clause in a SQL statement. FREE ACCESS
-
9. ORDER BY Clause4m 19sDuring this video, you will learn how to use the ORDER BY clause to sort the data returned by a SQL statement. FREE ACCESS
-
10. SQL Row Limiting Clause5m 7sFind out how to use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement. FREE ACCESS
-
11. Substitution Variables9m 39sFind out how to use substitution variables. FREE ACCESS
-
12. Exercise: Manipulating Data5m 58sLearn 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.
