Oracle Database SQL Certified Associate Certification 

Explaining the theoretical and physical aspects of a relational database

Relating clauses in SQL Select Statement to Components of an ERD

Explaining the relationship between a database and SQL

Using Column aliases

Using The SQL SELECT statement

Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Using Arithmetic expressions and NULL values in the SELECT statement

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands

Sorting Data

Manipulating strings with character functions in SQL SELECT and WHERE clauses

Performing arithmetic with date data

Manipulating numbers with the ROUND, TRUNC and MOD functions

Manipulating dates with the date function

Applying the NVL, NULLIF, and COALESCE functions to data

Understanding implicit and explicit data type conversion

Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nesting multiple functions

Restricting Group Results

Creating Groups of Data

Using Group Functions