Advanced Oracle 10g PL/SQL Powerpoint Presentations

Wednesday, September 1, 2010

Advanced Oracle 10g PL/SQL Training Overview

This advanced Oracle PL/SQL training helps PL/SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle to develop and tune efficient and effective PL/SQL subprograms.
Advanced Oracle 10g PL/SQL Training Objectives
All attendees will learn how to:
  • Understand application partitioning within a client/server or multi-tiered web-based architecture.
  • Understand the basic form and structure of program units stored within the database.
  • Build and maintain database stored program units.
  • Encapsulate stored units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions.
  • Handling intricate theoretical challenges, such as mutating tables.
  • Build and maintain DML-event and system-event database triggers.
  • Discuss the storage and execution model for database programs and how one can write efficient programs to maximize performance.
  • Use system-supplied packages to extend the power of your SQL statements and PL/SQL applications.
Advanced Oracle 10g PL/SQL Training Outline

  • Creating & maintaining packages
    • About packages
    • Creating packages
    • Advanced programming techniques
    • Maintaining packages
  • Advanced cursor techniques
    • Using cursor variables
    • Using cursor expressions
  • Using system-supplied packages
    • dbms_output()
    • utl_file()
  • Creating database triggers
    • About database triggers
    • Statement-level triggers
    • Row-level triggers
    • Examples of triggers
    • Instead of triggers
    • Employing triggers within an application
  • Maintaining database triggers
    • Call syntax
    • Multiple triggers per event
    • Trigger maintenance tasks
    • Show errors trigger
    • Drop trigger
    • Alter trigger
    • Handling mutating table issues
  • Implementing system event triggers
    • What are system event triggers?
    • defining the scope
    • Available system events
    • System event attributes
  • Conclusion

Download Link:

1 comments:

oracle ebs r12 June 24, 2011 at 12:33 PM  

Excellent post. You have made such a nice presentation covering so many topics which I wanted to learn. You made my learning process very easy. I will pass this presentation with my friends too so that they will understand all these topics easily. Thank you so much.

Post a Comment

Related Posts with Thumbnails

Sponser Links

Followers

Sponser Links

  ©2009-10 | Disclaimer

Back to TOP