Oracle 10g: Basics of PL/SQL language
Duration
24
hours
Location
Training
Language
English
Code
DB-005
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.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
After the training the attendees will be able to:
- Read and analyze PL/SQL code
- Create anonymous blocks and stored procedures of PL/SQL executable code
- Apply basic PL/SQL algorithms
Target Audience
- Database administrators
- System administrators
- Application developers
- Testers
Prerequisites
- Knowledge of algorithmization principles
- Knowledge of RDBMS principles and basics of SQL
Roadmap
- Introduction
- PL/SQL description
- PL/SQL features
- Advantages of PL/SQL
- Declaration of Variables
- Anonymous PL/SQL block and its sections
- Types of PL/SQL program construction
- Definition and use of PL/SQL variables
- Declaration of PL/SQL variables and constants
- Execution of PL/SQL block
- Writing executable commands
- Executable block section
- Rules for sub-blocks
- Executing and testing PL/SQL block
- Following agreements on code writing
- Interaction with Oracle Server
- Features of SELECT command in PL/SQL block
- Dynamic declaration of data type and variable size
- Using DML statements in PL/SQL block
- Transaction control in PL/SQL
- Checking the results of DML command execution
- Using control structures
- Control structure types
- Using IF statement
- CASE clause and statement
- Various loop types
- Using nested loops and labels to control processing
- Using logic tables
- Handling composite data types
- Creating user-defined PL/SQL records
- Adding and updating tables with PL/SQL records
- Associative arrays
- Using cursors
- Difference between implicit and explicit cursor
- Commands for explicit cursor handling
- Attributes of explicit cursor
- A cursor FOR loop
- Cursors with parameters
- Defining a cursor with FOR UPDATE
- Cursors with sub-query
- Exceptions handling
- Definition of PL/SQL exception
- Recognizing unhandled exceptions
- Types of PL/SQL exception handlers
- Trapping unexpected errors
- Exception propagation in sub-blocks
- PL/SQL Error message adaptation
- Creating stored procedure and functions
- Difference between anonymous blocks, procedures and functions
- Creating and invoking a procedure
- Creating and invoking a function
- Working with packages
- Package structure
- Header and Body
- Creating packages
- Benefits offered
- Using triggers
- Operation principle
- Triggers types
- Creating table triggers for tables