Skip to main content

Posts

NIIT Oracle Certification Program: ORACLE DATABASE 10G: PL/SQL Fundamantals

ORACLE DATABASE 10G: PL/SQL FUNDAMENTALS
INTRODUCTION:

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.
Duration: 18 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Use PL/SQL programming constructs and conditional control statementsWrite PL/SQL code to interface with the databaseDesign PL/SQL program units that execute efficientlyHandle run-time errorsDescribe stored procedures and functions
Back to NIIT Certification Programs Index

PRE REQUISITES:
The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction t…

NIIT Oracle Certification Program: ORACLE 10G: Introduction to SQL

ORACLE 10G: INTRODUCTION TO SQL

INTRODUCTION:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.
Duration: 48 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Identify the major structural components of Oracle Database 10gRetrieve row and column data from tables with the SELECT statementCreate reports of sorted, restricted and aggregated dataRun data manipulation language (DML) statements to update data in Oracle Database 10gObtain metadata by querying the dictionary views
Back to NIIT Certification Programs Index

PRE REQUISITES: The students…

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

Oracle Certification ProgramsINTRODUCTION 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 dataUse the Single row and Group functions Retrieve data using additional advanced techniques like usingROLLUP, CUBE, set operators, correlated subqueries and hierarchical queriesSolve problems by using multicolumn subqueriessubqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueriesUse the iSQL*Plus environmentWrite scripts to generat…

How Engineering Helps in Finding Competitive Jobs?

If you are an engineering graduate and looking for engineering jobs, but unable to find one, don’t’ really panic. Engineering and its applications are used almost in anything and everything one comes across. Right from the household appliances to the toy used by a kid or a car flaunted by your neighbors everything has engineering mechanism put in to use to make the machinery function, exactly the way it should. Best about technology is that it has made life remarkably easy going, but the worst is that it is really dynamic. Each day the technology experts come up with something out of the box which out dates the gadget you already possess. But this clearly reflects the pace at which the industry is growing and the future job prospects. Engineering as a discipline is a vast subject comprising several branches within. Students pursuing graduation or post-graduation specialize in specific subject as in engineer in civil engineering, engineering in mechanical, engineering in aeronautics, e…

List of B.E./B.Tech Branches

A Bachelor of Engineering/Technology degree will usually be undertaken in one field of engineering, which is sometimes noted in the degree postnominals, as in BE(Aero) or BEng(Elec). Common fields for the Bachelor of Engineering/Technology degree include the following fields:
Sl.noBranch1Bio-Technology2Geo-Technical Engineering3Geo-Environmental Engineering4Structural Engineering5Infrastructure Engineering6Urban Transportation Engineering7Transportation Engineering8Computer Networks and Information Security9Computer Science10Information Technology11Software Engineering12Bio- Informatics13Electrical Power Engineering14Power Electronics15Digital Systems and Computer Electronics16Systems and Signal Processing17Embedded Systems18Environmental Geomatics19Environmental Management20Energy Systems21Nano-Technology22Chemical Technology23Spatial Information Technology24Geo-Informatics and Survey Technology25Watershed and Environmental Tech.26Advanced Manufacturing Systems27Thermal Engineering28…

List of M.E./M.Tech Branches

A Master of Engineering/Technology degree will usually be undertaken in one field of engineering, which is sometimes noted in the degree postnominals, as in ME(Aero) or MEng(Elec). Common fields for the Master of Engineering/Technology degree include the following fields:
Sl.noBranch1Bio-Technology2Geo-Technical Engineering3Geo-Environmental Engineering4Structural Engineering5Infrastructure Engineering6Urban Transportation Engineering7Transportation Engineering8Computer Networks and Information Security9Computer Science10Information Technology11Software Engineering12Bio- Informatics13Electrical Power Engineering14Power Electronics15Digital Systems and Computer Electronics16Systems and Signal Processing17Embedded Systems18Environmental Geomatics19Environmental Management20Energy Systems21Nano-Technology22Chemical Technology23Spatial Information Technology24Geo-Informatics and Survey Technology25Watershed and Environmental Tech.26Advanced Manufacturing Systems27Thermal Engineering28Engi…