Introduction to Oracle for Experienced SQL Users

Training Method: Instructor Led Training Instructor-led Training

Description:
This course is appropriate for those who are proficient in the industry-standard SQL programming language but who want to learn how Oracle�s powerful SQL extensions can help them in their job. This class teaches students the commands, functions, and operators supported by Oracle as extensions to standard SQL. Students also learn about pseudocolumns and additional datatypes supported by Oracle. Further, they learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Register for this Course

Audience:
  • Database Administrators
  • Application Developers
  • Designer/Developers

Required Prerequisites:

  • Proficiency in standard SQL
  • Familiarity with Relational Database Management System (RDBMS) concepts

Suggested Prerequisites:

    None

Course Objectives:

  • Create and use PL/SQL blocks
  • Use additional features supported by Oracle that extend beyond standard SQL
Return to top

Course Topics:

Overview of the Oracle Environment

The Oracle SELECT Statement

Manipulating Data Using Functions

Group Functions

Using SET Operators

Writing Subqueries

Hierarchical Retrieval

Creating and Managing Tables

Other Oracle Database Objects

Controlling Transactions

Control User Access

SQL*Plus

Declaring Variables

Writing Executable Statements

Interacting with the Oracle Server

Writing Control Structures

Working with Composite Datatypes

Writing Explicit Cursors

Advanced Explicit Cursor Concepts

Handling Exceptions

Return to top

Suggested Next Courses:
Return to top

Related Courses:
 Return to top