|
|
v
Introduction to RDBMS &
ORDBMS Concepts
v
Writing a basic SQL Statement
v
Restricting and sorting Data
v
Single Row Functions
v
Displaying data from multiple
tables
v
Writing Sub queries
v
Producing readable output
with SQL * Plus
v
Data Manipulation
v
Creating and managing tables
v
Including Constraints
v
Creating Views
v
Other Database Objects
v
Using Set operators
v
Single row functions
v
Enhancement to the Group by
Clause
v
Advanced Sub queries
v
Hierarchical Retrieval
v
Extensions to DDL and DML
statements
v
Writing scripts to generate
Scripts
|
|
v
Introduction to PL/SQL
v
Declaring Variables
v
Writing Executable
statements
v
Working with Composite Data
types
v
Writing Explicit Cursors
v
Advanced Explicit Cursors
Concepts
v
Handling Exceptions
v
Creating Procedures
v
Creating Functions
v
Managing Subprograms
v
Creating Packages
v
More package Concepts
v
Using Oracle - Supplied
Packages
v
Creating Database Triggers
v
Managing Dependencies
v
Manipulating Large Objects
|
