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 11g: SQL and PL/SQL New Features

Format: Formation virtuelle avec formateur
Autres formats:
 
 

In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.

Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features are also discussed in this course. Students also learn about the reengineered LOB data type that offers advanced, next-generation functionality such as intelligent compression and transparent encryption. Additionally, students explore the data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators.

Learn To:
  • Practice the performance improvements
  • Monitor dependency tracking and change notification
  • Write compound triggers and use the enhancements made to triggers
  • Use Secure File LOBS
  • Use the SQL Developer interface
  • Write SQL statements that include the new functions added to enhance regular expression support functionality

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
 

  • Explore the PIVOT and UNPIVOT Data warehousing operators

  • Use the SQL Developer interface

  • Write SQL statements that include the new functions added to enhance regular expression support functionality

  • Use the enhancements added to native dynamic SQL and to DBMS_SQL which enable more interoperability between the two methodologies

  • Use element level dependency tracking

 

  • Write compound triggers and use the enhancements made to triggers

  • Practice the performance improvements

  • Use Secure File LOBS

  • Write SQL and PL/SQL calls to sequences that are simpler

  • Use the new CONTINUE statement to control loops

Qui peut en profiter
 

  • Application Developers

  • Data Warehouse Administrator

  • Developer

 

  • PL/SQL Developer

  • System Analysts

Préalables
 

  • Experience and knowledge of SQL and PL/SQL from prior Oracle releases

 

  • Hands on experience using PL/SQL
 
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: D58271GC10
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: 
Live Virtual Class  May.31 - Jun.1.2012 course register
Live Virtual Class  Jul.5 - Jul.6.2012 course register
Live Virtual Class  Jul.26 - Jul.27.2012 course register
Live Virtual Class  Aug.16 - Aug.17.2012 course register
Live Virtual Class  Aug.27 - Aug.28.2012 course register
Live Virtual Class  Aug.30 - Aug.31.2012 course register
Live Virtual Class  Nov.20 - Nov.21.2012 course register
7 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

Oracle Database 11g: SQL and PL/SQL New Features Contenu détaillé
 
 
Implementing the Language Functionality Enhancements
  • Use the new regular expression support functions to find sub patterns and count the occurrences of patterns
  • Track dependencies at the element level
  • Find and fix exception handlers that do not pass the exception upward to the calling program or environment
  • Dispatch an over ride-able object type method using the ANSI SQL 2003 standard for super-types
  • Use the WAIT option for DDL statements
  • Use the LOCK TABLE new syntax that enables you to specify the maximum number of seconds the statement should wait to obtain a DML lock on the table
Executing Dynamic SQL in PL/SQL with the 11g Enhancements
  • Write PL/SQL code that uses dynamic SQL and allows for SQL statements larger than 32kb
  • Use the DBMS_SQL.PARSE() function that is overloaded for CLOBs
  • Convert a REF CURSOR to a DBMS_SQL cursor and vice versa to support interoperability
  • Program using the enhancements to DBMS_SQL that include supporting the full range of data types (including collections and object types)
  • Create user-defined collection types and bulk bind them using DBMS_SQL
Utilizing the Performance Improvement Enhancements
  • List the compiler changes and how the changes impact native compilation
  • Use the new SIMPLE_INTEGER data type
  • Describe the process of in-lining
  • Use flashback to store and track all transactional changes to a record
Practicing the Language Usability Enhancements
  • Implement the sequence calls to NEXTVAL and CURRVAL without using a SQL statement to retrieve the values
  • Use the new CONTINUE statement to control the next loop iteration or to leave a loop
  • Use both named and mixed notation calls to functions from a SQL statement
  • Use the ALTER TABLE statement to change tables to read-only status
 
Coding the Trigger Enhancements
  • Create compound triggers
  • Create disabled triggers
  • Use the ENABLE clause with a trigger
  • Control trigger order with the FOLLOWS and PRECEDES clauses
Administering Secure-File LOBs
  • Describe Secure-File LOB features
  • Migrate Basic-File LOBs to the Secure-File LOB format
  • Analyze the performance of LOBs
  • Enable Secure-File LOB de-duplication, compression, and encryption
Using the Data Warehousing Usability Enhancements
  • Identify the benefits of pivoting and un-pivoting operations
  • Write cross-tab queries to pivot (rotate) column values into new columns and to un-pivot (rotate) columns into column values
  • Pivot and un-pivot with multiple columns and multiple aggregates
  • Use wildcards and aliases with pivoting operations
Using the SQL Developer Enhancements
  • Navigate through the object navigator and view the enhancements
  • Compile and debug PL/SQL
  • Browse through the available search engines
  • Change preferences
  • Create reports


  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