NIIT Oracle Certification Program: Introduction to ORACLE 9I- SQL

Oracle Certification Programs
INTRODUCTION TO ORACLE 9I- SQL

INTRODUCTION:
Concepts of relational and object relational databases, SQL programming language, create and maintain database objects and to store, retrieve, and manipulate data. Participants also learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Learn how to write SQL and SQL*Plus script files using the iSQL*Plus tool.

Duration: 40 hours

Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
  • Describe relational and object relational database concepts 
  • Retrieve, insert, update, and delete data
  • Use the Single row and Group functions 
  • Retrieve data using additional advanced techniques like using
  • ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
  • Solve problems by using multicolumn subqueries
  • subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
  • Use the iSQL*Plus environment
  • Write scripts to generate script files
  • Generate reports using iSQL*Plus
  • Create and maintain database objects
  • Control transactions
  • Control data/user access
  • Use the Oracle9i Single row functions
  • Use GROUPING SETS and the WITH clause
  • Use the Oracle9i extensions to DML and DDL statements
  • Apply techniques in real life simulation

Back to NIIT Certification Programs Index

PRE REQUISITES:
Participants must be familiar with Data manipulation concepts and RDBMS concepts

EXIT PROFILE:
The candidate would learn how to use Data Server Technology

GLOBAL CERTIFICATION MAPPED:
Program is mapped with OCP vendor certification

Back to NIIT Certification Programs Index