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

5 Ways to Select a Relevant Thesis Topic

Undergrad or graduate students in general always encounter this one difficulty when it comes to developing a thesis, that is selecting a thesis topic. As there are hundreds and thousands of topics for everyone to use, but selecting the best topic is the big challenge on the picture. One has to know which particular niche is most suited for your chosen field, which shows the most interesting, and most especially which has the most vast number of resources. Let us be honest here, no matter how compelling or exceptional your topic is, if the resources are insufficient, then it is pointless to devote time and effort to the thesis.

A thesis topic is the very first thing that someone who is studying under a bachelor’s degree or doctoral program needs to come up with. At first, there are tons of topics you can think of and then it comes down to 10 to 5 and then down to only one. But unfortunately, that singular topic becomes unavailable because of a gazillion of reasons.

And so, here are a f…