ORACLE
DESCRIPTION
Course Content
:::…Oracle…:::
Database Introduction
Data
Database
Database Management System
Types of Databases
ER-Model
Accessing the Database
Environments to access database
Toad
Sql Developer
Sql Navigator
Sql * Plus
SQL
Accessing the Databases using SQL
Data types
Database Objects :
Types of Database Objects in SQLTables
Views
Types of Views
Difference between Normal Views and Materialized Views
Sequences
Synonyms
Indexes
Clusters
Data Dictionary Tables or Meta Data Tables
Types of SQL Statements
DDL
D M L
DQL/DRL
DCL
TCL
Dual Table
SQL Operators
Arithmetic Operators
Comparison/Relational Operators
Logical Operators
SQL Special Operators
Functions
Single-Row Functions& Types
Multi-Row Functions& Types
Joins
Oracle Joins
ANSI Joins
Sub Queries
Types Of Sub Queries
Advanced Sub Queries
Set Operators
Pseudo Columns
Pseudo Columns
Types of Pseudo Columns
Rowid
Rownum
Nextval
Currval
Level
Top-N & Bottom-N Analysis
Hierarchal Queries
Constraints
Analytic Functions
Cube
Rollup
Grouping
Rank
Dense Rank
Over
And more
PL/SQL
Difference between SQL and PL/SQL
Advantages of using PL/SQL
Types of PL/SQL Programs
Displaying Outputs in PL/SQL
Variables
Usage of Variables
Scope of Variables
Types of Variables
Using DML Statements in PL/SQL program
Using DQL Statements in PL/SQL Program
Non-PL/SQL Variables
Conditional Statements
Iterative Statements
Composite Data Types
Records
Collections
Cursors
Types of Cursors
Cursor Attributes
Writing Cursors using Iterative Statements
Parameterized Cursor
Static Cursor
Dynamic/Ref Cursor
Pragma
Types of Pragmas
Pragma Exception_Init
Pragma Autonomous_Transaction
Pragma Serially_Reusable
Pragma Restrict Reference
Exceptions
Types of Exceptions
Using Exception_Init
Difference between dbms_output.put_line and raise_application_error in Exceptions
Procedures
Compilation and Execution of Procedures
Types of Parameters in Procedures
Calling one procedure from another procedure
Using Pragma Autonomous Transaction
Functions
Compilation and Execution of Functions
Types of Parameters in Functions
Difference between Procedures and Functions
Packages
Compilation and Execution of a Package
Private Sub Program
Triggers
Types of Triggers
Mutating Trigger
Advanced PL/SQL
Bulk Fetching
Dynamic SQL
And more