Highlights the Oracle CASE statement which can be used to perform IF-THEN-ELSE logic in queries.

Demonstrates a hierarchy query using connect by and the sys connect by path.

Highlights the use of the PIVOT operator. This operator takes data in separate rows, aggregates it, and converts it into columns.

Regular expressions enable you to search for patterns in string data by using standardized syntax conventions.

This function lets you compare words that are spelled differently, but sound alike in English.

Examples of substr, instr, nvl, nvl2, coalesce, replace, and trim SQL functions.

The GROUP BY clause allows a developer to use SQL aggregate functions (AVG, COUNT, MAX, MIN, STDDEV, SUM and VARIANCE).

Inline views are commonly used to simplify complex queries by removing join operations.

Pipelined functions provide the ability to reference the data returned by a PL/SQL process as a table in a SQL statement.