PL SQL TRAINING
ENROLL NOW

Suggested Audience

PL/SQL developers, DW ETL developers, DBAs and production DBAs.

1. PL/SQL Overview

  • Definition
  • Object-orientation implementation
  • Advantages and disadvantages
  • Assumed knowledge
  • Performance

2. PL/SQL Language Semantics & Constructs

  • Block structures
  • Variables and constants
  • Query processing
  • Control structures
  • Modules and sub-programs
  • Abstract objects (e.g., collections, object types)
  • Error and exception handlers
  • Use of SQL*Plus

 

3. PL/SQL Language Properties & Conventions

  • Character set
  • Lexical elements (e.g., reserve words, comments)
  • Declarations
  • Defaults
  • NULL/NOT NULL
  • %TYPE and %ROWTYPE attributes
  • Naming conventions
  • Scoping
  • Name resolution
  • Assignments (e.g., to variables)
  • Expressions and comparisons
  • Built-in functions
  • Data types

 

4. PL/SQL – The Big Picture

  • Client-server architecture PL/SQL execution flow SQL*Plus DBMS_OUTPUT.LIN

 

5. How Sql Interoperates With PL/SQL

  • SELECT INTO
  • DML within PL/SQL block
  • PL/SQL block sequencing
  • Savepoints
  • Commit/rollback

 

6. Conditional Constructs

  • IF-THEN
  • IF-THEN-ELSE
  • ELSEIF
  • Nested IF
  • CASE statements
  • NULLIF/COALESCE
  • Loops
  • EXIT WHEN
  • GOTO

 

7. Exception & Error Handling

  • Reason for
  • Runtime vs. compile-time errors
  • Built-in exceptions
  • How exceptions are ‘raised’/’propagated’

 

8. SQL With PL/SQL Programming

  • Definition and concepts
  • INSERT, UPDATE and DELETE of PL/SQL records
  • FOR loops and cursors
  • Subqueries
  • REF CURSOR
  • Transaction controls

 

9. PL/SQL Subprograms

  • Definition
  • Advantages
  • Subprogram types
  • Procedures
  • Functions
  • Parameter passing
  • Invoking
  • Overloading

 

10. PL/SQL Objects – An Introduction

  • Definition
  • Advantages
  • Structure
  • Initialisation
  • Attributes
  • Constructors
  • Methods
  • Manipulating

 

11. Introduction To Package Concepts

  • Definition
  • Benefits
  • pecifications
  • Body
  • How to call
  • Private objects
  • Variables and cursors

 

12. TRIGGERS

  • Definition
  • When to consider
  • BEFORE/AFTER
  • ROW/STATEMENT
  • INSTEAD OF

 

13. PL/SQL Debugging

  • DBMS_DEBUG
  • ADP_DEBUG
  • How to debug a PL/SQL block
  • How to start the ‘debuggee’
  • How to start the ‘debugger’
  • Breakpoints
  • Executing the debugger
  • ‘Stepping’ the debugger
  • ADP package definition
  • ADP debugger body
  • XXX.SQL strings

 

If you want to know more about PL SQL TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW