Oracle Certified Associate (OCP) Syllabus
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
