SQL/PLSQL Training institute in Marathahalli

• Introduction to PL/SQL
  • Benefits of PL/SQL
  • Creating PL/SQL Blocks

• Using Variables in PL/SQL
  • Recognizing PL/SQL Lexical Units
  • Recognizing Data Types
  • Using Scalar Data Types
  • Writing PL/SQL Executable Statements
  • Nested Blocks and Variable Scope
  • Good Programming Practices

• • Review of SQL DML
  • Retrieving Data in PL/SQL
  • Manipulating Data in PL/SQL
  • Using Transaction Control Statements

• User-Defined Records
  • Indexing Tables of Records

• Creating Procedures
  • Using Parameters in Procedures
  • Passing Parameters

Creating Functions
• Using Functions in SQL Statements
• Review of the Data Dictionary
• Managing Procedures and Functions
• Review of Object Privileges

Using Invoker’s Rights and Autonomous Transactions

• Creating Packages
  • Managing Package Concepts
  • Advanced Package Concepts

 Persistent State of Package Variables
• Using Oracle-Supplied Packages

Using Dynamic SQL
• Improving PL/SQL Performance

Introduction To Triggers
• Creating DML Triggers, Part I
• Creating DML Triggers, Part II

• Creating DDL and Database Event Triggers
• Managing Triggers

• Introduction to Dependencies
  • Understanding Remote Dependencies

• Using PL/SQL Initialization Parameters
• Displaying Compiler Warning Messages
• Using Conditional Compilation
• Hiding Your Source Code

• What are Compound Triggers?
• Identify the Timing-Point Sections of a Table Compound Trigger
• Compound Trigger Structure for Tables and Views
• Implement a Compound Trigger to Resolve the Mutating Table Error
• Compare Database Triggers to Stored Procedures
• Create Triggers on DDL Statements
• Create Database-Event and System-Event Triggers
• System Privileges Required to Manage Triggers