Susisiekite su mumis:
+370 5 2105044

Oracle Database: Program with PL/SQL


Trukmė: 5 dienos
1 590 € (+ PVM 21%)

Apie mokymus:

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.

Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.

Mokymai skirti:

• PL/SQL Developer
• Forms Developer
• Application Developers
• Database Administrators
• Technical Consultant
• Portal Developer
• System Analysts
• Developer

Dėstytojas: Gediminas Reimeris

Mokymų temos:

1. Introduction
2. Introduction to PL/SQL
3. Declare PL/SQL Identifiers
4. Write Executable Statements
5. Interaction with the Oracle Server
6. Control Structures
7. Composite Data Types
8. Explicit Cursors
9. Exception Handling
10. Stored Procedures
11. Stored Functions and Debugging Subprograms
12. Packages
13. Deploying Packages
14. Implement Oracle-Supplied Packages in Application Development
15. Dynamic SQL
16. Design Considerations for PL/SQL Code
17. Triggers
18. Creating Compound, DDL, and Event Database Triggers
19. PL/SQL Compiler
20. Manage PL/SQL Code
21. Manage Dependencies