ORACLE CERTIFICATIONS

SQL is most basic skill all of IT Company need if you have certification it will add value to your resume.

To get Associate level certification need to pass 2 exams. Exam will be conducted online. You need to go to authorised exam centre to take
exam.

All exams conducted by pearsonvue: http://www.pearsonvue.com/oracle/

Once exam finish you will get result within 1-2 days maximum with digital certificate.

Step 1 :( Any one exam out of 3)-Click the link to get more info.

Oracle Database 12c SQL 1Z0-071 or

EXAM TOPICS

Oracle and Structured Query Language (SQL)

Identify the connection between an ERD and a Relational Database
Explain the relationship between a database and SQL
Describe the purpose of DDL
Describe the purpose of DML
Build a SELECT statement to retrieve data from an Oracle Database table
Restricting and Sorting Data
Use the ORDER BY clause to sort SQL query results
Limit the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Use SQL row limiting clause
Using Single-Row Functions to Customize Output
Use various types of functions available in SQL
Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT
statements
Using Conversion Functions and Conditional Expressions
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply general functions and conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
Describe the different types of joins and their features
Use SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems subqueries can solve
Describe the types of subqueries
Query data using correlated subqueries
Update and delete rows using correlated subqueries
Use the EXISTS and NOT EXISTS operators
Use the WITH clause
Use single-row and multiple-row subqueries
Using the Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Manipulating Data
Truncate data
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Using DDL Statements to Create and Manage Tables
Describe data types that are available for columns
Create a simple table
Create constraints for tables
Drop columns and set column UNUSED
Create and use external tables
Managing Objects with Data Dictionary Views
Query various data dictionary views
Controlling User Access

Source: http://education.oracle.com
 ORACLE CERTIFICATIONS
Differentiate system privileges from object privileges
Grant privileges on tables and on a user
Distinguish between privileges and roles
Managing Schema Objects
Describe how schema objects work
Create simple and complex views with visible/invisible columns
Create, maintain and use sequences
Create and maintain indexes including invisible indexes and multiple indexes on the same columns
Perform flashback operations
Manipulating Large Data Sets
Describe the features of multitable INSERT
Merge rows in a table

Oracle Database 12c: SQL Fundamentals 1Z0-061 or

EXAM TOPICS
Introduction
Describe the features of Oracle Database 12c
Describe the salient features of Oracle Cloud 12c
Explain the theoretical and physical aspects of a relational database
Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
Retrieving Data using the SQL SELECT Statement
Explain the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Restricting and Sorting Data
Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data From Multiple Tables Using Joins
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using OUTER joins
Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems that the subqueries can solve
Describe the types of subqueries
Write single-row and multiple-row subqueries
Using the SET Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Managing Tables using DML statements
Truncate data
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Introduction to Data Definition Language
Categorize the main database objects
Explain the table structure
Describe the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work

Oracle Database 11g: SQL Fundamentals I 1Z0-051(Recommended –Easier)

EXAM TOPICS

Source: http://education.oracle.com
 ORACLE CERTIFICATIONS
Retrieving Data Using the SQL SELECT Statement
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Restricting and Sorting Data
Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries
Using the Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Manipulating Data
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Using DDL Statements to Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work
Creating Other Schema Objects
Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Exam Details

Duration: 100 minutes

Number of Questions: 73

Passing Score: 63%

Format: Multiple Choices

Exam Price: Rs 9701

Source: http://education.oracle.com
 ORACLE CERTIFICATIONS

Easiest way to pass exam go through the video tutorials in below links and study materials.

1Z0-071: http://www.oraclecertificationprep.com/apex/f?p=OCPSG%3AEXAM_DETAILS%3A%3A%3ANO%3A%3AP2_EXAM%3A1Z0-071

1Z0-061: http://www.oraclecertificationprep.com/apex/f?p=OCPSG%3AEXAM_DETAILS%3A%3A%3ANO%3A%3AP2_EXAM%3A1Z0-061

1Z0-051: http://www.oraclecertificationprep.com/apex/f?p=OCPSG%3AEXAM_DETAILS%3A%3A%3ANO%3A%3AP2_EXAM%3A1Z0-051

Step 2: Click the link to get more info.

Oracle Database 11g: Administration I 1Z0-052

EXAM TOPICS

Exploring the Oracle Database Architecture

Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures
Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Managing Database Storage Structures
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces
Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Managing Data and Concurrency
Monitor and resolve locking conflicts
Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo
Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing
Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds
Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
Use the Enterprise Manager Support Workbench

Source: http://education.oracle.com
 ORACLE CERTIFICATIONS
Managing Patches
Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode
Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

Easiest way to pass exam go through the video tutorials in below links and study materials.

1Z0-052:http://www.oraclecertificationprep.com/apex/f?p=OCPSG%3AEXAM_DETAILS%3A%3A%3ANO%3A%3AP2_EXAM%3A1Z0-052

Exam Details

Duration: 90 minutes

Number of Questions: 70

Passing Score: 66%

Format: Multiple Choices

Exam Price: Rs 9701

Once you finish both steps you will get certificate as bellow (softcopy to your registered mail). Your hard copy will be send
through post to the address you mentioned in pearsonvue.

Source: http://education.oracle.com
 ORACLE CERTIFICATIONS
Eagle view of oracle certification path

Source: http://education.oracle.com