| IT Courses - Oracle Training Modules |
| |
 Introduction
Retrieve data using the SQL Select statement
Restricted and sorted data
|Usage of single – Row Functions to customize output
Conversion functions and conditional expressions
Aggregated data using the group functions
Display data from multiple tables
Usage of sub quires to solve Quires
SET Operators
Data manipulation DDL Statements to create and manage Tables
Other Schema objects
Introduction to PL/SQL
PL/SQL Identifiers
Write Executable statements
Interaction with Oracle server
Control Structures
Usage of composite data types
Explicit cursors
Exception Handling
Stored procedure and Functions
Packages and triggers |
