 |
|
|
Oracle SQL Introduction
The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately.
 Course Summary:
- SQL Data Definition Language
- Using The SQL*PLUS Tool
- SQL Data Manipulation Language
- Introduction to SQL Queries
- Building a WHERE Clause
- Ordering the RESULT Table
- Pseudo Columns and Functions
- Joining Tables
- Using Set Operators Upon Tables
- About Summary Functions
- Using Subqueries
- Creating & Selecting Groups
- Creating & Using Views
- Indexes & Synonyms
- Understanding The Data Dictionary
Follow-Up Courses:
Option of other related or follow-on courses:
- Introduction to Oracle9i Advanced SQL
|
 |
|
|
