Course Info

PLSQL1 - Introduction to Oracle9i - PL/SQL Language

Categories Database Training, Oracle Training, SQL Training

Duration 2 days (14 hours)

Pre-requisites Familiarity with database terminology and ORSQL - Introduction to Oracle9i - SQL or equivalent experience with SQL on Oracle.

Courseware PLSQL1-SID-01 (200 pages)

Price $790

Notes
This course is suitable for all Oracle professionals including developers, database administrators, designers and analysts.

This Oracle PL/SQL training class will explore how the Oracle PL/SQL language extends SQL with programming logic features not contained within SQL. This course covers the benefits of using the PL/SQL language within an Oracle database environment, including grammar and syntax. After taking this course, students will have explored declaring variables and complex datatypes; developing logic within PL/SQL program blocks; fetching data from the database into program variables; returning program output to users; handling program exceptions; using explicit and implicit database cursors and using the advanced features of nested blocks and subprograms.

"If you have some knowledge of SQL, but would like to get into Oracle programming, take this as a starter course to familiarize yourself with the fundamental aspects of PL/SQL. This class provides sufficient training to get you started.." -- Myla C. from San Diego, CA

"A very knowledgeable instructor and good course." -- Alex Y. from San Diego, CA

"My understanding of PL/SQL had been limited to BEGIN/END; now the whole world has opened up. [The instructor had] dood knowledge of information. Worth taking.." -- Robert B. from San Diego, CA

LANGUAGE FEATURES
      WHY USE PL/SQL?
      Where PL/SQL Program Units May Be Deployed
      The Java Alternative To PL/SQL
      STRUCTURE OF A PL/SQL PROGRAM BLOCK
      PL/SQL FROM INTERACTIVE TOOLS
      GENERATING OUTPUT
DECLARE CLAUSE
      DATATYPES
      DECLARE Example
      SPECIAL DATATYPES
      %TYPE VARIABLE
      %ROWTYPE RECORD
      TYPE TABLE
BEGIN CLAUSE
      DATA MANIPULATION
      CHAR and VARCHAR
      Numeric
      Date
      Boolean
      Comparison Operators
      Functions
      Date Calculations
      SELECTINTO
      LOGIC CONTROL & BRANCHING
      GOTO
      LOOP
      IF-THEN-ELSE
      CASE
EXCEPTION
      HANDLING EXCEPTION
      SPECIAL FEATURES
      SYSTEM DEFINED EXCEPTIONS
      USING SQLCODE & SQLERRM
      IMPLICIT CURSORS
      USER-DEFINED EX_INED
      PRAGMA EXCEPTION_INIT
EXPLICIT CURSORS
      UNDERSTANDING CURSORS
      EXPLAINING THE CURSOR EXAMPLE
      DECLARE Cursor E
      OPEN Cursor Example
      FETCH Cursor Example
      CLOSE Cursor Example
      INCLUDING CURSOR PARAMETERS
      PERFORMING UPDATES FROM CURSORS
      USING FORLOOP CURSORS
ADVANCED
      USING NESTED BLOCKS
      USING DECLARED SUBPROGRAMS
      DISPLAY_MESSAGE() Procedure Example
      GET_SPOUSE_NAME() Function Example