Hello sir I want do Oracle 9i- SQL course from the NIIT can you please tell me about the course content and duration and address of NIIT

[Vishal Kotkar]

NIIT offers the Oracle 9i- SQL course and here I am giving you required skill and courses contents as below:-

Courses:- Oracle 9i- SQL course
Duration: 40 hours
Required skill:- applicant should have knowledge of Data manipulation concepts and RDBMS concepts.

Courses 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

Address:-
NIIT Limited
85, Sector 32, Institutional
Gurgaon 122001
India
Tel: +91 (124) 4293000