Excellent Oracle training in Chennai/Adyar @ iSkill Tech

25/06/2012 Computer - Multimedia Classes

Price: Check with seller

Description

Excellent oracle training in Chennai/Adyar @ iSkill Tech
Free Demo Class avaiable Daily!!
Contact Priya 919894994935



Why i-Skill Tech
Real time Experienced Faculty with more than 5 years of experience working in MNC's like Infosys,IBM,Wipro..
Limited Batch size
Online and corporate training available
Real-time scenario project training
Flexible timing
Weekend batches available for working professionals.
Guidance to oracle Cetification
100 % job assistance



email: iskilltech@gmail.com
Website: www.iskilltech.com



Branch:
New # 84 / Old #45-A, Venkatrathnam Nagar, Adyar, Chennai - 600020.
Besides Lawrence & Mayo
Opp to Hero Honda Showroom



Learn oracle @ i-Skill Tech


Contents


DBMS
• Concepts of DBMS
• Introduction
• Importance and Need
• Database Models and Normalization
• Relational
• Object
• Normalization Techniques
Introduction to RDBMS
• Concepts of RDBMS
• Introduction
• Comparison with DBMS
• COOD Rules
• Normalization Revisited
• Concepts of ORDBMS & OODBMS
• Introduction to ORDBMS
• Introduction to OODBMS
• Comparison and analysis
Structured Query Language(SQL)
• Introduction to SQL
• Predefined Data Types
• Introduction to database objects
• Table, View
Commands in SQL
• Data Definition 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
• DECODE,TRANSLATE
• NVL,NVL2(9i)
• Aggregate Functions
Integrity Constraints
• Different Types of Integrity Constraint
• Use of Integrity Constraint in table
Joins
• 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)
View
• 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
PL/SQL
• 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

More Details

Total Views:8
Reference Id:#77227
Phone Number:9894994935
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com