oracle training

oracle

Oracle Certified


Oracle Certification programs provide you with lots of different Excercise and Practices which are being utilized together with unique databases. Oracle database to be able to get the information from its specific database component. Here, you will under stand exactly about the best way to code within approaches to combine by using Oracle database

We are Providing :

    1. Oracle Certified Associate (OCA-DBA)
    2. Oracle Certified Professional (OCP-DBA)

DBMS Concepts

    1. Database design
    2. Entity – Relationship diagram
    3. Normalization
    4. Relational Database

Oracle 10g: SQL

    1. Introduction
    2. Writing Basic SQL statement
    3. Restricting & Sorting Data
    4. Using Single Row Function for Customized O/P
    5. Displaying Data from Multiple Tables
    6. Reporting aggregated Data
    7. Sub-Queries
    8. Using the Set Operators
    9. Manipulating Data
    10. Creating and Managing Tables
    11. Creating Other Schema Objects
    12. Managing Objects with data Dictionary Views
    13. Controlling User Access
    14. Managing Schema Objects
    15. Manipulating Large Data Sets
    16. Generating Reports by Grouping Related Data
    17. Managing Data in Different Time Zones
    18. Retrieving Data Using Sub queries
    19. Hierarchical Retrieval
    20. Regular Expression Support

Oracle 10g: PL/SQL

    1. Introduction to PL/SQL
    2. Declare PL/SQL Identifiers
    3. Write Executable Statements
    4. Interaction with the Oracle Server
    5. Control Structures
    6. Composite Data Types
    7. Explicit Cursors
    8. Exception Handling
    9. Stored Procedures
    10. Stored Functions and Debugging Subprograms
    11. Packages
    12. Deploying Packages
    13. Implement Oracle-Supplied Packages in Application Development
    14. Dynamic SQL
    15. Design Considerations for PL/SQL Code
    16. Triggers
    17. Creating Compound, DDL, and Event Database Triggers
    18. PL/SQL Compiler
    19. Manage PL/SQL Code
    20. Manage Dependencies

Oracle 10g: Database Administrator Workshop I

    1. Install Oracle Database 10g and configure a database
    2. Manage the Oracle instance
    3. Manage the Database storage structures
    4. Create and administer user accounts
    5. Perform backup and recovery of a database
    6. Monitor, troubleshoot, and maintain a database
    7. Configure Oracle Net services
    8. Move data between databases and files

Oracle 10g: Database Administrator Workshop II

    1. Use RMAN to create and manage backup sets and image copies
    2. Recover the database to a previous point in time
    3. Use Oracle Secure Backup to backup and recover a database
    4. Use Oracle's Flashback technology to recover your database
    5. Detect block corruptions and take appropriate measures to correct them
    6. Use the various Database advisors and views to monitor and improve database performance
    7. Control database resource usage with the Resource Manager
    8. Simplify management tasks by using the Scheduler
    9. Review database log files for diagnostic purposes
    10. Customize language-dependent behavior for the database and individual sessions
    11. Customize language-dependent behavior for the database and individual sessions
    12. Customize language-dependent behavior for the database and individual sessions
    13. Administer a VLDB
    14. Implement a secure database
    15. Transport data across platforms