Oracle Database 11g Getting Started with SQL and PL SQL New Features

To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies

The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

WEB

Using SQL*Plus| - recognize ways for using SQL*Plus commands to display the structure of a table and perform some editing and file management tasks.|Use SQL Developer| - recognize the steps for using SQL Developer and SQL Worksheet to connect to a database, browse and export database objects, and use SQL*Plus to enter and execute SQL and PL/SQL statements.|Creating Reports and Migrating with SQL Developer| - identify the steps for using SQL Developer to create reports and migrate to an Oracle Database 11g database.|Use Language Functionality Enhancements| - recognize the steps for using Oracle Database 11g's new SQL and PL/SQL language functionality enhancements.|DCN and Lock Enhancements| - recognize the scope and uses of Data Change Notification (DCN) and lock enhancements.|Using Language Functionality Enhancements| - use SQL and PL/SQL language functionality enhancements to connect to a database and create a report, examine dependency at the element level, and modify an exception handler.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...