Oracle PL/SQL Course

Course Mentor: ESI

Course Overview

PL/SQL refers to Procedural Language extension to Structured Query Language (SQL),The main objective of PL/SQL is to join database language and procedural programming language, Oracle developed it to boost the capabilities of SQL, It allows you to store compiled code straight into the database,  PLSQL also lets you to define triggers, which are subprograms that the database implements automatically in reply to specified events ,PLSQL automatically obtains the power, portability and security of the Oracle database.

Target Audience

  • Any graduate who has computer background
  • Database Administrators
  • IT Professionals
  • SQL Developers
  • Database Administrators
  • Analytics Experts
  • Software Developers
  • SQL and Analytics Professionals
  • BI and Data Warehousing Professionals
  • Those inclined towards a career in Oracle PL/SQL

Course Objectives

Oracle PL/SQL  Course  is targeted for the  candidates who want to learn PL/SQL.

The main objective is to teach about executing, developing and controlling PL/SQL stored program units.so  Participants can enhance their abilities by gaining in-depth knowledge of PL/SQL stored program units including functions, database triggers, procedures, and packages. The trainees can learn to form PL/SQL blocks of application code that be shared by various forms, reports and data management applications.

Course Content

  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Design Considerations for PL/SQL Code
  • Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • PL/SQL Compiler
  • Manage Dependencies

Prerequisites

Candidates should possess fundamental knowledge of Oracle SQL and RDBMS Concepts.