![]() |
Profile |
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 |