| Sağlayıcı: | Oracle |
| Kategori: | Sql – Pl/Sql |
| Eğitim Adı: | Oracle Database: Program With Pl/Sql Eğitimi |
| Eğitim Süresi: | 5 gün |
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Through hands-on instruction from expert instructors, you’ll develop stored procedures, functions, packages and more.
Learn To:
- Conditionally control code flow (loops, control structures).
- Use PL/SQL packages to group and contain related constructs.
- Generate triggers to solve business challenges.
- Create anonymous PL/SQL blocks, as well as stored procedures and functions.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create anonymous PL/SQL blocks, functions and procedures.
- Declare PL/SQL variables.
- Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- Debug functions and procedures using the SQL Developer Debugger.
- Use Dynamic SQL & understand design considerations when coding using PL/SQL.
- Understand and influence the PL/SQL compiler and manage dependencies.
- Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
Benefits To You:
Extend the functionality of the SQL language with PL/SQL language to write application code so that your organization can realize the full benefit of utilizing Oracle best practices.
Course Bundle
This course is the bundle of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.
Course Topics
Introduction to PL/SQL, Declare PL/SQL Identifiers, Write Executable Statements, Interaction with the Oracle Server , Control Structures, Composite Data Types , Explicit Cursors, Exception Handling , Stored Procedures, Stored Functions and Debugging Subprograms, Packages, Deploying Packages, Implement Oracle-Supplied Packages in Application Development, Dynamic SQL, Design Considerations for PL/SQL Code, Triggers, Creating Compound, DDL, and Event Database Triggers, PL/SQL Compiler , Manage PL/SQL Code, Manage Dependencies