Course in Oracle 9i/10g

Course

In Pune

Price on request

Description

  • Type

    Course

  • Location

    Pune

  • Class hours

    96h

Facilities

Location

Start date

Pune (Mahārāshtra)
See map
D66, 6th Floor, Rahul Complex, Near Krishna Hospital Paud Road, Kothrud, 411029

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

Price on request