ORACLE

Eastpolesoft stands as a proactive, growth-oriented organization aiming at professional excellence with a pool of talented and dedicated work force. Our key strengths are motivated associates; value based work ethics, experienced personnel (live tech leads) and state of the art infrastructure.

ORACLE DATABASE 12c

INTRODUCTION TO DATABASE

BASIC SQL COMMANDS

SUB LANGUAGES IN SQL

DDL
DML
DRL/DQL
DCL
TCL

DATA TYPES IN ORACLE

GENERAL FUNCTIONS

NVL
NVL2
NULIF
COALESCE
CASE
DECODE

CHARACTER, NUMBER AND DATE FUNCTIONS

INTEGRITY CONSTRAINTS

NOTNULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

JOINS

EQUI
NON EQUI
SELF
OUTER
CROSS
NATURAL
INNER

SUB QUERIES
VIEWS
WORKING WITH INDEXES
SEQUENCE
INTRODCUTION TO PL/SQL
WRITING CONTROL STRUCTURE
CURSORS
EXCEPTION HANDLING
PROCEDURES
FUNCTIONS
PACKAGES
TRIGGERS
SQL LOADER