In some ways, Webucator's on line format is even better than being in a classroom! More Testimonials »

Oracle9i SQL 1Z0-007 eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses

Oracle9i SQL 1Z0-007 eLearning Course Series (24 hours)

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

Self-Paced Oracle 1Z0-007 eLearning Course Benefits

Only $42.95

12-month subscription!

Register Now

  • Learn Oracle 1Z0-007 online with these interactive online Oracle 1Z0-007 courses.
  • Affordable Pricing (Only $42.95 for the complete series)
  • A full year to complete the Oracle 1Z0-007 courses
  • Retake the Oracle 1Z0-007 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Oracle9i SQL 1Z0-007:1 Introduction to SQL (Time: 3 hours)

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

Course Objectives

  • 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

Course Topics

  • Basic database concepts
  • SQL Plus command line
  • SQL Plus window
  • SQL Plus worksheet
  • iSQL Plus
  • Using the SELECT statement
  • Writing SQL commands
  • Writing queries

2. Oracle9i SQL 1Z0-007:2 Intermediate Queries (Time: 2 hours)

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

Course Objectives

  • 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

Course Topics

  • Using the WHERE clause
  • Formatting query results
  • Using multiple filters
  • Dual and pseudocolumns
  • Using the ORDER BY clause
  • Sorting rules for null values

3. Oracle9i SQL 1Z0-007:3 Queries with Single-Row Functions (Time: 2 hours)

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

Course Objectives

  • 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

Course Topics

  • String functions
  • Number functions
  • Date functions
  • Miscellaneous functions
  • Conversion functions
  • Combining functions

4. Oracle9i SQL 1Z0-007:4 Combining Tables (Time: 2 hours)

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

Course Objectives

  • 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

Course Topics

  • Joining tables
  • Cross joins
  • Natural joins
  • The USING and the ON clause
  • Outer joins
  • Left outer joins
  • Right outer joins
  • Self joins
  • Other types of joins

5. Oracle9i SQL 1Z0-007:5 Grouping and Summarizing Data (Time: 1 hours)

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

Course Objectives

  • 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

Course Topics

  • The GROUP BY clause and group functions
  • Aggregate functions
  • Grouping rows and sorting with GROUP BY
  • Restricting Data
  • Extending the GROUP BY clause

6. Oracle9i SQL 1Z0-007:6 Advanced Queries and Views (Time: 2 hours)

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

Course Objectives

  • List the types of subqueries
  • Use subqueries in Oracle SQL commands
  • Add and drop views
  • Change views
  • Modify data using views

Course Topics

  • Subqueries
  • Types and uses of views
  • Simple, constraint and complex views
  • Changing and dropping views
  • Working with views
  • Inserting, updating and deleting in views

7. Oracle9i SQL 1Z0-007:7 Working with Data (Time: 2 hours)

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

Course Objectives

  • 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

Course Topics

  • Datatypes
  • Data Manipulation Language
  • Using transactions
  • Adding and changing data
  • Deleting and merging data

8. Oracle9i SQL 1Z0-007:8 Creating Tables and Constraints (Time: 2 hours)

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

Course Objectives

  • 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

Course Topics

  • Creating tables
  • Relational and temporary tables
  • Adding comments
  • Changing table structures
  • Renaming, truncating and dropping tables
  • Constraints
  • Primary key, unique and foreign key constraints
  • Table level and check constraints
  • Adding, modifying and dropping constraints

9. Oracle9i SQL 1Z0-007:9 Database Objects and User Security (Time: 4 hours)

This eLearning 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.

Course Objectives

  • 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

Course Topics

  • Working with sequences
  • Working with synonyms
  • Understanding indexes
  • Working with indexes
  • Understanding users
  • Working with users
  • Granting privileges
  • Revoking privileges
  • Creating, granting, and revoking roles
  • Enabling, disabling, and dropping roles

10. Oracle9i SQL 1Z0-007:10 SQL*Plus And iSQL*Plus Reporting and PL/SQL (Time: 3 hours)

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

Course Objectives

  • 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

Course Topics

  • SQL Plus reports
  • Environment settings
  • Using environment settings
  • Variables and scripts
  • Generating reports
  • Reporting features
  • Running reports
  • Top-N queries
  • PL/SQL
  • Retrieving data in PL/SQL
  • Dynamic SQL
  • Control structures
  • Iteration and repetition

11. Oracle9i SQL 1Z0-007:11 Practice Exam (Time: 1 hours)

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

Course Objectives

  • 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

Course Topics

  • SQL Plus reports
  • 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 iSQL Plus
  • Manipulating data
  • Creating and managing tables
  • Including constraints
  • Creating views
  • Creating other database objects
  • Controlling user access
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723