Oracle Database SQL Certified Associate (1Z0-071)

01

Module 1: Relational Database concepts

02

Module 2: Retrieving Data using the SQL SELECT Statement

03

Module 3: Restricting and Sorting Data

04

Module 4: Using Single-Row Functions to Customize Output

05

Module 5: Using Conversion Functions and Conditional Expressions

06

Module 6: Reporting Aggregated Data Using Group Functions

07

Module 7: Displaying Data from Multiple Tables

08

Module 8: Using Subqueries to Solve Queries

09

Module 9: Using SET Operators

10

Module 10: Managing Tables using DML statements

11

Module 11: Managing Indexes Synonyms and Sequences

12

Module 12: Use DDL to manage tables and their relationships

13

Module 13: Managing Views

14

Module 14: Controlling User Access

15

Module 15: Managing Objects with Data Dictionary Views

16

Module 16: Managing Data in Different Time Zones