Oracle Tutorial
Database Introduction
What is the Oracle database? How it functions? pre-requisites, oracle database, multiple non-CDB’s share nothing, oracle database installation, multi-tenant architecture, non-CDB oracle system data mixed with user data, multitenant container database, pluggable database.Oracle Arcitecture.
Oracle Tables syntax , Views, Queries, Clauses( Distinct, Form , Orderby , Group by Having) ,
Operators( Union , intersect,. minus), Oracle Joins
Oracle Advance
-Procedure, functions, Cursor, Trigger
Creating Access
Managing Users Access and Roles .
PL/SQL
Introduction
Data types
Complex Data Structure
Programming PL?SQL
Flow Control
Exception Handling
Packages
Triggers
PL/SQL Objects