Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Oracle SQL 12c
| Beginner
- 13 videos | 1h 10m 40s
- Includes Assessment
- Earns a Badge
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.
WHAT YOU WILL LEARN
-
Identify the types of sql functions in a sql statement and describe single-row functions
Use character functions in a sql statement
Use case conversion functions in a sql statement
Use character manipulation functions in a sql statement
Use nesting functions in a sql statement
Use numeric round and trunc functions in a sql statement
Use the mod function in a sql statement -
Work with dates and the rr date format in a sql statement
Use the sysdate, current_date and current_timestamp functions in a sql statement
Use arithmetic operators with dates in a sql statement
Use date manipulation functions such as months_between, add_months, next_day, and last_day in a sql statement
Use the numeric round and trunc functions with dates
Write a sql statements that use character, number, and date functions
IN THIS COURSE
-
5m 19sLearn how to identify the types of SQL functions in a SQL statement and describe how they work. FREE ACCESS
-
2m 12sLearn how to use character functions in SQL statements. FREE ACCESS
-
3. Case Conversion Functions3m 29sIn this video, find out how to use case conversion functions in SQL statements. FREE ACCESS
-
4. Character Manipulation Functions9m 45sLearn how to use character manipulation functions in an SQL statement. FREE ACCESS
-
5. Nesting Functions5m 5sIn this video, you will use nested functions in a SQL statement. FREE ACCESS
-
6. Numeric ROUND and TRUNC Functions6m 47sIn this video, you will learn how to use the numeric ROUND and TRUNC functions in a SQL statement. FREE ACCESS
-
7. MOD Function3m 29sTo find out how to use the MOD function in a SQL statement, consult a SQL reference guide or search for an online tutorial. FREE ACCESS
-
8. Working with Dates and the RR Date Format4m 54sIn this video, find out how to work with dates and the RR date format in SQL. FREE ACCESS
-
9. SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP5m 27sIn this video, learn how to use the SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
-
10. Arithmetic Operators in Dates3m 7sIn this video, you will use arithmetic operators with dates in SQL statements. FREE ACCESS
-
11. Date Manipulation Functions7m 16sIn this video, you will use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in an SQL statement. FREE ACCESS
-
12. Using Numeric ROUND and TRUNC Functions with Dates4m 11sFind out how to use the numeric ROUND and TRUNC functions with dates. FREE ACCESS
-
13. Exercise: Use Character, Number, and Date Functions9m 40sIn this video, you will learn how to write SQL statements that use character, number, and date functions. 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.
