MP9003: Network and Database (General) - Using Single-Row Functions > Oracle Database 11g SQL Fundamentals I (1Z0-051)

This course explores single-row functions that can be called from SQL statements. These functions include character, numeric, date, conversion, and miscellaneous functions. The material covers the functions that are available, the rules for using them, and additional information you need to know for the exam. 

Topics:
Single-Row Fundamentals
Using Single-Row Character Functions
Using Single-Row Numeric Functions
Using Single-Row Date Functions
Using Single-Row Conversion Functions
Using Other Single-Row Functions

Objectives:
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Duration:
4 Hours