Subqueries, Reporting, and User-Access Control in Oracle9i

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

Overview

To describe the use of subqueries, reporting, and user-access control in an Oracle9i database

Target Audience

Junior database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Expected Duration

160 min.

Course Objectives

Subqueries, Reporting, and User-Access Control in Oracle9i

  • describe and define subqueries and to write single-row and multiple-row subqueries for an Oracle database.
  • use single-row subqueries in an Oracle database.
  • use the advanced functionality of subqueries in an Oracle9i database.
  • explain the concept of a hierarchical query and to explain how to create a tree-structure report in an Oracle9i database.
  • explain how to produce reports using iSQL*Plus in an Oracle9i database.
  • produce reports using iSQL*Plus in an Oracle9i database.
  • describe how to control user access to an Oracle database.
  • use roles and privileges to control user access to an Oracle database.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?