oracle 9i sql 1z0 007 online training course tutorials

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy this entire online training course with one easy payment of $67

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0 007 exam.

Introduction to SQL

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

Intermediate Queries

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

Queries with Single Row Functions

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

Combining Tables

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

Grouping and Summarizing Data

Explain how group functions work
Use aggregate functions
Use the ROLLUP, CUBE, and GROUPING SETS clauses

Group and sort rows using the GROUP BY clause
Use the HAVING clause to restrict data
Use DISTINCT and ALL clauses

Advanced Queries and Views

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

Change views
Modify data using views

Working with Data

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

Creating Tables and Constraints

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

Database Objects and User Security

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

SQL*Plus & iSQL*Plus Reporting and PL/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

Practice Exam

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

Oracle9i SQL 1Z0 007 Join over 1 million people who learn online, with these complete interactive computer training courses.

Oracle9i SQL 1Z0 007
Join over 1 million people who learn online, with these complete interactive computer training courses.