Profile

e-Catalog

Contact

Search

Cart

Subqueries, Reporting, and User-Access Control

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	3 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Junior database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Course Aim

This learning path provides an introduction for using SQL statements in an Oracle9i(TM) database. The learning path maps to Exam #1Z0-007: Introduction to Oracle9i: SQL. It comprises interactive graphical lessons, coding simulations, and mentored exercises.

Learning Objectives

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

Topics Covered

Subqueries Oracle database subqueries Using Oracle database subqueries Advanced subqueries in Oracle9i databases Hierarchical retrieval in an Oracle9i database Reporting Reporting using iSQL*Plus in an Oracle9i database Producing reports using iSQL*Plus in Oracle9i databases User-access control User access to an Oracle database Controlling user access to an Oracle database