Media3 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.

Course Overview

ORACLE DATABASE 12c

INTRODUCTION TO DATABASE
BASIC SQL COMMANDS
SUB LANGUAGES IN SQL
a)DDL
b)DML
c)DRL/DQL
d)DCL
e)TCL
DATA TYPES IN ORACLE
GENERAL FUNCTIONS
a)NVL
b)NVL2
c)NULIF
d)COALESCE
e)CASE
f)DECODE
CHARACTER, NUMBER AND DATE FUNCTIONS
INTEGRITY CONSTRAINTS
a)NOTNULL
b)UNIQUE
c)PRIMARY KEY
d)FOREIGN KEY
e)CHECK
f)DEFAULT
JOINS
a)EQUI
b)NON EQUI
c)SELF
d)OUTER
e)CROSS
f)NATURAL
g)INNER

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