Oracle Certified Associate (OCP) Syllabus

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