Oracle9i SQL 1Z0-007

Oracle9i SQL 1Z0-007
Total Time: 24 hour(s)

Oracle9i SQL 1Z0-007: Introduction to SQL

Time: 3 hours

or0701

This course provides an introduction to the Oracle9i relational database management system and basic database concepts.

Understand basic database concepts
List new SQL features in Oracle9i

Use the four available SQL Plus tools
Enter and execute basic queries using the SELECT command

Oracle9i SQL 1Z0-007: Intermediate Queries

Time: 2 hours

or0702

This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.

Use the WHERE clause to filter out rows from query results
Format query results
Use multiple filters in a query

Query the DUAL table
Sort query results using the ORDER BY clause
Handle null values in query results

Oracle9i SQL 1Z0-007: Queries with Single-Row Functions

Time: 2 hours

or0703

This course examines the types and uses of functions available for various data types in Oracle9i SQL.

Describe the most commonly-used functions available in SQL
Use character, number, and date functions in SELECT statements

Use conversion functions
Find online documentation for more information about functions as needed

Oracle9i SQL 1Z0-007: Combining Tables

Time: 2 hours

or0704

This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format.

Write SELECT statements to access data from more than one table using equality and nonequality joins
View data that generally does not meet a join condition by using outer joins
Join a table to itself using a self join

Create various types of join queries
Identify the differences between Oracle proprietary format and ANSI format for joining tables

Oracle9i SQL 1Z0-007: Grouping and Summarizing Data

Time: 1 hours

or0705

This course examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.

Explain how group functions work
Use aggregate functions
Use DISTINCT and ALL clauses

Group and sort rows using the GROUP BY clause
Use the HAVING clause to restrict data
Use the ROLLUP, CUBE, and GROUPING SETS clauses

Oracle9i SQL 1Z0-007: Advanced Queries and Views

Time: 2 hours

or0706

This course provides an in-depth look at using subqueries and views in Oracle9i SQL.

List the types of subqueries
Use subqueries in Oracle SQL commands
Add and drop views

Change views
Modify data using views

Oracle9i SQL 1Z0-007: Working with Data

Time: 2 hours

or0707

This course examines the four main commands used in SQL to add, modify, remove, and merge rows of data in database tables.

Distinguish between Oracle9i and user-defined datatypes
Use the four Oracle9i DML commands INSERT, UPDATE, DELETE, and MERGE

Understand transactions and the commands used to manipulate their behavior

Oracle9i SQL 1Z0-007: Creating Tables and Constraints

Time: 2 hours

or0708

This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL.

Create, modify, rebuild, and remove tables
Use the TRUNCATE command
Create, modify and drop constraints

Use primary key constraints
Use foreign key contraints
Add comments to SQL scripts and schema objects

Oracle9i SQL 1Z0-007: Database Objects and User Security

Time: 4 hours

or0709

This course examines how to create database objects including sequences, synonyms, and indexes in Oracle9i SQL. It also covers sharing table data with other users through privileges and roles.

Create, modify, and delete sequences
Create, modify, and delete synonyms
Create, modify, and delete indexes

Create, modify, and delete users
Grant and revoke system and object privileges
Create, grant, revoke, enable, disable, and delete roles

Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL

Time: 3 hours

or0710

This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.

Create a well formatted report with SQL Plus
Know when and how to use variables
Use iSQL Plus

Use Top-N Analysis
Identify the basic concepts of PL/SQL

Oracle9i SQL 1Z0-007: Practice Exam

Time: 1 hours

or0711

This course provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL.

Answer practice questions in the format of the 1Z0-007 Introduction to Oracle 9i SQL exam

Assess readiness to take the exam and identify topic areas requiring further practice