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

Audience
This course is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007: Introduction to Oracle 9i:SQL.

Time
2 Hour(s)

Product Code:or0707
After completing this course, the user should 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

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

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the application
A glossary
A Skill Assessment

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: 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™ is a trademark of the Oracle Corporation.

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information