Skip to main content

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

Popular posts from this blog

PhD After M.E/M.Tech? Don’t Panic, It Is The Best Choice

When talking about engineering, we should talk about the post graduation degrees ‘Master of Engineering’ and ‘Master of Technology’. When done with P.G. one old question would rise, what is the next step to take? Majority of the people would stop with P.G. itself and search for job in concerned industries. And most of them don’t know further scope of the education after M.E./M.Tech.
Master of Engineering(M.E) and Master of Technology(M.Tech) are the research based courses that are available in India. These Post Graduation(P.G.) Courses are equivalent to the M.Phil(Master of Philosophy) post graduation degrees in the research fields of ‘Sciences’ and ‘Humanities’. M.E./M.Tech courses are designed to skillify the students in the specializations of respective branches. The skills acquired from these post graduation degrees leaves a lot of options ahead.
Generally four career options will be available after M.E/M.Tech.
To proceed to PhD. To get a job in the related industry. To enter into…

Specilizations Offered in M.Sc in Veterinary Science in Andhra Pradesh

Sri Venkateswara Veterinary University, Tirupathi offers MSC in Veterinary Science. Specializations Offered: Veterinary Anatomy and HistologyAnimal ReproductionGynecology and ObstetricsClinical Veterinary MedicineVeterinary PathologyVeterinary Pharmacology and ToxicologyLive Stock Production ManagementVeterinary Surgery and RadiologyAnimal Genetics and BreedingVeterinary MicroBiologyAnimal NutritionPoultry ScienceVeterinary BioChemistryLive Stock Products and Technology Remaining details about the courses can be seen in their official website http://svvu.edu.in

How to Choose Top Management courses in India during admission in top MBA colleges

Management study in India has got a large number of advantages, from becoming industry ready to receiving a high salary. However, for studying management courses proper choice of specialization is very important. There are a large number of areas for the study of management that includes agribusiness management, international business management, finance management, human resources management, etc.

If you are looking for management study in India then it is very important that you choose a course of study with utmost care and thoughtfulness. There are many areas for specialization in the study of management. You must have a clear understanding of all the types of courses to know how to choose top management courses in India? Several management colleges in India offer about seven to eight areas for specialization. Some of the most common specializations along with emerging ones are human resource, communications, finance, forest management, agribusiness, rural management, insurance and…