Oracle PL/SQL

Oracle PL/SQL

Course Contents

  • Introduction to PL/SQL 
  • Declaring PL/SQL Identifiers 
  • Writing Executable Statements 
  • Interacting with the Oracle Server 
  • Writing Control Structures 
  • Working with Composite Data Types 
  • Using Explicit Cursors 
  • Handling Exceptions 
  • Creating Stored Procedures 
  • Creating Stored Functions 
  • Creating Packages 
  • Using More Package Concepts 
  • Utilizing Oracle Supplied Packages in Application Development 
  • Dynamic SQL and Metadata 
  • Design Considerations for PL/SQL Code 
  • Managing Dependencies 
  • Manipulating Large Objects 
  • Creating Triggers 
  • Applications for Triggers 
  • Understanding and Influencing the PL/SQL Compiler 

 

Features: 
Learner Centered Approach 
Individual Training 
Practice in real Business Applications 
Creativity Building Training 
Certificate approved by Ministry of Education