PL/SQL

PL/SQL

  • Course Title PL/SQL
  • Course IDTD503
  • Target AudienceEntry-level to Managerial level associates
  • Course Duration10 Hrs (2 Hrs / Day)
  • Delivery MethodInstructor-led training
  • PrerequisitesNone

Course Overview

PL/SQL is an embedded procedural language in an Oracle Database. It is used to write the entire program blocks/ procedure/ function/packages/triggers etc. Associates undergoing this course will learn PL/SQL from the very beginning, step-by-step from the very fundamentals, all the way to building modern and complex applications.

Faculty Details

Course Instructors

Dharani Prakash Sudhakar

Name

Dharani Prakash Sudhakar

Email ID : dharani.sudhakar@intellectdesign.com

Learning Objectives

Learning Objectives

Associates undergoing this course will:

  • Learn PL/SQL from the very beginning
  • Understand step-by-step from the very fundamentals
  • Be able to build modern and complex oracle database applications

Course Coverage

1. Fundamentals of the PL/SQL Language

(Duration: 20 minutes)

2. PL/SQL Data types

(Duration: 20 minutes)

3. Executable Statements block

(Duration: 30 minutes)

4. Control Structures

(Duration: 50 minutes)

5. Implicit & Explicit Cursors

(Duration: 70 minutes)

6. Exception Handling

(Duration: 50 minutes)

7. Working with Procedures

(Duration: 50 minutes)

8. PRAGMA directives in Oracle PL/SQL

(Duration: 20 minutes)

9. Working with Functions

(Duration: 50 minutes)

10. Working with Implicit & Customized Packages

(Duration: 120 minutes)

11. Declaring local vs global Variables

(Duration: 20 minutes)

12. Working with Triggers

(Duration: 100 minutes)

Faculties

About the Faculty

Enroll