HOME ABOUT US COURSES OFFERED ONLINE EXAMS PLACEMENT BRANCHES CONTACT US
Courses Offered
Networking Courses
Master Of Network Engineering Master Of Network Specialist Master Of Network Consultant
CCIE  CCNP

CCNA CISCOSPECIALIST

MCITP(Enterprise) MCITP(Exchange 07)
MCSE   RHCE  MCDBA

Hardware And Networking
Software Courses

Master Of Software EngineeringMaster Of Software SpecialistMaster Of Software ConsultantSoftware Engineering

J2EE  PHP
MCTS(WINDOWS TRACK) MCTS(WEB TRACK)
WPF   WCF SILVERLIGHT

C#    ASP.NET   FRAMEWORK

Software Testing
OCA  OCP
Live Projects Other Courses

Online Exams
RedHat Exams
Cochin
IndiaOptions Softwares Pvt Ltd.
Next to Mymoon theatre, chittoor road, kochi-18. Ph n.o: 0484-2371284. 2372638, 2371869.
E-Mail: info@indiaoptions.in

Trivandrum
IndiaOptions Softwares Pvt Ltd.
2nd Floor, Hantex building,
railway station road,
Thampanoor.
Ph:0471-2329551/52/53
E-Mail: tvm@indiaoptions.in

Oracle 10g(Admin)

Paper 1
Oracle 10g Database SQL Fundamentals I

 

Introduction

    • Retrieving Data Using the SQL Select Statement
    • Restricting and Sorting Data
    • Using Single Row Functions to Customize Output
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables
    • Using Subqueries to solve queries
    • Using the Set Operators
    • Manipulating Data
    • Using DDL Statements to Create & Manage Tables
    • Creating Other Schema Objects
    • Managing Objects with Data Dictionary Views

    Oracle 10g Database SQL Fundamentals II

    • Introduction

        • Controlling User Access
        • Managing Schema Objects
        • Manipulating Large Data Sets
        • Generating Reports by Grouping related Data
        • Managing Data in Different Time Zones
        • Retrieving Data using Subqueries
        • Hierarchical Retrieval
        • Regular Expression Support

      •  

       

      PAPER II

      Oracle 10g Administration Workshop I

      Introduction

      1. Installing the Oracle Database Software
      2. Creating and Oracle Database
      3. Managing the Oracle Instance
      4. Managing Database Storage Structures
      5. Administering User Security
      6. Managing Schema Objects
      7. Managing Data & Concurrency
      8. Managing Undo Data
      9. Implementing Oracle Database Security
      10. Configuring the Oracle Network Environment
      11. Proactive Maintenance
      12. Performance Management
      13. Backup and Recovery Concepts
      14. Performing Database Backups
      15. Performing Database Recovery
      16. Performing Flashback
      17. Moving Data

       

       

       

      PAPER III

      Oracle 10g Administration Workshop II

        • Introduction
        • Configuring Recovery Manager
        • Using Recovery Manager
        • Recovering from Noncritical Losses
        • Database Recovery
        • Flashback
        • Dealing with Database Corruption
        • Monitoring & Managing Memory
        • Automatic Performance Management
        • Managing Schema Objects
        • Managing Storage
        • Automatic Storage Management
        • Managing Resources
        • Automating Tasks with the Scheduler
        • Database Security
        • Using Globalization Support

        Facilities:  1.24 Hrs Lab with Internet Facility 2.Students can do Lab till they pass Online Examination without any extra cost.

        Batch Timings:  7 - 9 am / 10 - 1 pm / 2 - 5 pm / 6 - 8 pm / Sat & Sun Only / Sunday Only.