Official link to exam: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-061

Retrieving data using SELECTS 1Z0-061_Selects

Restricting and Sorting 1Z0-061_Restrict_Sort

Single row functions 1Z0-061_SingleRowFunctions

conversion functions and conditional expressions1Z0-061_Conversion and Conditionals

reporting aggregate data1Z0-061_Aggregate

joins1Z0-061_Joins

subqueries1Z0-061_Subqueries

DML 1Z0-061_DML

DDL 1Z0-061_DDL