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 functionsuse character functions in a SQL statementuse case conversion functions in a SQL statementuse character manipulation functions in a SQL statementuse nesting functions in a SQL statementuse numeric ROUND and TRUNC functions in a SQL statementuse the MOD function in a SQL statement
-
work with dates and the RR date format in a SQL statementuse the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statementuse arithmetic operators with dates in a SQL statementuse date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statementuse the numeric ROUND and TRUNC functions with dateswrite 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
-
3m 29sIn this video, find out how to use case conversion functions in SQL statements. FREE ACCESS
-
9m 45sLearn how to use character manipulation functions in an SQL statement. FREE ACCESS
-
5m 5sIn this video, you will use nested functions in a SQL statement. FREE ACCESS
-
6m 47sIn this video, you will learn how to use the numeric ROUND and TRUNC functions in a SQL statement. FREE ACCESS
-
3m 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
-
4m 54sIn this video, find out how to work with dates and the RR date format in SQL. FREE ACCESS
-
5m 27sIn this video, learn how to use the SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
-
3m 7sIn this video, you will use arithmetic operators with dates in SQL statements. FREE ACCESS
-
7m 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
-
4m 11sFind out how to use the numeric ROUND and TRUNC functions with dates. FREE ACCESS
-
9m 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.