Oracle SQL Course Outline


Introduction to Oracle Database



Retrieve Data using the SQL SELECT Statement



Learn to Restrict and Sort Data



Usage of Single-Row Functions to Customize Output



Invoke Conversion Functions and Conditional Expressions



Aggregate Data Using the Group Functions



Display Data from Multiple Tables Using Joins



Use Sub-queries to Solve Queries



The SET Operators



Data Manipulation Statements



Use of DDL Statements to Create and Manage Tables



Other Schema Objects



Control User Access



Management of Schema Object



ORACLE_DATAPUMP



Manage Objects with Data Dictionary



Manipulate Large Data Sets



Data Management in Different Time Zones



Retrieve Data Using Sub-queries



Regular Expression Support