Course in Oracle 9i/10g
Course
In Pune
Description
-
Type
Course
-
Location
Pune
-
Class hours
96h
Facilities
Location
Start date
Start date
Reviews
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
Course in Oracle 9i/10g