Course in Oracle 9i/10g

SpymekTech Solutions Pvt. Ltd.
In Pune

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

Important information

  • Course
  • Pune
  • 96 hours of class

Important information

Where and when

Starts Location
On request
D66, 6th Floor, Rahul Complex, Near Krishna Hospital Paud Road, Kothrud, 411029, Maharashtra, India
See map

Course programme

For taking admission to this course, candidates must have sufficient knowledge of any one Programming Language and fundamentals of Databases. After completing this course, students may enroll for Oracle Certification.

In this programme, students will learn to:

* Assemble robust & scalable Oracle9i database application
* Set up a model for data and a framework for storage
* Build up commanding and competent Structured Query Language statements
* Write down reusable structured Procedural Language/Structured Query Language code with cursor, procedure and trigger
* Develop performance of applications by using index and optimizing Procedural Language/Structured Query Language

This programme is important for the candidates working with Oracle9i and for those as well, who will work in the future. Practice with relevant databases and acquaintance with fundamental programming conceptions are useful.

Computer Basics and Window Operating System information is a benefit. Any Programming Language, Database Management System like Dbase or FoxPro is preferred.

Course Syllabus:

* Preface of Database Management System
* Database Designing, Entity-Relationship Diagrams and Normalization
* Preface of Structured Query Language and Structured Query Language *Plus
* Structured Query Language -DDL
* SQL- Data Retrieval
* SQL- Data Manipulation Language
* Processing of Transactions
* Viewpoints, Synonyms and Sequences
* Indexing and Clustering
* Procedural Language/Structured Query Language, Procedural Language/Structured Query Language Modules
* Cursors, Methods and Functions
* Packages and Database Triggers
* Architecture of Oracle

Compare this course with other similar courses
See all