Oracle 10g: Basics of PL/SQL language
Durată
24
ore
Locație
Training
Limba
Engleză
Cod
DB-005
Training pentru 7-8 sau mai multe persoane?
Personalizați antrenamentele
pentru nevoile dumneavoastră specifice
Descriere
The course is introduction to procedural language Oracle PL/SQL. The course deals with language version used in DBMS 10g.
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training
în formularul Luxoft Training
Obiective
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
Public țintă
- Database administrators
- System administrators
- Application developers
- Testers
Cerințe preliminare
- Knowledge of algorithmization principles
- Knowledge of RDBMS principles and basics of SQL
Foaia de parcurs
- 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