Oracle Training


  • The rigorous process of becoming Oracle certified makes you a better technologist. The knowledge you gain through training and practice will significantly expand your skill set and increase your credibility when interviewing for jobs. Earn a well-respected credential to demonstrate IT expertise in the marketplace.

  • Preparing for certification exams broadens your knowledge base. Gain exposure to a wide variety of important features, functions & tasks to use on the job. Learn to perform complex, hands-on activities through lab, study & practice sessions. Gain a competitive advantage by developing a skill set that's in demand, worldwide. Join the 80% of Oracle certification holders who reported a promotion, salary increase or other career improvements.

  • Oracle Certified Associate The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products. An OCA credential is available for several of today's most in-demand technology job roles.
  • Database Administrators
  • Systems Administrator
  • IT Managers
  • Anyone seeking Oracle Certified Associate Certification
  • You will receive presentation slides, questions and suggested solutions.
  • Oracle Database 11g SQL Fundamentals I

    • Introduction
    • Retrieving Data Using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables
    • Using Sub queries to Solve Queries
    • Using the Set Operators
    • Manipulating Data
    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects

    Oracle Database 11g SQL Fundamentals II

    • Introduction
    • Controlling User Access
    • Managing Schema Objects
    • Managing Objects with Data Dictionary Views
    • Manipulating Large Data Sets
    • Managing Data in Different Time Zones
    • Retrieving Data Using Sub queries
    • Regular Expression Support

    Oracle Database 11g Database Administration 1I

    • Introduction
    • Installation
    • Database Creation
    • Instance
    • Network
    • Storage
    • Users
    • Schema
    • Data and Concurrency
    • Undo
    • Security
    • Proactive Maintenance
    • Performance
    • Backup and Recovery Concept
    • Backup
    • Recovery
    • Moving Data
    • Enhancing Database

    Oracle Database is the world’s #1 enterprise database—enabling customers to transform their enterprises and improve operational agility and effectiveness. Oracle Database is cloud-ready, with multitenancy and pluggable databases that make it easy to offer database as a service. Oracle Database helps improve the quality and performance of applications, saves time with maximum availability architecture and storage management, and simplifies consolidation by managing hundreds of databases as one.