Compufield -computer Institute training,learning,academy,colege, specialized in fast track courses in multimedia,web designing,e-commerce,software, in Network engineering,certification courses,fashion, textile,jewellery,interior designing courses. India,Bombay(Mumbai)

Our Courses


			Email ID:

Why Foreign / Indian students prefer to study Computer Courses
at COMPUFIELD? Mumbai - India

Search for our courses

~	C & C++
~	Java
~	C#
~	VB.NET
~	ASP.NET
~	Diploma in JAVA Programming
~	Diploma in DOT NET Technology
~	Diploma In Software Engineering
Courses in Database Administration
~	Diploma in ORACLE Database Administrator (OCP) Oracle 9i DBA
~	Diploma in ORACLE Database Administrator (OCP) Oracle 10g DBA
~	Diploma in Database-Administration [RDBMS]
~	ORACLE (Paper I ) SQL
~	MS SQL Server 2005
Courses in Web Development
~	Diploma in Internet Application & E-Commerce
~	Diploma in Web 2.0 Technology (Rich Internet Application)
~	Certificate in Web Development (Server Side)
~	Certificate in Web 2.0 Technology (Client Side)
~	LAMP

Oracle (Paper I - 1Z0-007) SQL

PAPER I - IZ0-007 : SQL

Our Programming Student's Review

Programming Review
1	2	3

PAPER I - IZ0-007 : SQL

Oracle9i is a Relational Database Management System(RDBMS) with Object Relational Database Management(ORDBMS) futures. Oracle9i is the latest technology, which has many new features over previous versions like 8i and 8. Oracle9i comes with new SQL enhancements.

Salient Features

~

~

~

~
~

Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges
Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
Oracle provides open connectivity to & from other vendors software
Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

Application

~

~

Education Industry Software Development Industry Data warehouse and maintenance Domestic Air Services Production Industry
Banking Industry

Topics Covered

~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~

Writing Basic SQL Select Statement.
Restricting and Sorting Data.
Displaying Data from Multiple Tables.
Aggregating Data Using Group Functions.
Sub queries.
Producing Readable Output with iSQL*Plus.
Manipulating Data.
Creating and Managing Tables.
Including Constraints.
Creating Views.
Other Database Objects.
Controlling User Access.
SQL Workshop.
Using Set Operators.
Date time Functions
Enhancements to Group by Clause.
Advanced Sub queries.
Hierarchical Retrieval.
Extensions to DML and DDL Statements.

Certification Exam Fees

Certification Exam	US $
PAPER I : SQL - 1Z0-007	95
Paper II : DBA I - 1Z0-031	125
Paper III : DBA II -1Z0-032	125
Paper IV : Performance Tuning - 1Z0-033	125

Oracle - SQL Paper I

Course Duration	Fees (Indian RS.)	Fees (US $)
40 sessions of 1 hr. each	7,000*	200*

SQL + DBA I + DBA II + Performance Tuning Paper I To Paper IV

Course Duration	Fees (Indian RS.)	Fees (US $)
160 sessions of 1 hr. each	33,500*	950*

* The course fee mentioned above does not include the Examination Fee.

Franchise
Enquiry

IT Corporate Training

Student Project Galleries

Any Course,
Any Time, Any Where

Free E-greetings
For ever occasion

Students Registration
	Registration Form
	Payment Facilities
	Visa to Apply
	Accommodation
	Course Schedules
	Indian Consulates

Miscellaneous
	Location of Compufield (HO.)
	Site Map
	About Us
	FAQ
	Our Centers

Management has full right to Change courses, contents, tuition fees without prior notice

COMPUFIELD offers a unique style of learning -
	One computer : One student : One Instructor	The timing can be fixed based on our mutual convenience, between 9.00 a.m. to 7.00 p.m.
	Maximum Instructor to Student Ratio 1:4	Course duration in working days = Total sessions divided by number of sessions (hours) per day.
	Sessions : Each session will be of 1 hour	No extra charges/refund for more/less time taken to complete the course.
	Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)	Lodging, boarding and travelling not included in the fees.
	Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.	Management has full right to change courses, contents, tuition fees without prior notice.