Oracle Database 11g



Oracle Database 11g

Structure of the Module

Introduction to DBMSSyllabus

  • What is DBMS
  • Relational Data Models
  • Data integrity rules
  • Normalization
  • Introduction to data processing methods - Client/Server
  • Oracle Architecture
  • What is grid computing?

SQL

  • Creating Tables
  • Integrity Constraints
  • Adding, updating and dropping columns
  • Transaction and locking
  • Functions
  • Grouping data
  • Using ROLLUP and CUBE
  • Joing tables
  • ANSI Join
  • Sub queries
  • Working with TOPn analysis
  • Views
  • Materialized Views
  • Using indexes and clusters
  • Index Skip Scan
  • Secutiry
  • Report generation using SQL*Plus commands
  • Distributed databases
  • Partitioning
  • List partitioning
  • Lobs

PL/SQL Programming

  • What is PL/SQL
  • Structure of PL/SQL block
  • Control statement
  • CASE expression
  • Exception handling
  • Cursor handling
  • Writing stored procedures and functions
  • Definer rights vs. Invoker's rights
  • Autonomous transactions
  • Database triggers
  • Native dynamic SQL
  • Flashback query
  • MERGE statement
  • Multitable insert
  • Using Regular Expressions

Object Features

  • Object types
  • Object Inheritance
  • Varrays
  • Nested tables
  • Object views

New Features Of Oracle Database 11g

  • Audit Vault and Hot patching
  • Security enhancements - case sensitive passwords
  • Query result cache and PL/SQL function result cache
  • Fine grained depedency tracking
  • Enhancements related to Triggers
  • PL/SQL sequences
  • Virtual Columns & readonly tables

    For more Info    Catch Me : 

   Mail :  techtrainin@gmail.com
   Mob : 91-9912326989
   Note : Course Through Online or Offline .
   

No comments:

Post a Comment