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