Introduction to Oracle Database
Basic of relational database
Different types of SQL statements
SQL SELECT Statement
List the capabilities of SQL SELECT statements
Select All Columns
Select Specific Columns
Arithmetic Operators and Operator Precedence
Restrict and Sort Data
Describe WHERE clause
Comparison operators and logical operators
Describe ORDER BY clause
Single-Row Functions
Differences between single row and multiple row functions
String manipulation functions
Describe ROUND, TRUNC, and MOD functions
Arithmetic with date
Manipulate dates with the DATE functions
Conversion Functions and Conditional Expressions
Describe TO_CHAR and TO_DATE functions
Handle NULL values
Use conditional IF THEN ELSE logic in a SELECT statement
Group Functions – Aggregate the data
Describe the use of the aggregation functions
Describe GROUP BY clause
Describe HAVING clause
Joins – Get data from multiple tables
Access data from more than one table
Type of joins – Self joins, Outer joins, equi joins
Sub-queries
Describe the types of problem that sub-queries can solve
Describe sub-queries
List the types of sub-queries
Explain single-row and multiple-row sub-queries
SET Operators in Oracle
Describe the SET operators
Control the ordering
Data Manipulation Statements
Describe different type of DML statement
Describe INSERT statement
Describe UPDATE statement
Describe DELETE statement
Describe COMMIT and ROLLBACK statements
Explain read consistency
DDL Statements - Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types
Add constraints to the table
Schema Objects in Oracle
Simple and Complex view
Retrieve data from views
Explain Sequences
Explain Indexes
Explain Synonyms
Control User Access
Type of privileges - system privileges and object privileges
Describe Users and Roles
Grant System Privileges
Grant Object Privileges
How to pass on privileges
Revoke Object Privileges
Schema Objects management
Add, Modify, and Drop a Column
Add, Drop, and Defer a Constraint
Enable and Disable a Constraint?
Flashback
Data Dictionary Views
Data dictionary - Overview
USER_OBJECTS and ALL_OBJECTS Views
Query the dictionary views for constraint information
