Oracle is world's largest used Database. Oracle is the market of database for many decades. It works on mostly all operating systems. Most of the world's top companies use Oracle . Oracle is used to store information about company's staff, salary, stocks, and all related information.

Course Content:

Structured Query Language:

• Writing Basic SQL Select Statements,
• Restricting and Sorting SQI Data,
• Single-Row Functions,
• Joins (Displaying Data from Multiple Tables),
• Aggregating data using Group Functions,
• Subqueries,
• Manipulating Data,
• Creating and Managing Tables,
• Including Constraints,
• Creating Views,
• Sequences,
• Indexes
• Synonyms

Advanced SQL:

• Controlling User Access,
• Using SET operators,
• DateTime Functions,
• Enhancements to Group by clause(cube, Rollup and Grouping),
• Advanced Subqueries (Multiple column subqueries,
• Subqueries in FROM clause, Scalar and correlated subqueries),
• WITH Clause,
• Hierarchical retrieval,

PLSQL:

• Introduction,
• Overview and
• benefits of PLSQL,
• Subprograms,
• types of PLSQL blocks,
• Simple Anonymous Block,
• Identifiers,
• types of Identifiers,
• Declarative Section,
• variables,
• Scalar Data Types,
• The %TYPE Attribute,
• Bind Variables,
• Sequences in PLSQL Expressions,
• Executable Statements,
• PLSQL Block Syntax,
• Comment the Code,
• Convert Data Types,
• Nested Blocks,
• Invoke SELECT Statements in PLSQL,
• SQL Cursor concept,
• Data Manipulation in the Server using PLSQL,

Control Structures:

• Conditional processing using IF Statements
• CASE Statements,
• Loop Statement,
• While Loop Statement,
• For Loop Statement,
• the Continue Statement,

Composite Data Types:

• PLSQL Records,
• The %ROWTYPE Attribute,
• Insert and Update with PUSQL Records,
• INDEX BY Tables,
• INDEX BY Table Methods,
• Use INDEX BY Table of Records,
• Explicit Cursors,
• Declare the Cursor,
• Open the Cursor,
• Fetch data from the cursor.
• Close the Cursor,
• Cursor FOR loop,
• The %NOTFOUND and %ROWCOUNT Attributes,
• the FOR UPDATE Clause and WHERE CURRENT Clause,

Exception Handling,

• Handle Exceptions with PUSQL,
• Trap Predefined and non-predefined Oracle Server Errors,
• User-Defined Exceptions,
• Propagate Exceptions,
• RAISE_APPLICATION_ERROR Procedure,

Stored Procedures:

• Create a Modularized and Layered Subprogram Design,
• the PLSQL Execution Environment,
• differences between Anonymous Blocks and Subprograms,
• Create, Call, and Remove Stored Procedures,
• Implement Procedures Parameters and Parameters Modes,
• View Procedure Information,
• Stored Functions,
• Create, Call, and Remove a Stored Function,
• advantages of using Stored Functions,
• the steps to create a stored function,
• Invoke ·User-Defined Functions in SQL Statements,
• Restrictions when calling Functions,
• Control side effects when calling Functions,
• View Functions Information,
• Packages,
• advantages of Packages,
• components of a Package,
• Develop a Package,
• enable visibility of a Package's Components,
• Create the Package Specification and Body
• Overloading Subprograms in PLSQL,

Triggers:

• Implementing Triggers,
• Create DML Triggers using the CREATE TRIGGER Statement
• Identify the Trigger Event Types, Body, and Firing (Timing),
• Statement Level Triggers and RowLevel Triggers,
• Create Instead of and Disabled Triggers,
• Manage, Test and Remove Triggers.
• Creating Compound, DDL and Event Database Triggers,
• Compound Trigger Structure for Tables and Views
• , Comparison. of Database Triggers and Stored Procedures,
• Create Triggers on DDL Statements,
• Create Database-Event and System-Events Triggers,
• System Privileges Required to Manage Triggers