Oracle 9i Training Tutorials

Course List
Specials
Site Map
Free Training Tutorials
Oracle Certification




Computer Training Courses Catalog
(PDF Format)

You will receive Unlimited Access to all of the Oracle 9i SQL 1Z0-007 tutorials listed below. Your online training courses will be available from anywhere you have internet access.

Summary:

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

This e-learning computer training series includes all of the online training tutorials listed below and is provided in an interactive e-learning 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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit .

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 40 countries.

Certification: Oracle Certification

Includes:

Oracle 9i SQL 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

• 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

• 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

• 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

• 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

• 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

• 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

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

• 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

• 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

• 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

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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit CEU credit.


Questions about Oracle 9i SQL 1Z0-007? We now offer 24x7 online support with access to real live experts! Get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your Oracle 9i SQL 1Z0-007 questions quickly answered anytime from anywhere.

Oracle 9i SQL 1Z0-007... ... $59.95
Oracle 9i SQL 1Z0-007 + 1 Year Instant Mentoring... ... $99.95

You might also be interested in our Technical Package which includes all of the Oracle 9i SQL 1Z0-007 training courses listed above plus over 1056 hours of additional courses.

About Us News Contact Us Features Certification

Reviews:

"this is a must have resource"
TheTechMag.com

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

Excellent program, this is a real winner. Thanks. A+
Arlington, TX

Read more customer reviews about our e-learning training tutorials.