Oracle Certified Associate (OCA) Course

Certificate by GRRAS Linux Training And Development Center Jaipur, Nagpur, Pune, Ghaziabad, Sikar, Indore View Contact

Request Info

Learn: Oracle Developer OCA

Category: IT Certification

Medium of instruction:

English

Module I : Oracle Certified SQL Expert

1. Introduction

• Visualization of Oracle Environment

• What is Oracle?

• Architecture Description

• Working Flow

• Concept

• Objectives and Goal of course

• Relational Database Concept

• Entity Relationship Model

1. SQL : Structured Query Language( PART – I)

• What is SQL, SQL * Plus, iSQL *Plus?

• SQL Statements / Commands

• SELECT and Conditionals

• Single Row Functions

• Group Function / Aggregate Data

• Multiple Table Data Display / JOINS

• Subqueries

• SET Operator

• Manipulating Data

• DDL Statements Use

• Views

• Data Dictionary

1. SQL : Structured Query Language( PART – I)

• User Access Control

• Oracle Architectural Components

Module II : Oracle Database 10g - Administration I

1. Introduction

2. Oracle Database Software Installation

3. Database Creation

4. Managing Database Instance and Storage Structure

5. User Security Administration

6. Data and Concurrency Management

7. Database Security Implementation

8. Performance Management

9. Backup and Recovery

10. Flashback

Classroom - Regular
When	Duration	Where	Remarks	Price
Not Specified	Not Specified	All Venues	Not Specified	Price On Request

Classroom - Corporate Training
When	Duration	Where	Remarks	Price
Not Specified	Not Specified	All Venues	Not Specified	Price On Request

Jaipur, Tonk Road (Head Office):- 219, Himmat Nagar, Behind Kiran Sweets, Gopalpura Turn Tonk Road, Jaipur, Rajasthan, India


Jaipur, Gandhi Nagar (Branch):- E-788-789, Avadpuri, Gandhinagar Turn Gandhi Nagar, Jaipur, Rajasthan, India


Jaipur, Pratap Nagar (Branch):- 86/198 Kumbha Marg Pratap Nagar, Jaipur, Rajasthan, India


Nagpur, Ram Nagar (Branch):- 53 Gokulpeth, Suvrna Building Opposite Ram Nagar Bus Stand and Karnatka Sangh Building, Ram Nagar Square Ram Nagar, Nagpur - 440010, Maharashtra, India


Pune, Karve Road (Branch):- 18, Sarvadarshan, Nal-stop Opposite Sarswat-co-op Bank Karve Road, Pune - 411004, Maharashtra, India


Ghaziabad, Vasundhra (Branch):- Sector 12/508 1st Floor, Shiva complex Near dominos pizza Vasundhra, Ghaziabad - 201012, Uttar Pradesh, India


Sikar, Jaipur Road (Branch):- 340, Ward no. 28 Opposite Government ITI College Jaipur Road, Sikar, Rajasthan, India


Indore, Sudama Nagar (Branch):- 1184-B, Vidur Nagar, Hawa Bungalow CAT Road Sudama Nagar, Indore, Madhya Pradesh, India

GRRAS Linux Training And Development Center

GRRAS is a well known Linux training institute and authorized Linux training partner of Red Hat. We offer Red Hat certified RHCE, RHCVA and RHCSS courses, which are required to get expertise over Linux server. GRRAS Linux institute is conduct RHCE, RHCVA and RHCSS examinations also at its center in Jaipur, Nagpur and Hyderabad.

Our wide range of Linux training services includes-

• Linux Consultancy

• Linux Server Migration

• Server Management and Implementation

• Corporate training

• In-house training

• Certifications

• Red Hat certified Linux courses

• Cisco certified courses-CCNA, CCNP

• PHP, MySQL projects development and maintenance

With its advanced and comprehensive Linux courses and Linux training, GRRAS is raising the standard of Linux training. With its practical knowledge base approach, GRRAS makes professionals enable to meet industry demand for high quality enterprise-level skills.