ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
Email Training Course

Oracle Database 10g: Advanced PL/SQL - LVC

Format: Instructor-Led Live Virtual Class
Other Formats:
 
 

This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.

In this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not
 
 

Skills Gained
 

  • Design PL/SQL packages and program units that execute efficiently

  • Write code to interface with external applications and the operating system

  • Create PL/SQL applications that use collections

 

  • Write and tune PL/SQL code effectively to maximize performance

  • Implement a virtual private database with fine-grained access control

  • Perform code analysis to find program ambiguities, test, trace, and profile PL/SQL code

Who Can Benefit
 

  • Database Designers

  • PL/SQL Developer

 

  • Technical Consultant

Prerequisites
 

  • Understanding of HTML syntax

 
     
    Enroll For This Class
    Enroll For This Class
    Oracle DB PeopleSoft Hyperion This course is taught by Certified Oracle instructors.

    Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards

    There is a difference....learn more.
    Training Class Enrollment Ask A Question About This Training
    Code: D59004GC10
    Format: Instructor-Led Live Virtual Class
    Length: 2
    Certified By: Oracle
    Tuition (CAD): $1,600
    Browse Similar Training Classes
    Related training classes
    Instructor Training Classes
    Instructor-Led Classroom
    Oracle Database 10g: Advanced PL/SQL

    Sort Schedule By: 
    Virtual Live Class Aug.19 - Aug.20.2010 course register
    Virtual Live Class Oct.28 - Oct.29.2010 course register
    Virtual Live Class Nov.14 - Nov.15.2010 course register
         
       
    Request Other Course Date Request Course On-Site
     

    Oracle Database 10g: Advanced PL/SQL - LVC Content Details
     
     
    Introduction
    • Course objectives
    • The Oracle complete solution
    • Course agenda
    • Tables and data used for this course
    PL/SQL Programming Concepts Review
    • Identify PL/SQL block structure
    • Create procedures
    • Create functions
    • Create packages
    • Use cursors
    • Handle exceptions
    • Understand dependencies
    • Identify the Oracle supplied packages
    Design Considerations
    • List the different guidelines for cursor design
    • Describe cursor variables
    • Pass cursor variables as program parameters
    • Compare cursor variables to static cursors
    • Describe the predefined data types
    • Create subtypes based on existing types for an application
    Collections
    • Describe and use nested tables
    • Describe and use arrays
    • Describe and use associative arrays
    • Describe and use string indexed collections
    • Describe and use nested collections
    • Write PL/SQL programs that use collections
    • Describe the common collection exceptions and how to code for them
    • Compare associative arrays to collections
    		 
    Advanced Interface Methods
    • Execute external C routines from PL/SQL
    • Understand the benefits of external routines
    • Publish the external C routine in the PL/SQL code
    • Execute a PL/SQL routine that calls the external C routine
    • Execute Java routines from PL/SQL
    • Publish the Java class method by creating the PL/SQL subprogram unit specification that references the Java class method
    • Execute the PL/SQL subprogram that invokes the Java class method
    PL/SQL Server Pages
    • Define embedding PL/SQL code in Web pages (PL/SQL Server Pages)
    • Describe the format of a PL/SQL Server Page
    • Write the code and content for the PL/SQL Server Page
    • Load the PL/SQL Server Page into the database as a stored procedure
    • Run a PL/SQL Server Page via a URL
    • Debug PL/SQL Server Page problems
    Fine Grained Access Control
    • Understand how fine-grained access control works overall
    • Describe the features of fine-grained access control
    • Describe an application context
    • Set up a logon trigger
    • View the results
    • Query the dictionary views holding information on fine-grained access
    Performance and Tuning
    • Tune PL/SQL code
    • Write smaller executable sections of code
    • Compare SQL to PL/SQL on performance
    • Understand how bulk binds can improve performance
    • Handle exceptions with the FORALL syntax
    • Identify data type and constraint issues
    • Recognize network issues
    Analyzing PL/SQL Code
    • Use the supplied packages and dictionary views to find coding information
    • dbms_describe supplied package
    • Use supplied packages to find error information
    • Trace PL/SQL programs using the dbms_trace supplied packageq
    • Read and interpret the trace information
    • Profile PL/SQL programs using the dbms_profiler supplied package
    • Read and interpret the profiler information


      ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
      When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

    There is a difference. Learn from the source.    		  
    Training Contacts  
       
    Canada United States

    Vancouver Training :: 604.633.3948
    Victoria Training :: 1.866.328.3948
    Calgary Training :: 403.291.2855
    Edmonton Training :: 780.441.3948
    Regina Training :: 1.866.328.3948
    Toronto Training :: 416.487.3948
    Ottawa Training :: 613.232.3948
    Montreal Training :: 514.876.1666
    Quebec City Training :: 514.876.1666

    		Sacramento Training :: 916.669.3970
    San Francisco Training :: 415.975.3948
    San Jose Training :: 408.288.3948
    Las Vegas Training :: 1.800.803.3948
    Phoenix Training :: 602.889.9350
    Worldwide - 613.232.3948 Got Questions?
    We are happy to help. Just email us with this form and we'll get back to you shortly.
       



    (c) 2010 ExitCertified Corp. All rights reserved.


    ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
     
    Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
    Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
             
    MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
      Apple Course, Leopard Training, Xsan Training