Database Designer Course in Patiala

ORACLE 10g SQL

    Introduction to DBMS, RDBMS & ORDBMS
     Introduction to SQL
     SQL Functions(Single Row & Multiple Row)
    Joins
     Producing Readable output with SQL* Plus
    Sub-Queries
     Database objects (Tables, Views, Sequences)
     Data Integrity Constraints
     Locks
     Other database Objects
     Using set Operators

PL/SQL Programming

    - Introduction
     Variables Scope Control Structures
     Nested Blocks
     Exception Handling
     Cursors
     Advanced Cursors
    Procedures & Functions
     Packages & Advanced Packages
     Database Triggers
    LOB (Large Objects)

SQL Server (2005/2008)

     Introduction to Database
    SQL Server and RDBMS
     SQL Essentials
    SQL Advanced Indexes
     Views, Procedures & Triggers
     Replication
     Distributed Data
    Extensibility of SQL Server
    Administrative Tools

Industrial training in patiala