Oracle Online Training

Oracle Certification Training
Oracle Online Course

Table of Contents

INTRODUCTION

  • Introduction to Oracle
  • DBMS Concepts
  • Definition of Database
  • Database Management System
  • Database models and Relations
  • Relational Database management System
  • E.F.Codd Rules
  • Database Design
  • Entity Relationship Diagram
  • Features of Oracle

SQL

  • Introduction to SQL
  • Features of SQL
  • SQL Sub Languages
  • Data Definition Language
  • Data types
  • Constraints
  • Data Manipulation Language
  • Data Retrieval Language
  • Operators
  • Data Control Language
  • Transaction Control Language
  • Functions
  • Aggregate functions
  • Character functions
  • Date functions
  • Arithmetic functions
  • General functions
  • Joins
  • Equi joins
  • Non equi joins
  • Self joins
  • Outer joins
  • Set operators
  • Sub queries
  • Correlated Subqueries
  • Large Database objects
  • Views
  • Sequences
  • Synonyms
  • Indexes
  • Clusters
  • Roles
  • SQL * Plus commands

PL/SQL

  • Introduction to PL/SQL
  • Architecture of PL/SQL
  • Advantages of PL/SQL
  • PL/SQL Block structure
  • Variables and constants
  • Attributes
  • Control statements
  • If statement
  • If else statement
  • Multiple elsif statement
  • Nested if statement
  • Loops
  • For statement
  • While statement
  • Cursors
  • Explicit cursors
  • Implicit cursors
  • Cursor for loop
  • Parameterized cursors
  • Ref cursors
  • Composite datatypes
  • PL/SQL Tables
  • PL/SQL Records
  • Exception handling
  • Sub Programs
  • Procedures
  • Functions
  • Using mode parameters
  • Packages
  • Database triggers
  • Instead of triggers
Quick Entry