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

This course is included in our On-demand training solution.

Overview

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

Target Audience

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

Prerequisites

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

Expected Duration

105 min.

Course Objectives

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

  • recognize ways for using SQL*Plus commands to display the structure of a table and perform some editing and file management tasks.
  • 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.
  • identify the steps for using SQL Developer to create reports and migrate to an Oracle Database 11g database.
  • recognize the steps for using Oracle Database 11g’s new SQL and PL/SQL language functionality enhancements.
  • recognize the scope and uses of Data Change Notification (DCN) and lock 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?