Exam # 1Z0-007: Introduction to Oracle9i: SQL

Introduction to Oracle9i: SQL (Exam #1Z0-007) is a core requirement for the Oracle9i OCP (Oracle Certified Professional) certifications. It is designed for all database personnel seeking Oracle certification. SQL (Structured Query Language) is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. In addition, we cover the following topics:

Chapter 1: Introduction to Oracle

What is an Oracle?

Oracle Versions

Oracle9i Architecture

What is SQL?

SQL Statements

Built-in Data Types

SQL Standards

Chapter 2: Writing Basic SQL SELECT Statements

Starting an Oracle Session

Windows and Browser Version of SQL*Plus

Logging into Oracle Through SQL*Plus

Using the SELECT Command

Constants and Data Conversion

WHERE Clause

Arithmetic Operators

Logical Connectives

Sales Order Entry System

Data Model

Chapter 3: Using the Data Dictionary

What is the Oracle Data Dictionary?

Base Tables and Static Views in the Data

Dynamic Views in the Data Dictionary

ALL_Views

DBA_Views

USER Views

Additional Views

Chapter 4: Data Manipulation Language

Modifying Data

How to Insert Data

Multi-row Insert

Update Command

Deleting Data

Transaction Processing

The COMMIT Command

The ROLLBACK Command

Using Oracle's SQL Loader

Chapter 5: Using SQL Functions

Types of SQL Functions

NUMERIC Functions

Char Functions

Data Conversion Functions

DATE Functions

Miscellaneous Functions

DECODE Function

Group Functions

Additional Functions

New ROLLUP Operators

The GROUPING Function

Analytical Functions

Full List of SQL Functions

Chapter 6: Advanced SQL Concepts

Working with Joins

Types of Joins

Basic Join

Equi-Joins

Outer Joins

Left and Right Outer Joins

What is a Subquery?

Subquery Rules

Using IN and EXISTS Operators in

Using the ANY and ALL Operators in

DML Commands Using Single-Row

Using Set Operators

NULLS and Logic

Chapter 7: Database Objects

The Data Definition Language

Creating Tables

Defining DEFAULT Values

Using Explicit Defaults

The ALTER TABLE Command

Using Indexes

Query Optimization

Creating Sequences

Creating Synonyms

Dropping Database Objects

Constraints

Different Types of Constraints

Enabling and Disabling Constraints

Index-Organized Table

Chapter 8: ANSI SQL Features

ANSI Join Syntax

The USING Clause

CASE Expression

Scalar Subqueries

The MERGE Statement

New Analytical Functions

Grouping with Composite Columns

Using Concatenated Groupings

Chapter 9: Introduction to Security

Viewing System Privileges

Granting Object Privileges

Privileges and the User Group PUBLIC

Revoking System Privileges and Roles

Database Authentication

Predefined or Setting up a Roles

Enabling and Disabling Roles

Guidelines and Standards for Roles

Chapter 10: iSQL*Plus

Logging in Using iSQL*Plus

Client Configuration

Proxy Server Configuration

Middle Tier Configuration

Setting up the iSQL*Plus Server

Starting and Stopping the HTTP Server

iSQL*Plus Security

Web Browser Globalization Setup

SQL*Plus Command Summary

Chapter 11: Introduction to PL/SQL

Executing PL/SQL from SQL*Plus

Customizing SQL*Plus for PL/SQL Scripts

Interactive PL/SQL Programs

Oracle Datatypes are supported in PL/SQL

Numeric Datatypes

Implicit and Explicit Conversion

Variable Scope and Visibility Rules

SQL and PL/SQL Reserved Words

Chapter 12: Procedures and Functions

Working with Subprograms

Named Subprograms

Stored Procedure Syntax

NOCOPY Compiler Directive

Parameter Default Values

Positional and Named Notation

Executing a Stored Procedure

Compiling and Debugging Stored Procedures

Stored Function Syntax

Executing a Function from SQL*Plus

The RETURN Statement

Would you like to learn Introduction to Oracle9i: SQL? We provide home tutoring service.

Please contact us for any additional information.

---