Course Outline

Introduction to PL/SQL

  • What is PL/SQL?
  • Advantages of using PL/SQL

Basic Structure of a PL/SQL Block

  • Anonymous blocks
  • Named blocks

Variables and Data Types

  • Declaration of variables
  • Syntax and rules
  • Data types in PL/SQL
  • Using variables in PL/SQL blocks

Control Structures

  • IF-THEN-ELSE
  • CASE statements
  • FOR loops
  • WHILE loops

Stored Procedures and Functions

  • Creating and running stored procedures
  • Syntax and examples
  • Input and output parameters
  • Creating and executing functions in PL/SQL
  • Syntax and examples
  • Usage in SQL statements

Cursors

  • Explicit cursors
  • Implicit cursors
  • Fetching data
  • Cursor attributes

Exception Handling

  • Predefined exceptions
  • User-defined exceptions
  • Using TRY-CATCH blocks

Transaction Control

  • Transaction control in PL/SQL
  • Using nested blocks and transactions
  • Managing nested transactions
  • Creating and using savepoints

Advanced Cursor Techniques

  • Strong vs. weak REF CURSOR
  • Usage scenarios

Triggers

  • Creating triggers
  • Types of triggers
  • Using triggers for auditing

Packages in PL/SQL

  • Creation
  • Specification
  • Implementation
  • Execution
  • Invocation
  • Real-world application
  • Code walkthrough

Summary and Next Steps

Requirements

  • Basic understanding of SQL
  • Understanding of database schemas, tables, and relationships

Audience

  • Database administrators
  • Database developers
  • Software developers
  • Data analysts
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories