|
|
Oracle9i SQL 1Z0 007
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $67 |
|
OR
| Buy the Technical
Pack, and receive this course
plus many more, for only $197
|
 |
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
| This online training course is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0 007 exam. |
|
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
|
|
|
Intermediate Queries |
- 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
|
|
|
Queries with Single Row Functions |
- 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
|
|
|
Combining Tables |
- 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
|
|
|
Grouping and Summarizing Data |
- Explain how group functions work
- Use aggregate functions
- Use the ROLLUP, CUBE, and GROUPING SETS clauses
|
- Group and sort rows using the GROUP BY clause
- Use the HAVING clause to restrict data
- Use DISTINCT and ALL clauses
|
|
|
Advanced Queries and Views |
- List the types of subqueries
- Use subqueries in Oracle SQL commands
- Add and drop views
|
- Change views
- Modify data using views
|
|
|
Working with Data |
- 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
|
|
|
Creating Tables and Constraints |
- 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
|
|
|
Database Objects and User Security |
- 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
|
|
|
SQL*Plus & iSQL*Plus Reporting and PL/SQL |
- 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
|
|
|
Practice Exam |
- 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
|
|
|