Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.


  • Concepts of DBMS
  • Introduction
  • Importance and Need
  • Database Models and Normalization
  • Relational
  • Object
  • Normalization Techniques
 Introduction to RDBMS
  • Concepts of RDBMS
  • Introduction
  • Comparision with DBMS
  • COOD Rules
  • Normalization Revisited
  • Concepts of ORDBMS & OODBMS
  • Introduction to ORDBMS
  • Introduction to OODBMS
  • Comparision and analysis
 Structured Query Language(SQL)
  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database objects
  • Table,View
 Commands in SQL
  • Data Defination Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)
  • Transaction Control Language(TCL)
  • Database Security and Privileges(DCL)
 Working with DDL,DML,TCL Commands
  • Operators
  • Conditional,Logical,Comparison,SET
  • Functions
  • Date,Number,Character,String,Group,Group by,Having clause
  • Transformation Functions
  • NVL,NVL2(9i)
  • Aggregate Functions
 Integrity Constraints
  • Different Types of Integrity Constraint
  • Use of Integrity Constraint in table
  • Usage of Joins
  • Different Types of Joins
  • Equi Join
  • Cartesian join
  • Self Join
  • Outer join
 Sub Queries
  • Need of Sub Queries
  • Nested Sub queries
  • Co-related Sub Quries
  • Flash Back Queries (9i)
  • Importance of views
  • Creating,Manipulating Views
  • Materialized views(9i)
 Working with database objects
  • Sequences and synonyms
  • Index,Cluster,Creating cluster table
 Using External Tables(9i)
  • System Privileges
  • Table Privileges
 Locks and SQL Plus editor commands
  • Introduction to PL/SQL
  • Advantage of PL/SQL
  • Data Types in PL/SQL
  • Variables and Constants
  • Referencing NON-PL/SQL Variable
  • Using built in Functions
  • Conditional and iterative Statements
  • SQL in PL/SQL
  • Composite Data Types
  • Cursors
  • Exceptions:-Predefined ,User Defined
  • Records and PL/SQl table types
 Advanced PL/SQL
  • Introduction to Triggers
  • Types of Triggers : - Row level,Statement Level
  • Before and After ,Instead of Triggers
  • Procedures,Functions in PL/SQL
  • User Defined Packages
  • Dropping triggers,Procedures,Functions