12 Month Subscription - $70 Live Mentor +$30

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

Certification:
Oracle9i 1Z0-007

Audience:
This series is for anyone who is interested in learning more about Oracle9i SQL

Features:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
●  A glossary provides a reference for definitions of unfamiliar terms.
●  A skill assessment generates a customized learning path based on the results of a pre-test.

Topics included in this course:
Oracle9i SQL 1Z0-007 : Introduction to SQL
Oracle9i SQL 1Z0-007 : Intermediate Queries
Oracle9i SQL 1Z0-007 : Queries with Single-Row Functions
Oracle9i SQL 1Z0-007 : Combining Tables
Oracle9i SQL 1Z0-007 : Grouping and Summarizing Data
Oracle9i SQL 1Z0-007 : Advanced Queries and Views
Oracle9i SQL 1Z0-007 : Working with Data
Oracle9i SQL 1Z0-007 : Creating Tables and Constraints
Oracle9i SQL 1Z0-007 : Database Objects and User Security
Oracle9i SQL 1Z0-007 : SQL*Plus And iSQL*Plus Reporting and PL/SQL
Oracle9i SQL 1Z0-007 : Practice Exam

Oracle9i SQL 1Z0-007 : Introduction to SQL
Summary:
This course provides an introduction to the Oracle9i relational database management system and basic database concepts.

Objectives:
After completing this course, 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

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
top

Oracle9i SQL 1Z0-007 : Intermediate Queries
Summary:
This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.

Objectives:
After completing this course, 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

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

Oracle9i SQL 1Z0-007 : Queries with Single-Row Functions
Summary:
This course examines the types and uses of functions available for various data types in Oracle9i SQL.

Objectives:
After completing this course, 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

Topics:
String functions
Number functions
Date functions
Miscellaneous functions
Conversion functions
Combining functions
top

Oracle9i SQL 1Z0-007 : Combining Tables
Summary:
This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format.

Objectives:
After completing this course, 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

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
top

Oracle9i SQL 1Z0-007 : Grouping and Summarizing Data
Summary:
This course examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.

Objectives:
After completing this course, 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

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

Oracle9i SQL 1Z0-007 : Advanced Queries and Views
Summary:
This course provides an in-depth look at using subqueries and views in Oracle9i SQL.

Objectives:
After completing this course, 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

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
top

Oracle9i SQL 1Z0-007 : Working with Data
Summary:
This course examines the four main commands used in SQL to add, modify, remove, and merge rows of data in database tables.

Objectives:
After completing this course, 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

Topics:
Datatypes
Data Manipulation Language
Using transactions
Adding and changing data
Deleting and merging data
top

Oracle9i SQL 1Z0-007 : Creating Tables and Constraints
Summary:
This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL.

Objectives:
After completing this course, 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

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
top

Oracle9i SQL 1Z0-007 : Database Objects and User Security
Summary:
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.

Objectives:
After completing this course, 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

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
top

Oracle9i SQL 1Z0-007 : SQL*Plus And iSQL*Plus Reporting and PL/SQL
Summary:
This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.

Objectives:
After completing this course, 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

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 repitition
top

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

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

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
top

12 Month Subscription - $70 Live Mentor +$30