SQL Functions in Oracle9i

This course is included in our On-demand training solution.

Overview

To describe how to use SQL functions for data retrieval

Target Audience

Junior database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Expected Duration

300 min.

Course Objectives

SQL Functions in Oracle9i

  • describe and use character, number, and date functions in SELECT statements in an Oracle9i database.
  • describe and use datatype conversion functions in SELECT statements in an Oracle9i database.
  • describe how to use nested and conditional functions in SELECT statements in an Oracle9i database.
  • use single-row functions in SELECT statements in an Oracle9i database.
  • use conversion functions to convert date values in SELECT statements.
  • explain how to retrieve data from multiple Oracle9i database tables using join methods.
  • describe how to retrieve data from multiple Oracle9i database tables using SQL: 1999 join syntax.
  • use SQL: 1999 joins to retrieve data from multiple tables in an Oracle9i database.
  • describe how to use SET operators to combine multiple queries into a single query using SET operators.
  • identify and to describe the use of group functions in an Oracle database.
  • describe and use the GROUP BY clause for an Oracle database.
  • use group functions and the GROUP BY clause in SELECT statements in an Oracle9i database.
  • identify and describe the use of GROUP BY enhancements in an Oracle9i database.
  • use GROUP BY enhancements in an Oracle9i database.
  • describe and use the new datetime functions in an Oracle9i database.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?