About Course

Course Information

Oracle 11 g is an Object Relational Database Management System, it was released in year 2009.Oracle database 11g version which contains large amount of data with full flexibility, managing capabilities, more efficient of storing data and secures information.

There are more features in 11G version compare to Oracle 8i,9i,10g.There are new components to install, which increase Optimal Flexible Architecture(OFA).Which represents data files, restoring information, flash recovery concept.

Oracle 11g database which produce real applications to test and let to know if any issues arises in software application. Oracle 11g database which can also handle large amount of data, it also stores large amount of objects in database. This performs best in file system.

Before introducing Oracle 11g,there are two types of Objects named CLOB’S AND BLOB’S,CLOB’S said to be “Classified large Objects” whereas  “BLOB’S said to be Binary Large Objects”. In oracle 10g these two types of objects are not possible to work. To enhance this factor oracle 11g has been introduced which secures large object files.

Oracle 11g contains security, space reduction, well performance which manages large amount of objects to functionize in data base. In oracle 11g compatibility and flexibility is more compare to previous versions of oracle database.

Course Content

Please Download for Detailed Course Content

Core topics of Oracle 11g Online Course

  •  Fundamentals of Database

DBMS Concepts

RDBMS Concepts

RoleS of Oracle in info.mgt.

What is Object – Model?

Oracle versions

Features of Oracle 8i/9i/10g/11G

E-R Modelling

  • SQL

What is SQL?

Role of SQL in RDBMS

Sub-languages in SQL

What is SQL, SQL*PLUS and ISQL*PLUS

Oracle data types

  • Classification of SQL Commands

Types of commands

  •   Data Definition Language (DDL) Commands

Create, alter-add, modify, drop column

and Drop

DATA INTEGRITY CONSTRAINTS

  • KEY CONSTRAINTS
  • DOMAIN CONSTRAINTS
  • REFERENTIAL INTEGRITY CONSTRAINTS

Implementation of data integrity

Data integrity construction

  • DML Commands

INSERT:

INSERT Statement

Oracle Operators

Where clause

Update and Delete statements

SELECT:

Examples on Select using Where Clause

Special Operators

IN, BETWEEN, LIKE, IS NULL

  • Data Joining

What is join

Types of Joins

Cartesian Join

Equi join/Non-Equi join/Outer Join

  • OUTER JOINS

Left outer join, Right outer joins and Full outer join

  • Sub Queries
  • Operators
  • Database Objects
  • INDEXES
  • VIEWS
  • SYNONYMS
  • CLUSTERS
  • SEQUENCE
  • DATA DELETION
  • DATA UPDATION
  • TRANSACTION CONTROL LANGUAGE
  • Sub Queries
  • ORACLE FUNCTIONS
  • CATEGORIES
  • Types of functions

 

PL/SQL

  • CONDITIONAL  STMTS
  • LOOPS-
  • CURSORS
  • PL/SQL RECORDS AND TABLES
  • STORED PROCEDURES
  • FUNCTIONS
  • TRIGGERS
  • PACKAGES
  • OBJECT TECHNOLOGY
  • FILES
  • ORACLE UTILITIES
  • DESIGNING
  • ORACLE Architecture
  • SERVERS & PROCESSES
  • Data Processing
  • Data Partitioning
  • DBTIMEZONE, EXTRACT
  • SQLJ—SQL with JAVA
  • REF CURSORS
  • MISLLANEOUS
  • ORACLE DBA Concepts
  • PROJECT DESCRIPTION

Demo Video

Watch Oracle 11g Demo Video

About Trainer

Trainer Information

  • Having 9+ Years of hands on experience on Financial domain, Telecom and Health care
  • Working from last 9+ years on Oracle
  • Having 5+ Years of Corporate and Online training Experience
  • Oracle 11g Certified Consultant