|
 |
 |
|
Introduction to Oracle9i:
SQL, PL/SQL, and SQL*Plus [DBS-02]
Duration: 5 days
- Audience:
- End users and application developers who need to retrieve
and manipulate data in an Oracle® database
-
- Description:
- This course introduces students to the concepts of relational
databases, the SQL*Plus interface tool, and the powerful SQL
and PL/SQL programming languages. Students will learn and
practice how to create and maintain database objects. The
students will also learn to store, retrieve, and manipulate
data. Finally, the students will learn how to create PL/SQL
blocks of application code that can be used in Oracle®
forms, reports, and other Oracle applications.
-
- Prerequisites:
- Before taking this course, students should have taken "Introduction
to Oracle" or have equivalent knowledge:
- Topics:
-
- ü
. Use SQL, PL/SQL, and SQL*Plus.
- ü
Use SQL*Plus commands.
- ü
Filter and sort data.
- ü
Use built-in SQL functions.
- ü
Work with multiple tables.
- ü
Create and modify tables and constraints.
- ü
Create and use other database objects.
- ü
Build a PL/SQL block.
- ü
Use PL/SQL control structures.
- ü
Process cursors in PL/SQL.
- ü
Handle runtime exceptions.
- ü
Develop procedures and functions.
- ü
Develop Oracle packages.
- ü
Create Oracle triggers.
- ü
" Work with collections of data.
-
-
-
If you are interested in something beyond what is listed here, please call us
today! We are always adding new courses!
For more training information, please fill out the Information
Request Form
Call EduCorp at 800-668-0943, or
email us at educorp@educorptraining.com.
|
|
