Group and Datetime Functions in Oracle Database 10g

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

Overview

To demonstrate how to use group and datetime functions in Oracle 10g

Target Audience

Database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Expected Duration

190 min.

Course Objectives

Group and Datetime Functions in Oracle Database 10g

  • retrieve data using group functions.
  • write SQL queries that group and restrict output rows.
  • write SQL queries that use group functions, the GROUP BY clause, and the HAVING clause
  • use the ROLLUP and CUBE operations and the GROUPING function in SQL queries.
  • use the GROUPING SETS function and specify composite columns and concatenated grouping sets.
  • write queries using ROLLUP and CUBE operators, GROUPING functions, and GROUPING SETS.
  • set time zone values and retrieve date and time values.
  • use date-related datatypes.
  • use date-related functions in Oracle 10g.
  • write SQL queries using datetime functions.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?