DATABASE

Database technology is one of the most rapidly and effectively grown areas of computer and information science. A Database Management System (DBMS) provides flexibility in the storage and retrieval of data and production of information etc. Relational Database Management System (RDBMS) provides Data Independence, Data Distribution, Security Restrictions, Integrity Constraints and inconsistency of data can be avoided. Oracle10g provides the first, true, complete and integrated infrastructure for “Business Intelligence”. It utilizes an integrated architecture with built in functionality for Scalability, Performance, Extraction, Transformation, Load(ETL), Online Analytic Processing(OLAP) and Data Mining.

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