Preloader

Overview


Oracle Certification Training in Delhi

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.


  • Module: Introduction to DBMS

  •  Approach to Data Management
  •  Introduction to Prerequisites
  •  File and File System
  •  Disadvantages of file
  •  Review of Database Management Terminology
  •  Database Models :
    •  Hierarchial model
    •  Network model
    •  Relational model
  • Module: Sub Language Commands

  •  Data Definition Language (DDL)
  •  Data Retrieval Language (DRL)
  •  Data Manipulation Language (DML)
  •  Transaction Control Language (TCL)
  •  Database Security and Privileges (DCL)
  • Module: Built in Functions

  •  Arithmetic Functions
  •  Character Functions
  •  Date Functions
  •  Conversion Functions
  •  Aggregate Functions
  •  OLAP Functions
  •  General Functions
  • Module: Working with Integrity Constraints

  •  Importance of Data Integrity
  •  Support of Integrity Constraints for Relating Table in RDBMS :
    •  NOT NULL Constraint
    •  UNIQUE Constraint
    •  PRIMARY KEY Constraint
    •  FOREIGN KEY Constraint
    •  CHECK Constraint
  •  Working With Different Types of Integrity Constraints
  • Module: Working With Sub Queries

  •  Understanding the Practical Approach to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select
  •  Sub Query Principle and Usage
  •  Type of Sub Queries
  •  Single Row
  •  Multiple Row
  •  Multiple Column
  •  Applying Group Functions in Sub Queries
  •  The impact of Having Clause in Sub Queries
  •  IN, ANY/SOME, ALL Operators in Sub Queries
  •  PAIR WISE and NON PAIR WISE Comparison in Sub Queries
  •  Correlated Sub Queries
  •  Handling Data Retrieval with EXISTS and NOT EXISTS Operators
  • Module: VIEWS in Oracle

  •  Understanding the Standards of VIEWS in Oracle
  •  Types of VIEWS
  •  Relational Views
  •  Object Views
  •  Prerequisites to work with views
  •  Practical approach of SIMPLE VIEWS and COMPLEX VIEWS
  •  Column definitions in VIEWS
  •  Using VIEWS for DML Operations
  •  In-Line View
  •  Forced Views
  •  Putting CHECK Constraint upon VIEWS
  •  Creation of READ ONLY VIEWS
  •  Understanding the IN LINE VIEWS
  •  About Materialized Views
  •  View Triggers
  • Module: Data Partitions & Parallel Process

  •  Types of Partitions
  •  Range Partitions
  •  Hash Partitions
  •  List Partition
  •  Composite Partition
  •  Parallel Query Process
  • Module: SQL * Loader

  •  SQL * Loader Architecture
  •  Data File
  •  Control File
  •  Bad File
  •  Discard File
  •  Log File
  •  .txt to Base Table
  • &emsp.csv to Base Table
  •  From More Than One File to Single Table
  • Module: Procedures in PL-SQL

  •  Stored Procedures
  •  Procedure with Parameters (IN,OUT and IN OUT)
  •  Positional Notation and NAMED Notation
  •  Procedure with Cursors
  •  Dropping a Procedure :
    •  Functions in PL-SQL
    •  Difference Between Procedures and Functions
    •  User Defined Functions
    •  Nested Functions
    •  Using Stored Function in SQL Statements :
      •  Packages in PL-SQL
      •  Creating PACKAGE Specification and PACKAGE Body
      •  Private and Public Objects in PACKAGE
  • Module: Database Triggers in PL-SQL

  •  Types of Triggers
  •  Row Level Triggers
  •  Statement Level Triggers
  •  DDL Triggers
  •  Trigger Auditing
  • Module: Using LOBS

  •  Large Objects (LOBS)
  •  Creating Tables-LOB
  •  Working with LOB Values
  •  Inserting, Updating & Deleting Values in LOBs
  •  Populating Lobis DBMS_LOB Routines
  •  Using B-FILE
  • Module: Introduction to RDBMS

  •  Feature of RDBMS
  •  Advantages of RDBMS over FMS ad DBMS
  •  Need for Database Design
  •  Support of Normalization Process for Data Management
  •  Client server Technology
  •  Oracle Corporation Products
  •  Oracle Versions
  •  About SQL & SQL*PLUS
  • Module: Introduction to SQL Database Object

  •  Oracle Pre Defined Data Types
  •  DDL Commands
  •  Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop)
  •  DML-Insert, update, delete
  •  Comparison and Conditional Operators
  •  Arithmetic and Logical Operators
  •  Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
  •  Working with DML, DRL Commands
  •  Operators Support
  • Module: Grouping the Result of a Query

  •  Using Group by and Having Clause of DRL Statement
  •  Using Order by Clause
  • Module: Querying Multiple Tables (Joins)

  •  Equi Join/Inner Join/Simple Join
  •  Cartesian Join
  •  Non-Equi Join
  •  Outer Joins
  •  Self Join
  • Module: Working with DCL, TCL Commands

  •  Grant, Revoke
  •  Commit, Rollback, Save Point
  •  SQL Editor Commands
  •  SQL Environment Settings
  • Module: Additional

  •  Working with Sequences
  •  Working with Synonyms
  •  Working with Index and Clusters
  •  Creating Cluster Tables, Implementing Locks, working with roles
  • Module: Locks

  •  Row level Locks
  •  Table Level Locks
  •  Shared Lock
  •  Exclusive Lock
  •  Dead Lock
  • Module: PL-SQL

  •  Introduction to Programming Languages
  •  Introduction to PL-SQL
  •  The Advantages of PL-SQL
  •  PL-SQL Architecture
  •  PL-SQL Data types
  •  Variable and Constants
  •  Using Built_in Functions
  •  Conditional and Unconditional Statements
  •  Simple if, if… else, nested if..else, if..else Ladder
  •  Selection Case, Simple Case, GOTO Label and EXIT
  •  Iterations in PL-SQL :
    •  Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
    •  SQL within PL-SQL
    •  Composite Data types (Complete)
    •  Cursor Management in PL-SQL
    •  Implicit Cursors
    •  Explicit Cursors
    •  Cursor Attributes
    •  Cursor with Parameters
    •  Cursors with LOOPs Nested Cursors
    •  Cursors with Sub Queries
  • Module: Exceptions in PL-SQL

  •  Types of Exceptions
  •  User Defined Exceptions
  •  Pre-Defined Exceptions
  •  Raise_Application_Error
  •  SQL Error Code Values
  • Module: Implementing Object Technology

  •  What is Object Technology?
  •  OOPS-Object Instances
  •  Creation of Objects
  •  Creating User Defined Data Types
  •  Creating Object Tables
  •  Inserting Rows in a Table Using Objects
  •  Retrieving Data from Object Based Tables
  •  Calling a Method
  •  Indexing Abstract Data Type Attributes
  • Module: Using Collections

  •  Advantages of Collection
  •  Dynamic Cursor
  •  Weak Ref Cursor
  •  Strong Ref Cursor
  •  Nested Tables VARRAYS or VARYING Arrays
  •  Creating Tables Using Nested Tables
  •  Inserting, Updating & Deleting Nested
  •  Table Records
  •  Nested Table in PL-SQL
  • Module: Oracle Database Architecture

  •  Introduction to Oracle Database Architecture
  •  Physical structures Logical structures
  •  DB Memory Structures Background Process
  •  2 Tire, 3 Tire, N-Tier Architecture

Why Efficient India ?

Our Trainers are having more than 3 years of experience in MNC Company.

Trained 50+ Students.

Well Equipped Computer Lab & Internet.

Interview Preparation & Technical Event.

Strong Practical & Theoretical Knowledge.

Corporate Exposure through Us.

100 % Job Assistance.