Course in Oracle 9i/10gSpymekTech Solutions Pvt. Ltd.
Price on request
- 96 hours of class
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.
* 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