This series is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0-007 exam.
This Oracle 9i SQL 1Z0-007 online training series provides over 24 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Advanced Queries and Views
2 . Combining Tables
3 . Creating Tables and Constraints
4 . Database Objects and User Security
5 . Grouping and Summarizing Data
6 . Intermediate Queries
7 . Introduction to SQL
8 . Practice Exam
9 . Queries with Single-Row Functions
10 . SQL*Plus And iSQL*Plus Reporting and PL/SQL
11 . Working with Data
Lesson Detail:
Advanced Queries and Views
This course provides an in-depth look at using subqueries and views in Oracle9i SQL.
Combining Tables
This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format.
Creating Tables and Constraints
This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL.
Database Objects and User Security
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.
Grouping and Summarizing Data
This course examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.
Intermediate Queries
This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.
Introduction to SQL
This course provides an introduction to the Oracle9i relational database management system and basic database concepts.
Practice Exam
This course provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL.
Queries with Single-Row Functions
This course examines the types and uses of functions available for various data types in Oracle9i SQL.
SQL*Plus And iSQL*Plus Reporting and PL/SQL
This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.
Working with Data
This course examines the four main commands used in SQL to add, modify, remove, and merge rows of data in database tables.
Certification:
Oracle 9i SQL 1Z0-007
Audience:
This series is for anyone who is interested in learning more about Oracle9i SQL
Features:
What You Get:
You will receive Unlimited Access to all of the Oracle 9i SQL 1Z0-007 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Technical Package which includes all of the Oracle 9i SQL 1Z0-007 training courses listed above plus hundreds of hours of related online training courses