Oracle Database SQL Certified Associate

Exam number 1Z0-071. The exam syllabus we prepare students against once they're comfortable with the fundamentals.

The Oracle Database SQL Certified Associate exam demonstrates depth of knowledge in SQL and its use when working with an Oracle database — querying, inserting, updating and deleting data, plus Data Definition Language (DDL), Data Control Language (DCL), the optimizer, tables, indexes, data modeling and normalization.

Exam format: multiple choice
Duration: 120 minutes
Questions: 78
Passing score: 63%

Exam syllabus

Module 01

Relational database concepts

Theoretical and physical aspects of a relational database
Relating SELECT-statement clauses to components of an ERD
The relationship between a database and SQL

Module 02

Retrieving, restricting and sorting data

Writing basic SELECT statements
Restricting rows with WHERE
Sorting results with ORDER BY
Using substitution variables

Module 03

Single-row and conversion functions

Character, number and date functions
Conversion functions
Conditional expressions (CASE, DECODE)

Module 04

Group functions and reporting

Aggregating data with group functions
GROUP BY and HAVING
Common reporting patterns

Module 05

Joins and subqueries

Displaying data from multiple tables using joins
Using subqueries to solve multi-step problems
Set operators (UNION, INTERSECT, MINUS)

Module 06

Data manipulation (DML)

INSERT, UPDATE, DELETE and MERGE statements
Managing transactions with COMMIT and ROLLBACK

Module 07

Data definition (DDL) & schema objects

Creating and altering tables
Creating sequences, synonyms and indexes
Creating and using views
Data dictionary views

Module 08

Controlling access & working with time zones

Controlling user access with privileges and roles
Managing data across different time zones

New to SQL?

This certification track builds on our Python and Java courses, where SQL fundamentals are introduced alongside real datasets. Come talk to us about where to start.