CERTIFICATES

Explaining the theoretical and physical aspects of a relational database, Relating clauses in SQL Select Statement to Components of an ERD and 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 and 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 and 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 and 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 and nesting multiple functions

Restricting Group Results, creating Groups of Data, using Group Functions

Using Self-joins, Using Various Types of Joins, Using Non equijoins, using OUTER joins and understanding and Using Cartesian Products

Using Single Row Subqueries, using Multiple Row Subqueries and update and delete rows using correlated subqueries

Matching the SELECT statements, using the ORDER BY clause in set operations, using The INTERSECT operator, using The MINUS operator and using The UNION and UNION ALL operators

Managing Database Transactions, Controlling transactions, perform Insert, Update and Delete operations, performing multi-table Inserts and performing Merge statements

Describing and Working with Tables, Describing and Working with Columns and Data Types, Creating tables, Dropping columns and setting column UNUSED, Truncating tables, Creating and using Temporary Tables, Creating and using external tables and Managing Constraints

This module describes working with views and the necessary operations like creating views, option check point, inserting rows in a view, upating rows in a view, and deleting a view.

Differentiating system privileges from object privileges , Granting privileges on tables and Distinguishing between granting privileges and roles

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP, Working with INTERVAL data types