TestPrep 1Z0-007 Introduction to Oracle9i: SQL

Overview/Description
Generally taken near the end of a program of certification-orientated study, the 1Z0-007 Introduction to Oracle9i: SQL TestPrep enables the learner to test their knowledge in a simulated certification testing environment. Learners can take TestPrep in two different modes: Study and Certification. Study mode is designed to maximize learning by providing feedback, while Certification mode is designed to mimic a certification exam.

Target Audience
Individuals seeking practice in a simulated testing environment, covering the skills and competencies being measured by the actual certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting the TestPrep. This will maximize the effectiveness of the simulated preparation exam.

Expected Duration
N/A

Objectives:

TestPrep 1Z0-007 Introduction to Oracle9i: SQL

  • Writing Basic SQL Select Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data using Group Functions
  • Subqueries
  • Producing Readable Output with SQL*Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Creating Other Database Objects
  • Controlling User Access


    • Course Number: TP1Z0007_eng