Oracle course training institute ameerpet hyderabad

Oracle Course Training Institute in ameerpet,Hyderabad

oracle Course content

Oracle DATABASE 11/12c
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.

• Introduction to databases
• Models
• RDBMS Concepts
• ORDBMS Concept
• E-R Model
• Introduction to Oracle Database
• Oracle Database History
• Introduction to oracle 11g features/12c features
• Oracle 11g Server and DB Architecture

• Introduction to SQL
• Features of SQL
• Introduction to SQL * plus
• Role of SQL in Oracle 11g

Classification of SQL Commands
Data Definition Language (DDL) commands
• Introduction to DDL commands
• Create Table
• Rules for Naming a tab le
• Altering the table structure using ALTER
• Change the table name using RENAME
• Deleting data using TRUNCATE
• Dropping table using DROP

Data Manipulation Language(DML) commands
• Insert of Data (value and address method)
• Insertion of Nulls
• Overriding the Nulls with User defined Values
• Insertion of Date in required formats
• Data Loading methods in Oracle 11g
• Data Loading Performance improvement tips

Data Updation
• Techniques of Updation
• Complex Data Updation
• Correlated Query mechanism in Update

Data Deletion
• Simple data deletion
• Critical Data deletion
• Table delete Vs table truncate

Transaction Control Language Commands
• Introduction of Production Databases
• Introduction to Transaction and ACID properties
• Transaction management in oracle 11g
• What is Session and Types of Terminations
• Commit ,Rollback and Save point

Data Retrieve Language(DRL) command
• Select command and it’s clauses
• Data Retrieving methods
• Data sorting in oracle 11g
• Null value sort and user defined null sorts

• Type of operators in oracle 11g & Filters

• Type of functions in oracle 11g
• Pseudo columns of oracle 11g

Table joining in Oracle 11g
• Introduction to table join
• ANSI 1992 and ANSI 1999 Standard
• Types of joins
• Inner and outer joins
• Equi/Non equi join/self join/ Cartesian join
• Oracle specific join and enhancements

Integrity Constraints
• Introduction to Constraints
• Importance of Integrity Constraints
• Levels of constraints
• Type of constraints
• Name of the constraints
• Simple sub query
• Complex sub query on multiple data sources
• Co-related sub query

Oracle database objects: Index:
• Introduction to index
• Types of indexes in Oracle 11g
• Index for OLTP and OLAP

• Introduction to cluster
• Type of clusters and their usage
• Performance evaluation methods in oracle 11g
• Explain plan command usage and oracle scripts

• Introduction to Views
• Type of Views and usage
• Performance issues with views
• Background process of views
• DML restriction on Views
• Materialized views and usage

• Introduction to Synonym and usage
• Private synonyms
• Public synonyms
• How to see list of synonyms
• Dropping the synonyms

• Introduction to Sequence and Usage
• Pseudo Columns usage in sequence(Nextval and Currval)
• Sequence with positive values Ascending and Descending
• Sequence with negative values Ascending and Descending
• Sequence with Cycle option
• Dropping the sequences

Concurrency Control Using Locks
• Types of Locks
• Levels of Locks
• Row level
• Page level
• Table level
• Modes of Locks
• Share mode
• Share update mode
• Exclusive mode
• Wait and no wait options

Data Control Language Commands:

• What is privilege

• What is role

• Granting Privileges

• Removing Privileges

• Cascading Privileges

Plus commands

• Environment Setting Commands

• Screen Formatting Commands


• Drawbacks of RDBMS

• Introduction to ORDBMS

• Implementation of Object Technology in Oracle 11g

Abstract Datatypes

• Persistent object Vs transient object

• Column object vs Row Object

• Introduction to Object table and usage

New Datatypes


• DBMS_LOB package and its routines

• Using collection(composite types)

• Nested Tables Vs Varray

• Advantages of Collections

• Transaction Consistency

Data partitions and Parallel Process:

• Types of partitions

• Range partitions

• List partitions

• Hash partitions

• Composite partitions

• Index partition

• Global partition

• Local partition

• Parallel query process.
Flow control statements
• If/nested if/if-else/if-elsif/case/
searched case/goto/continue/raise

Iterative statements:
• Simple loop/ while loop/for /for – reverse

Embedded sql:
• Introduction of embedded sql
• Role of embedded sql in pl/sql
• Constructs of embedded sql
• Transaction management using embedded sql

Dynamic Sql:
• Introduction to dynamic sql
• Usage of dynamic sql in pl/sql

Exception handling
• Introduction to exceptions
• Importance of exceptions in pl/sql
• Type of exceptions
• Named system exceptions
• Un named system exceptions
• User defined Exceptions
• Introduction and usage of predefined exceptions and STANDARD Package
• Anchor datatypes
• Introduction to Anchor datatypes and advantages
• Connection with codd’s rules.

Cursor Management pl/sql
• Introduction to cursor management
• Pictorial presentation of cursor mechanism
• Introduction and usage of implicit cursor
• Introduction and usage of explicit cursor
• Cursor attributes
(%found, %notfound, %rowcount, %isopen)
• Cursor using simple loop
• Cursor using while loop
• Cursor using for loop
• Cursor exceptions
• Data locking
• Data manipulation through cursors
• REF cursor
• Bulk fetch and bulk data retrieval in pl/SQL
• Bulk collection
• Bulk binding mechanism of cursors
• Dynamic behavior of cursor management
• Parameterized Cursor
• Cursors using Joins

• Introduction to Subprograms
• Advantages of Subprograms
• Type of subprograms

Stored Procedures
• Introduction to Procedures
• Types of modes(In, Out and In/Out)
• Sections in the Procedures
• Declaration of Procedure
• Body of the procedure
• Cursors using procedure
• Use & Declaration of Host/Bind variable
• How to execute the procedure

Stored Functions
• Introduction to Functions
• Sections in the functions
• Declaration of function
• Body of the function
• How to execute the Function

• Introduction to package
• Stand alone schema Vs packaged objects
• Encapsulation mechanism of package
• Function overloading
• Procedure overloading
• Global variables in package specification
• Usage of pragma serially _reusable
• Restrict references and compiler hints
• Introduction and usage of pragma
• Db trigger
• Introduction to database trigger
• Types of trigger
• Triggering events
• Usage of old and new references
• New trigger instead of
• Trigger cascading
• Enabling/disabling triggers
• Schema triggers
• Table mutation error
• Transaction auditing trigger
Advanced pl/SQL topics
• User defined datatypes(records)
• Subtype of pl/SQL
• Pl/SQL associated array(PAA) (2d arrays)
• Dynamic behavior of PAA
• PAA attributes
• Autonomous Transactions
• Advantages of autonomous transactions
• Usage of autonomous transaction
• Scope of autonomous transaction
• Usage of autonomous transaction in triggers
• Using FORALL statement
• About %bulk_rowcount
• Definer Vs Invoker rights in stored procedures
• Optimizing hints to the stored procedure.

oracle training in hyderabad
Oracle training in ameerpet
oracle classes
Best oracle dba training in hyderabad