Awarded 'A' Grade
by DTE, M.S

Mahavir Education Trust's

Shah And Anchor Kutchhi Engineering College

MET Chowk, W.T Patil Marg, Chembur, Mumbai - 88. Ph: 25580854

Accreditated for 3 Years by NBA for Electronics Branch & ISO 9001:2000 Certifired

Home About Us Trust Board Academic SAKEC Staff Info Center Contact Us

How to get OCA certification?

Benefits of Certification

Demonstrate Skill

• Certifies your DBA skills with a world leading database

• Shows your depth of knowledge

• Demonstrates your Oracle DBA expertise in tuning and troubleshooting

• Proves your ability to keep a corporation's database running reliably and at peak performance

Enhance Employment Opportunity

• Increases your earning potential

• Opens up careers in one of the hottest job markets

• Shows a measure of professional skill

• Industry now requires certification

• Increases job security.

SCHEDULE

Batch I: Oracle9i:Introduction to SQL

10^th July 2008 to 19^th July (40 hours)

Batch II: Oracle9i:Introduction to SQL

21^st July 2008 to 8^th August (40 hours)

Batch Timings are such that, they will not affect your Academic Schedule

Course contents

1. Oracle9i: Introduction to SQL

•Writing a Basic SQL Statement

•Restricting and Sorting Data

•Displaying Data from Multiple Tables

•Aggregating Data by Using Group Functions

•Writing Subqueries

•Producing Readable Output with iSQL*Plus

•Manipulating Data

•Creating and Managing Tables

•Including Constraints

•Creating Views

•Controlling User Access

•Using Set Operators

•Hierarchical Retrieval

2. Oracle9i: Database Fundamentals I.

•Identifying database administrative users

•Managing an Oracle Instance

•Creating a Database

•Using the Data Dictionary

•Maintaining the Control File

•Describing storage hierarchy

•Establishing the difference between SYSTEM and Non-SYSTEM tablespaces

•Storage Structures and Relationships

•Managing Undo Data

•Understanding the difference between automatic undo management and manual undo management

•Creating and maintaining UNDO tablespaces

•Managing Tables

•Managing Indexes

Click here for Registration

Click here for Detailed Schedule

For any further queries Please contact: Prof. Uday Bhave / Prof. V. C. Kotak