ss technologies
4000 3800
2 months

Course Summary

IT, Software & Hardware
2 months
Beginner/Entry level

Course Description

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.

Topics Covered

    • 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

    • LOBS, BLOBs, CLOB, NCLOB, BFILE, REG data type
    • REF, DEREF ,VALUE,DANGLING operations

    • 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.

See other jobs

Share Course on :
Guidewire Online Training

Software Testing
ss technologies
5 months