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

Aptech Computer Education
In Mumbai

Price on request
Compare this course with other similar courses
See all

Important information

  • Course
  • Mumbai
  • 40 hours of class

Important information

Where and when

Starts Location
On request
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