Oracle PL/SQL course Intermediate Level by Revive Technologies

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. Oracle database is the first database designed for enterprise grid computing the most flexible and cost effective way to manage information and application. Oracle provides very good relational Database Management Oracle
Syllabus
SQL

• DDL
• DML
• DCL
• TCL
• Basic Commands
• Table Creation
• Dual Table
• Sorting And Restricting Data
• SQL,ISQL PLUS,SQLPLUS,TOAD
• Functions
• Analytic
• Group
• Single Row
• SQL Loader
• Synonyms
• Views
• Sub Query
• Joins
• Set Operators
• Pseudocolumns
• Sequence
• Constraints
• Control Statements
• Global Temporary Table
• Materialized View
• Index
• SQL plus Commands
• Performance Tuning

PLSQL

• PL/SQL Block
• Type
• Row Type
• Cursor
• Control Statements
• If
• Loop
• For Loop
• While
• Case
• Procedures
• Functions
• Triggers
• Packages
• Cursor
• Collections
• PL/SQL Table
• Varray
• Nested Block
• Exceptions
• Bulk Collect
• Pragma Autonomous