• ▪ Overview of Oracle Database
  ▪ Overview of relational database management concepts and terminologies
  ▪ Introduction to SQL and its development environments
  ▪ Schema and the tables used in this course
  ▪ Oracle Database documentation and additional resources

• ▪ List the capabilities of SQL SELECT statements
  ▪ Generate a report of data from the output of a basic SELECT statement
  ▪ Use arithmetic expressions and NULL values in the SELECT statement
  ▪ Invoke Column aliases
  ▪ Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  ▪ Display the table structure using the DESCRIBE command

• ▪ Write queries with a WHERE clause to limit the output retrieved
  ▪ Describe the comparison operators and logical operators
  ▪ Describe the rules of precedence for comparison and logical operators
  ▪ Usage of character string literals in the WHERE clause
  ▪ Write queries with an ORDER BY clause
  ▪ Sort the output in descending and ascending order
  ▪ Substitution Variables

• ▪ List the differences between single row and multiple row functions
  ▪ Manipulate strings using character functions
  ▪ Manipulate numbers with the ROUND, TRUNC, and MOD functions
  ▪ Perform arithmetic with date data
  ▪ Manipulate dates with the DATE functions

• ▪ Describe implicit and explicit data type conversion
  ▪ Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  ▪ Nesting multiple functions
  ▪ Apply the NVL, NULLIF, and COALESCE functions to data
  ▪ Usage of conditional IF THEN ELSE logic in a SELECT statement

• ▪ Usage of the aggregation functions in SELECT statements to produce meaningful reports
  ▪ Describe the AVG, SUM, MIN, and MAX function
  ▪ How to handle Null Values in a group function?
  ▪ Divide the data in groups by using the GROUP BY clause
  ▪ Exclude groups of date by using the HAVING clause

• ▪ Write SELECT statements to access data from more than one table
  ▪ Join Tables Using SQL:1999 Syntax
  ▪ View data that does not meet a join condition by using outer joins
  ▪ Join a table to itself by using a self join
  ▪ Create Cross Joins

• ▪ Use a Subquery to Solve a Problem
  ▪ Single-Row Subqueries
  ▪ Group Functions in a Subquery
  ▪ Multiple-Row Subqueries
  ▪ Use the ANY and ALL Operator in Multiple-Row Subqueries
  ▪ Use the EXISTS Operator

• ▪ Describe the SET operators
  ▪ Use a SET operator to combine multiple queries into a single query
  ▪ Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
  ▪ Use the ORDER BY Clause in Set Operations

• ▪ Add New Rows to a Table
  ▪ Change the Data in a Table
  ▪ Use the DELETE and TRUNCATE Statements
  ▪ How to save and discard changes with the COMMIT and ROLLBACK statements
  ▪ Implement Read Consistency
  ▪ Describe the FOR UPDATE Clause

• ▪ Categorize Database Objects
  ▪ Create Tables
  ▪ Describe the data types
  ▪ Understand Constraints
  ▪ Create a table using a subquery
  ▪ How to alter a table?
  ▪ How to drop a table?

• ▪ Create, modify, and retrieve data from a view
  ▪ Perform Data manipulation language (DML) operations on a view
  ▪ How to drop a view?
  ▪ Create, use, and modify a sequence
  ▪ Create and drop indexes
  ▪ Create and drop synonyms

▪ Explain Plan
▪ Query optimization
▪ TKProf