TestPrep 1Z0-007 Introduction to Oracle9i: SQL


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

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

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

Expected Duration (hours)
0.0

Lesson 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