Price: Check with seller

Description

Oracle training center , best oracle training, best oracle


============ Contact PARTHIBAN 9840496320=============


Best oracle training in chennai adyar - Chennai@Greens Technologys


Contact PARTHIBAN 9840496320


Free Demo Class avaiable Daily!!


Learn oracle @ Greens Technologys


• oracle 10g,11i


Why Greens Technologys


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 oracle training available


Real-time scenario project training


Flexible timing


Weekend batches available for working professionals.


Guidance to oracle Cetification


100 % job assistance


Course 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


Project - Case Study


Resume Preparation and Assignment


Job oriented training and Tips to empower professionalism and career.


List of the courses we offer:


 


 


Greens Technologys,
No.15 First Street,Padmanabha nagar,
Adyar,
Chennai-20.


N.PARTHIBAN


HR-DEPARTMENT

Phone(M): +91 98404 96320
Phone(L): 044 43511623

eMail: greens.adyar@yahoo.com


 


 


 


best oracle  training center in Chennai, best oracle  training center in Chennai Adyar, best oracle


training center , best oracle training, best oracle, best oracle ,Chennai,GOOD oracle TRAINING IN CHENNAI ADYAR JOB ORIENTED,oracle TRAINING IN CHENNAI ADYAR,oracle TRAINING IN CHENNAI,oracle TRAINING,oracle,oracle , APPS ,oracle TRAINING IN CHENNAI,oracle TRAINING,CHENNAI,ADYAR,GOOD AND BEST oracle TRAINING IN CHENNAI ADYAR,VERY GOOD oracle TRAINING IN CHENNAI,VERY GOOD oracle TRAINING IN CHENNAI,GOOD AND BEST oracle TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST oracle TRAINING INSTITUTE IN CHENNAI,oracle training in Chennai,oracle training center in Chennai,oracle training institute in Chennai,oracle,11i,10g Chennai,oracle training institute in Chennai,oracle institute in Chennai, best oracle 11i training center in Chennai, best oracle 11i training center in Chennai Adyar, best oracle


training center , best oracle  training, best oracle, best oracle ,Chennai,GOOD oracle TRAINING IN CHENNAI ADYAR JOB ORIENTED,oracle TRAINING IN CHENNAI ADYAR,oracle TRAINING IN CHENNAI,oracle TRAINING,oracle,oracle , APPS ,oracle TRAINING IN CHENNAI,oracle TRAINING,CHENNAI,ADYAR,GOOD AND BEST oracle TRAINING IN CHENNAI ADYAR,VERY GOOD oracle TRAINING IN CHENNAI,VERY GOOD oracle TRAINING IN CHENNAI,GOOD AND BEST oracle TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST oracle TRAINING INSTITUTE IN CHENNAI,oracle training in Chennai,oracle training center in Chennai,oracle training institute in Chennai,oracle,11i,10g Chennai,oracle training institute in Chennai,oracle institute in chennai


 

More Details

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