Oracle OCA Online Expert level by Gloedge Technologies Pvt Ltd

Introduction
Describing the Life Cycle Development Phases
Defining a Database
Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database
Describing How a Relational Database Management System (RDBMS) Is Used to Manage a
Describing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)
Describing How SQL Is Used in the Oracle Product Set

Writing a Basic SQL Statement
Describing the SQL Select Capabilities
Executing a Basic Select Statement with the Mandatory Clauses
Differentiating Between SQL and iSQL*Plus Commands

Restricting and Sorting Data
Limiting the Rows Retrieved by a Query
Sorting the Rows Retrieved by a Query

Single Row Functions
Describing Various Types of Functions Available in SQL
Using a Variety of Character, Number, and Date Functions in SELECT Statements
Explaining What the Conversion Functions Are and How They Are Used
Using Control Statements

Displaying Data from Multiple Tables
Writing SELECT Statements to Access Data from More Than One Table
Describing the Cartesian Product

Describing and Using the Different Types of Joins
Writing Joins Using the Tips Provided
Aggregating Data by Using Group Functions
Identifying the Different Group Functions Available & Explaining the Use of Group Functions
Grouping Data by Using the GROUP BY Clause
Including or Excluding Grouped Rows by Using the HAVING Clause

Writing Sub queries
Describing the Types of Problems That Subqueries Can Solve
Describing Subqueries
Listing the Types of Subqueries
Writing Single-Row and Multi-Row Subqueries
Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

Producing Readable Output with iSQL*Plus
Producing Queries That Require an Input Variable
Customizing the iSQL*Plus Environment
Producing More Readable Output
Creating and Executing Script Files

Manipulating Data
Describing Each Data Manipulation Language (DML) Command
Inserting Rows into a Table
Updating Rows in a Table
Deleting Rows from a Table
Merging Rows into a Table
Controlling Transactions
Describing Transaction Processing
Describing Read Consistency and Implicit and Explicit Locking

Creating and Managing Tables
Describing the Main Database Objects
Creating Tables
Describing the Oracle Data Types
Altering Table Definitions
Dropping, Renaming, and Truncating Tables

Including Constraints
Describing Constraints
Creating and Maintaining Constraints
Creating Views
Creating a View
Retrieving Data by Means of a View
Inserting, Updating, and Deleting Data Through Views
Dropping Views
Altering the Definition of a View
Inline Views
Top N Analysis

Other Database Objects
Creating, Maintaining, and Using Sequences
Creating and Maintaining Indexes
Creating Private and Public Synonyms
Controlling User Access
Understanding the Concepts of Users, Roles, and Privileges
Granting and Revoking Object Privileges
Creating Roles and Granting Privileges to Roles
Creating Synonyms for Ease of Table Access .

Date Time functions
Time Zones
Oracle Date Time Support
TZ_OFFSET
Local Timestamp
CURRENT_DATE

Enhancements to the Group By Clause
Cube
Rollup

Advanced Sub queries
Pairwise and non Pairwise comparision subquery
Correlated update
Correlated Delete