Course ID Format Duration Price (in INR)
TEKDB04 ILT 3 Available on Request

Need a customized class for your group? Contact Us.

No classes scheduled? Subscribe when new classes are added.

* Public Price per Student

  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Design PL/SQL packages to group related constructs
  • Create overloaded package subprograms for more flexibility
  • Design PL/SQL anonymous blocks that execute efficiently
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Describe the features and syntax of PL/SQL
  • Create and debug stored procedures and functions
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Manage dependencies between PL/SQL subprograms
  • Handle runtime errors
  • Create triggers to solve business challenges
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Design PL/SQL packages to group related constructs
  • Create overloaded package subprograms for more flexibility
  • Design PL/SQL anonymous blocks that execute efficiently
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Describe the features and syntax of PL/SQL
  • Create and debug stored procedures and functions
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Manage dependencies between PL/SQL subprograms
  • Handle runtime errors
  • Create triggers to solve business challenges
  • Application Developers, Developer, End Users, PL/SQL Developer, Database Administrators, Technical Consultant, Forms Developer and Support Engineer

    -

    Required Prerequisites

    Familiarity with data processing concepts and techniques and Familiarity with programming concepts.

      Day-1:

      =======

      1. Introduction to PL/SQL

    1. PL/SQL Overview
    2. List the benefits of PL/SQL Subprograms
    3. Overview of the Types of PL/SQL blocks
    4. Create a Simple Anonymous Block
    5. Generate the Output from a PL/SQL Block
    6. 2. PL/SQL Identifiers

    7. List the different Types of Identifiers in a PL/SQL subprogram
    8. Usage of the Declarative Section to Define Identifiers
    9. Use of variables to store data
    10. Scalar Data Types
    11. %TYPE Attribute
    12. Bind Variables
    13. Sequences in PL/SQL Expressions
    14. 3. Write Executable Statements

    15. Basic PL/SQL Block Syntax Guidelines
    16. How to comment code?
    17. SQL Functions in PL/SQL
    18. Data Type Conversion
    19. Nested Blocks
    20. Operators in PL/SQL
    21. Day-2:

      =======

      4. Interaction with the Oracle Server

    22. SELECT Statements in PL/SQL to Retrieve data
    23. Data Manipulation in the Server Using PL/SQL
    24. The SQL Cursor concept
    25. Learn to use SQL Cursor Attributes to Obtain Feedback on DML
    26. How to save and discard transactions?
    27. 5. Control Structures

    28. Conditional processing Using IF Statements
    29. Conditional processing Using CASE Statements
    30. Simple Loop Statement
    31. While Loop Statement
    32. For Loop Statement
    33. The Continue Statement
    34. 6. Usage of Composite Data Types

    35. PL/SQL Records
    36. The %ROWTYPE Attribute
    37. Insert and Update with PL/SQL Records
    38. Associative Arrays (INDEX BY Tables)
    39. INDEX BY Table Methods
    40. INDEX BY Table of Records
    41. Day-3:

      =======

      7. Explicit Cursors

    42. Understand Explicit Cursors
    43. Declare the Cursor
    44. How to open the Cursor?
    45. Fetching data from the Cursor
    46. How to close the Cursor?
    47. Cursor FOR loop
    48. Explicit Cursor Attributes
    49. FOR UPDATE Clause and WHERE CURRENT Clause
    50. 8. Exception Handling

    51. What are exceptions?
    52. Handle Exceptions with PL/SQL
    53. Trap Predefined Oracle Server Errors
    54. Trap Non-Predefined Oracle Server Errors
    55. Trap User-Defined Exceptions
    56. Propagate Exceptions
    57. RAISE_APPLICATION_ERROR Procedure
    58. 9. Stored Procedures and Functions

    59. What are Stored Procedures and Functions?
    60. Differentiate between anonymous blocks and subprograms
    61. Create a Simple Procedure
    62. Create a Simple Procedure with IN parameter
    63. Create a Simple Function
    64. Execute a Simple Procedure
    65. Execute a Simple Function

    Contact us

    91-422-2231010 / 11

    Connect to our Expert

    Client Speak

    Teknoturf instructors have taught for IBM in seven countries and they have consistently been rated extremely highly by students from diverse backgrounds and cultures.

    David Barun Thomas, Regional Manager, South Asia, IBM Learning Services

    Our Clients

    • Abn Amro
    • Accenture
    • Adobe
    • Bank Dhofar
    • Capgemini
    • Citi
    • Cognizant
    • Etihad
    • IBM
    • Infosys
    • Virtusa
    • World Bank