Think Career in IT
Think Steps......

IT Training from the masters

OCA (Oracle Certifide Associate)

Oracle Developer/Administrator Certified Associate program is a unique program combining the required courses to become an Oracle Certified Associate both as a Developer and as an Administrator. This program helps to certify professionals who want to demonstrate thempossess the knowledge and hands-on skills required to support Oracle's products. At this skill level, OCA has the foundation of knowledge that will allow him/her to act as a entry-level database administrator or application developer.Oracle is world's largest used Database. Oracle is the product of Oracle Corporation. Oracle is the market of database for many decades. It works on mostly all operating systems. Most of the world's top companies use Oracle . Oracle is used to store information about company's staff, salary, stocks, and all related information. Any of person going for computer field should have knowledge of database preferably Oracle.

OCA Certificate Examination
  • Oracle Database 11g: SQL Fundamentals I (1Z0-051)
  • OR
  • Oracle Database SQL Expert(1Z0-047)
  • Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g: SQL Fundamentals I (1Z0-051):
  • 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 Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Oracle Database SQL Expert(1Z0-047):
  • 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 and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • 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
Oracle Database 11g: Administration I (1Z0-052):
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Creating Other Schema Objects

Courses