ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 10g: Advanced PL/SQL

Format: Formation virtuelle avec formateur
Autres 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 be made.
 
 

Compétences acquises
 

  • 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

Qui peut en profiter
 

  • Database Designers

  • PL/SQL Developer

 

  • Technical Consultant

Préalables
 

  • Understanding of HTML syntax

 
     
    Enroll For This Class
    Enroll For This Class
    Oracle DB PeopleSoft Hyperion Ce cours est donné par des formateurs certifiés Oracle.

    Oracle University a nommé ExitCertified Partenaire de l’année 2011

    Il y a une différence....découvrez-la.
    Training Class Enrollment Ask A Question About This Training
    Code: D59004GC10
    Format: Formation virtuelle avec formateur
    Durée: 2
    Certifié par: Oracle
    Frais d’inscription (CAD): 1,650$
    Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
    Recherchez des cours semblables
    Cours connexes

    Trier l'horaire par: 
    No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
       
    demander la date/l’emplacement demander de la formation sur place
     

    Oracle Database 10g: Advanced PL/SQL Contenu détaillé
     
     
    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 is your Authorized IT Training Partner  
      Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

    Il y a une différence. Apprenez directement de la source.    		  
    Training Contacts  
       
    Canada United States

    Formation à Montréal :: 514.876.1666
    Formation à Ville de Québec :: 514.876.1666
    Formation à Ottawa :: 613.232.3948
    Formation à Toronto :: 416.487.3948

    Formation à Vancouver :: 604.633.3948
    Formation à Victoria :: 1.866.328.3948
    Formation à Calgary :: 403.291.2855
    Formation à Edmonton :: 780.441.3948
    Formation à Regina :: 1.866.328.3948

    		 Formation à Sacramento :: 916.669.3970
    Formation à San Francisco :: 415.975.3948
    Formation à San Jose :: 408.288.3948
    Formation à Las Vegas :: 1.800.803.3948
    Formation à Phoenix :: 602.889.9350
    À travers le monde - 613.232.3948 Des questions?
    Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
       



    (c) 2012 ExitCertified Corp. Tous droits réservés.


    ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
     
    Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
    Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
             
    Formation MySQL Formation Apple Formation en gestion de projet    
    Base de données MySQL Cours Apple, Formation Leopard Formation du PMI