**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**

Oracle 9i SQL 1Z0-007 Online Course Tutorial Details

Total Lessons: 11
Total Time: 24 hour(s)
Subscription Term: 12 month(s)

Summary:

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

Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment

Lesson 1 Introduction to SQL - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 2 Intermediate Queries - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 3 Queries with Single-Row Functions - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 4 Combining Tables - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 5 Grouping and Summarizing Data - 1 hour

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 6 Advanced Queries and Views - 2 hours

Objectives: After completing this lesson, students will be able to:
* List the types of subqueries
* Use subqueries in Oracle SQL commands
* Add and drop views
* Change views
* Modify data using views

Lesson 7 Working with Data - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 8 Creating Tables and Constraints - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 9 Database Objects and User Security - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 10 SQL*Plus And iSQL*Plus Reporting and PL/SQL - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 11 Practice Exam - 3 hours

Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate your current skill level for the Oracle9i SQL 1Z0-007 Exam