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.
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
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
