Advanced Oracle 10g PL/SQL Powerpoint Presentations

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:

Oracle.10g.Advanced.PLSQL.Slides