Course in Introduction to Oracle 9i - SQL (Paper 1)

Aptech Computer Education
In Mumbai

Price on request
You can also call the Study Centre
22657... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Mumbai
  • 40 hours of class
Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
A-302, Vertex Vikas Building Above A to Z Jumbo Zerox Opp. Andheri Railway Station M.V.Road Andheri (East) , 400069, Maharashtra, India
See map

Frequent Asked Questions

· Requirements

Eligibility:- Prior knowledge of data processing concepts and techniques.

Course programme

SQL*Plus, the primary interface to the Oracle database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data. Oracle 9i SQL delivers the fundamentals of relational and object-relational databases and the powerful SQL programming language. Paper 1 makes the student strong in Oracle SQL statements, and iSQL*Plus, which is used for executing SQL and for formatting and reporting purposes.

After the completion of this course, the student will be able to:

* Define database
* Explain basic SQL statements
* Describe the various types of functions available in SQL
* Describe and use the different types of joins
* Describe subqueries
* Describe the process of producing readable output with iSQL*Plus
* Explain data manipulation using SQL statements
* Describe constraints and views
* Describe the various database objects
* List and explain Oracle 9i extensions to DML and DDL statements

Compare this course with other similar courses
See all