Oracle PL/SQL

Course Content

Introduction to DBMS

  • Overview of DBMS
  • DBMS Architecture
  • DBMS - Data Models.
  • Database Schema

Introduction to PL/SQL

  • An introduction to PL/SQL
  • Overview Of PL/SQL
  • Features/Advantage of PL/SQL in DBMS
  • Installing/Environment Setup of PL/SQL
  • PL/SQL basic Syntax
  • PL/SQL Constant
  • PL/SQL Variables

Conditional Statement

  • IF-THEN Statement
  • IF-THEN-ELSE Statement
  • Nested IF-ELSE Statement
  • Case Statement

Control Statements

  • Basic Concepts
  • PL/SQL If Statement
  • PL/SQL Case Statement
  • PL/SQL Loop
  • For Loop
  • While Loop
  • Simple Loop
  • Labeled Loop
  • PL/SQL Continue
  • PL/SQL Exit Loop
  • PL/SQL Continue

PL/SQL Procedure

  • PL/SQL Procedure

PL/SQL Function

  • PL/SQL Function

PL/SQL Cursor

  • Implicit Cursors
  • Explicit Cursors

PL/SQL Exception

  • System-defined Exceptions
  • User-defined Exceptions
  • Raising Exceptions

PL/SQL Trigger

  • Basic Syntax
  • Advantage of PL/SQL Trigger
  • Creating Trigger
  • Triggering a Trigger

Interview question and scenario