Database and relational database concepts
• Introduction to Entity Relationship Diagrams
• Defining a Relational Database         
• What is Structured Query Language (SQL)?
• How information is stored in an Oracle Database (fields, rows, columns)
• Concept of ‘Schema’ in Oracle Database

• Capabilities of SELECT Statement
• Basic SELECT statements
• SELECT all columns
• Column Aliases
• Retrieving Distinct Values
• Introduction to SQL Operators

• WHERE clause
• Comparison operators and logical operators
• Rules of precedence for comparison and logical operators
• Character string literals
• Date queries
• ORDER BY clause
• SQL Row Limiting Clause
• Substitution Variables

• Single row and multiple row functions
• Using functions in the SELECT and WHERE clauses
• Manipulate strings with character functions
• Manipulate numbers with the numeric functions
• Manipulate dates with the date functions

• Describe implicit and explicit data type conversion
• Conversion functions
• Nesting functions
• DECODE, NVL, NULLIF, and COALESCE functions
• Using CASE expressions

• Overview of joins
• Inner Joins
• Natural Joins
• USING clause
• ON clause
• Outer Joins
• Non-equi Joins
• Cross Joins
• Join a table to itself by using a self-join
• Joining multiple tables

• Aggregation functions
• Other Group Functions
• GROUP BY clause
• HAVING clause

• Overview of sub-queries
• Define sub-queries
• Common types of sub-queries
• Single-row sub-queries
• Multiple-row sub-queries
• Multiple-column sub-queries
• In-line Views
• Correlated Sub-queries
• Use the EXISTS and NOT EXISTS operators
• Scalar sub queries
• WITH clause

• Describe the SET operators – UNION, UNION ALL, INTERSECT, MINUS
• Use a SET operator to combine multiple queries into a single query
• Control the order of rows returned

• What are Analytic Functions?
• General Syntax of the Analytic Clause
• ORDER BY Clause
• Combining the PARTITION BY and ORDER BY Example
• Examples of Analytical Functions

• Describe each DML statement
• Insert a single row into a table
• Insert a single row with NULLs into a table
• Insert a single row using a script file
• Inserting multiple rows
• Change rows in a table by using the UPDATE statement
• Change rows in a table by using a sub-query
• Removing rows from a table
• Removing rows from a table using a sub-query
• Transaction Control – COMMIT, ROLLBACK, SAVEPOINT

• Describe the features of multi-table INSERTs
• Unconditional INSERTs
• Pivoting INSERTs
• Conditional ALL INSERTs
• Conditional FIRST INSERTs
• Using the MERGE statement
• Using the MERGE extensions
• Track the changes to data over a period of time

• Overview of DDL Statements and Schemas
• Overview of Oracle Tables
• Understanding Constraints
• NOT NULL Constraint
• UNIQUE Constraint
• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• CHECK Constraint
• A complete example of Constraints

• Create External Tables
• Create Temporary Tables
• ALTER table
• TRUNCATE table
• DROP table
• FLASHBACK Table
• Invisible columns
• Virtual Columns
• Identity Columns

• Creating and using Views and materialized views
• Creating and using Sequences
• Creating and using Synonyms
• Introduction to Indexes and their use
• Writing efficient code

• What type of object metadata is stored?
• Find table information
• Report on column information

• Creating Users
• Distinguish between system and object privileges
• Grant system privileges
• Grant object privileges on tables
• Grant privileges on tables
• Revoking Privileges
• View privileges in the data dictionary
• Distinguish between Privileges and Roles
• Using ROLEs