PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
» ORACLE 10g: PL/SQL Fundamentals


   print

PLSF10g - ORACLE 10g: PL/SQL Fundamentals

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn describe the features and syntax of PL/SQL, conditionally control code flow, loops, control structures, explicit cursors and handle runtime errors.

Who the course is for

  • System Analytics
  • Developers
  • Administrators
  • Technical Support Staff

    What we teach you

    This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn describe the features and syntax of PL/SQL, conditionally control code flow, loops, control structures, explicit cursors and handle runtime errors.

    Required skills

  • Familiarity with data processing concepts and techniques
  • Knowledge covered in course Introduction to Oracle9i: SQL (SQL9i)
  • Familiarity with programming is an advance

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English.

    Course syllabus

    Introduction PL/SQL

  • Executing Statements and PL/SQL Blocks
  • PL/SQL Block Structure 
  • Nested Blocks 
  • Declaring Variables
  • Records in  PL/SQL
  • Variable Initialization and Keywords
  • Using PL/SQL in SQL*Plus

    Interacting with the Oracle Server

  • SQL statements in PL/SQL
  • Implicit cursors
  • Transaction Control Statements
  • SELECT statement in PL/SQL

    Writing Control Structures

  • IF–THEN–ELSE Statement Execution Flow
  • FOR LOOP
  • WHILE LOOP
  • Nested Loops and Labels

    Working with Composite Data Types

  • PL/SQL records
  • INDEX BY Tables

    Writing Explicit Cursors

  • Declaring the Cursor
  • Fetching Data from the Cursor 
  • Cursor FOR LOOP

    Handling Exceptions

  • What is an Exception
  • Trapping Exceptions 
  • Exception Types

    Recommended prior courses

    FM10g - Oracle Forms Developer 10g: Build Internet Applications
    SQL10g - Oracle 10g: SQL Language

    Recommended subsequent courses

    PLSP10g - ORACLE 10g: Creating Program Units Using PL/SQL
    SQL_TUN10g - Oracle 10g: SQL Tuning
    10g_DBAI - Oracle Database 10g: Administration Workshop I
    XML_FUND - Oracle 10g: XML Fundamentals
    XML_PLS - Oracle Database 10g: Use XML for SQL and PL/SQL developers
    FM10g - Oracle Forms Developer 10g: Build Internet Applications
    APEX - Oracle Application Express 3.0: Developing Web Applications

    Catalog price of course and handbook

    Locality Course length Course price ex VAT Price of handbook ex VAT Number IT points
     Praha  2  21000 Kč  --   40 items
     Brno  2  21000 Kč  --   40 items

    Course dates

    No dates have been announced yet. If you are seriously interested, please contact our customer service department for more information about the option of arranging special course times on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).