Oracle 10g: Basics of PL/SQL language
Продолжительность
24
часы
Місцезнаходження
Training
Мова
Англійська
Код
DB-005
Тренінг для 7-8 чи більше людей?
Налаштуйте тренінги
для ваших конкретних потреб
опис
The course is introduction to procedural language Oracle PL/SQL. The course deals with language version used in DBMS 10g.
Після проходження курсу видається сертифікат
на бланку Luxoft Training
на бланку Luxoft Training
Цілі
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
Цільова аудиторія
- Database administrators
- System administrators
- Application developers
- Testers
передумови
- Knowledge of algorithmization principles
- Knowledge of RDBMS principles and basics of SQL
Дорожня карта
- 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