098 70 803004 / 5
              
 Blog

Enquiry Form

OCA CERTIFICATION

OCA Certification - Oracle Certified Associate

Net Tech India offers the right technology to the right people who they think are capable. For Oracle Certified Associate Exams there are a number of leading experts and trainers who provide support and training to the students. This team of expertise is a highly qualified team and is extremely trustable.

Course Details:


The OCA Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Oracle Database certification teaches you how to perform complex, hands-on activities through labs, study and practice.

Back to top

Contents of the Course are as follows:


SQL(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

PL/SQL(1Z0-147)

• Overview of PL/SQL Programs

• Creating Procedures

• Creating Functions

• Managing Subprograms

• Creating Packages

• More Package Concepts

• Oracle Supplied Packages

• Manipulating Large Objects

• Creating Database Triggers

• More Trigger Concepts

• Managing Dependencies

Back to top

Available delivery methods for this course:

Classroom

In-house

Online

Virtual

Enquiry Form

Name

Email

Phone Number

Comments