|
 |
 |
|
Oracle Basics for Power Users
[DBU-O2]
Duration: 5 days
- Audience:
- End-users, programmers and administrators new to the Oracle
and database environment.
-
- Description:
- This course combines lectures and hands-on labs to teach
the participant how to use the basic features of an Oracle
database. It includes information on database concepts, plus
enables the student to perform routine data retrieval using
SQL and management tasks involving tables, views, indexes
and joins. It condenses the Introduction to Oracle course
into three days, then includes two additional days on PL/SQL.
-
- Prerequisites:
- None
-
- Topics:
- ü
Database Concepts
- ü
SQL Command Structure
- ü
SQL *Plus
- ü
Maintaining Data in Tables
- ü
Constructing Queries
- ü
Indexes
- ü
Views
- ü
Sub-Queries
- ü
Table Joins
- ü
Summary Reports
- ü
Backing Up Data
- ü
Data Security
- ü
Data Dictionary
- ü
Simple Scripts
- ü
Oracle Navigator
- ü
Decisions
- ü
Loops
- ü
Exceptions
- ü
Triggers
- ü
Cursors
- ü
Functions
- ü
Procedures and Packages
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.
|
|
