ORACLE 12c


ORACLE 12c

(Including Project Practical’s & Internship)

Course Features:-

  • Complete online Training on Projector.
  • Complete HR & Technical Interview Preparation
  • 100% Syllabus Coverage for OCA exam.
  • Live Project using Oracle & Internship Certificate.
  • More Than 1000+ Students Placed With TCS, INFY, CAPgemini, Accenture & Other Companies.
  • Oracle Database 12c Syllabus

    Topic SQL+PLSQL

    Sr.No Topic SQL
    1 Introduction to SQL
    2 Restricting and sorting data
    3 Single row functions
    4 Multiple row functions
    5 SQL Joins
    6 Sub-Queries
    7 Manipulating data
    8 Creating and managing tables
    9 Set operators
    10 Psuedocolumns
    11 SQL Constraints
    12 Sequences
    13 Views
    14 Indexes
    15 Synonyms
    Sr.No Topic SQL
    1 Introduction to Pl/Sql.
    2 Declaring PL/SQL Variables
    3 Writing Executable Statements.
    4 Interacting with the Oracle DATABASE
    5 Writing Control Structures
    6 Working with Composite DATA Types
    7 Using Explicit Cursors
    8 Handling Exceptions
    9 Creating Procedure, Functions & Introduction to Pl/Sql.
    10 Working With Packages
    11 Using Oracle – Supplied Packages
    12 Using Dynamic SQL
    13 Design Condiderations for PL/SQL
    14 Creating Triggers
    15 Creating Compound, DDL Triggers
    16 Using The PLSQL Compiler
    17 Managing PLSQL Code
    18 Managing Dependencies