If you want to excel in IT, career then you needs to get yourself certified so that you can get better job options. Most of the IT companies look for individuals with OCA, OCP and OCM certifications. It not only gets you good job but also enhances your credibility, improves productivity and is good for professional development.

OCA or Oracle Certified Associate is a first step towards an Oracle professional career. Many people opt for this examination both for developer and DBA requirements. It begins with an Associate level. All the initially required skills for Oracle are covered under Oracle Certified Associate course. You need to undergo two examination evaluations to be OCA 9i certified, that is,

  • 1Z0-047 and
  • 1Z0-052.

 

SQL Certified Expert

  • 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 10g or 11g admin I

  • Introduction (Database Architecture)
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data

 

SQL Certified Expert - 40 Hours

Oracle 10g or 11g admin I - 40 Hours

Any Degeree Students

QUICK ENQUIRY

 

  •   91-95007 10004
  •  helpdesk@kalvigroup.com

 

  •  91-95432 18687
  •  helpdesk@kalvigroup.com