|  
Home | About Us | Sitemap | Contact Us
 
       
Services
Portfolio
Product
Development
Training
Clientele
 
Training | Course: Oracle
Sub Course: Oracle10g SQL & PL/SQL
 
DBMS
 Concepts of DBMS
         *  Introduction
         *  Importance and Need
         *  Database Models and Normalization
         *  Models
         *  Hierarchical
         *  Network
         *  Relational
         *  Object
         *  Normalization Techniques
 Introduction to RDBMS
         *  Concepts of RDBMS
         *  Introduction
         *  Comparison with DBMS
         *  CODD rules
         *  Normalization Revisited
         *  Concepts of ORDBMS & OODBMS
         *  Introduction to ORDBMS
         *  Introduction to OODBMS
         *  Comparison and analysis
 Structured Query Language
         *  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 function
 DECODE, TRANSLATE
         *  NVL, NVL2(9i), Aggregate Functions
         *  Integrity Constraint
         *  Different Types of Integrity Constraint
         *  Use of Integrity constraint in table
         *  Joins, Usage of joins, Different Types of joins
         *  Equip join, Cartesian join, Self join, Outer join
         *  Sub queries, Need of sub queries
         *  Nested sub queries, Co-related sub quires
         *  Flashback queries
         *  View, Importance of views
         *  Creating, manipulating views, Materialized views
         *  Working with database objects
         *  Sequences and synonyms
         *  Index, cluster, creating cluster table
         *  Using external tables
         *  System privileges, Table privileges
         *  Locks and SQL plus editor commands
 
 
PL/SQL
 Introduction
         *  Introduction to PL/SQL
         *  Advantages of PL/SQL
         *  Data types in PL/SQL
         *  Variable and constants
         *  Assignments and constants
         *  Referencing NON-PL/SQL Variable
         *  Using built in functions
         *  Conditional and Iterative statements
         *  SQL in PL/SQL
         *  Composite data types
         *  Cursors, Ref Cursor
         *  Exception:-predefined, user-defined
         *  Records and PL/SQL table types
 Advanced PL/SQL
         *  Introduction to Triggers
         *  Types of triggers:-row levels, statements level
         *  Before and after, instead of triggers
         *  Procedures, Functions, Packages in PL/SQL
         *  Argument modes
         *  Built-in packages
         *  Dropping triggers, procedures, functions
         *  Reference cursors
         *  Usage of ref cursors in procedures, functions, packages
 
 
       
Our Services
Product Expertise
Industry Focus
Corporate Training
Software Development
Web Designing
Search Engine Optimizatior
Corporate Training
Web Hosting
E-Commerce Application
Inventory Management System
Online Test System
HR and Payroll System
Jewellery Management System
   
Banking & Insurance
Education
E-Commerce
Accounting & Finance
Real Estate
Visual Studio 2008/2010
Oracle Database
Teradata Database
Dataware Housing - Informatica
Testing
Copyrights © 2010. 7HillTop Technologies. All Rights Reserved.
Feedback Career Marketing Technology