Oracle 10g: Basics of PL/SQL language

Oracle 10g: Basics of PL/SQL language
Duration
24 hours
Course type
Training
Language
English
Article
DB-005
Duration
24 hours
Location
Training
Language
English
Code
DB-005
Training for 7-8 or more people? Customize trainings for your specific needs
Oracle 10g: Basics of PL/SQL language
Duration
24 hours
Location
Training
Language
English
Code
DB-005
€ 596 *
Training for 7-8 or more people? Customize trainings for your specific needs

Description

The course is introduction to procedural language Oracle PL/SQL. The course deals with language version used in DBMS 10g.
certificate
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

After the training the attendees will be able to:
  1. Read and analyze PL/SQL code
  2. Create anonymous blocks and stored procedures of PL/SQL executable code
  3. Apply basic PL/SQL algorithms

Target Audience

  • Database administrators
  • System administrators
  • Application developers
  • Testers

Prerequisites

  1. Knowledge of algorithmization principles
  2. Knowledge of RDBMS principles and basics of SQL

Roadmap

  1. Introduction
    1. PL/SQL description
    2. PL/SQL features
    3. Advantages of PL/SQL
  2. Declaration of Variables
    1. Anonymous PL/SQL block and its sections
    2. Types of PL/SQL program construction
    3. Definition and use of PL/SQL variables
    4. Declaration of PL/SQL variables and constants
    5. Execution of PL/SQL block
  3. Writing executable commands
    1. Executable block section
    2. Rules for sub-blocks
    3. Executing and testing PL/SQL block
    4. Following agreements on code writing
  4. Interaction with Oracle Server
    1. Features of SELECT command in PL/SQL block
    2. Dynamic declaration of data type and variable size
    3. Using DML statements in PL/SQL block
    4. Transaction control in PL/SQL
    5. Checking the results of DML command execution
  5. Using control structures
    1. Control structure types
    2. Using IF statement
    3. CASE clause and statement
    4. Various loop types
    5. Using nested loops and labels to control processing
    6. Using logic tables
  6. Handling composite data types
    1. Creating user-defined PL/SQL records
    2. Adding and updating tables with PL/SQL records
    3. Associative arrays
  7. Using cursors
    1. Difference between implicit and explicit cursor
    2. Commands for explicit cursor handling
    3. Attributes of explicit cursor
    4. A cursor FOR loop
    5. Cursors with parameters
    6. Defining a cursor with FOR UPDATE
    7. Cursors with sub-query
  8. Exceptions handling
    1. Definition of PL/SQL exception
    2. Recognizing unhandled exceptions
    3. Types of PL/SQL exception handlers
    4. Trapping unexpected errors
    5. Exception propagation in sub-blocks
    6. PL/SQL Error message adaptation
  9. Creating stored procedure and functions
    1. Difference between anonymous blocks, procedures and functions
    2. Creating and invoking a procedure
    3. Creating and invoking a function
  10. Working with packages
    1. Package structure
    2. Header and Body
    3. Creating packages
    4. Benefits offered
  11. Using triggers
    1. Operation principle
    2. Triggers types
    3. Creating table triggers for tables
Still have questions?
Connect with us