*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
* |
Introduction to oracle products.
SQL*plus features and commands.
Data manipulation commands, data control commands.
Altering tables, data definition commands, joins, types of functions.
Process Transaction commands, SQL*plus set theory.
Sub-queries and Co-related queries.
Security in Oracle
Locking
Oracle Objects - Views, clusters, indexes, synonyms, snapshots.
Formatting output of queries, Report creation.
Implementing Object Oriented features in Oracle.
Introduction to PL/SQL.
Packages
Creating Cursors, exceptions, procedures, functions and triggers.
Understanding the Oracle Architecture.
Features of Latest Oracle Version.
Data Dictionary
DBA - An Overview |