Glasspaper er Oracle Approved Education Center i Norge


Oracle Database: Develop PL/SQL Program Units

Kursavgift: kr 17 500 | Varighet: 3 dager

Beskrivelse:

This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database triggers.

During this training you will learn to:
  • Create, and execute stored procedures and functions.
  • Design and use PL/SQL packages.
  • Create overloaded package subprograms for more flexibility.
  • Utilize Oracle supplied packages in application development.
  • Create triggers to solve business challenges.
  • Build and execute SQL statements dynamically.
  • Manage PL/SQL subprograms and triggers.
  • Understand and influence the PL/SQL compiler.
  • Manage dependencies.

Practical information


Our Oracle courses is conducted at the following hours:
  • Monday to Friday: 09.00 – 16.00
Location
Our Oracle courses will take place at Glasspaper`s course center at Crayon in Nydalen:
Adress: Crayon, Sandakerveien 114A, 0402 Oslo.

Course material
We use official Oracle material in our Oracle trainings. This include eKit (electronic documentation) and Lab environment from Oracle University.


Målgruppe:

The audience for this traning is
  • Application Developers
  • Database Administrators
  • PL/SQL Developer
  • Support Engineer
  • System Analysts

Forkunnskaper:

Required Prerequisites:
  • Familiarity with programming Languages
  • Basic Knowledge of PL/SQL
  • Oracle Database: Introduction to SQL
  • Oracle Database: PL/SQL Fundamentals
Suggested Prerequisites:
  • Oracle SQL Tuning for Developers Workshop

Innhold:


Introduction
Course Objectives, Course Agenda and Appendixes Used in this Course
Describe the full Human Resources (HR) Schema
Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available
resources
List the PL/SQL development environments Available in this course
Use the SQL Worksheet
Execute SQL Statements
Work With Script Files
Create and Execute Anonymous Blocks

Creating Stored Procedures
Describe PL/SQL blocks and subprograms
Describe the uses and benefits of procedures
Create, call, and remove procedures
Use formal and actual parameters
Identify the available parameter-passing modes
Pass parameters using the positional, named, or combination techniques
Handle exceptions in procedures
View the procedure information

Creating Functions and Debugging Subprograms
Creating Stored Functions
The Difference Between Procedures and Functions
Developing Functions
Creating and Executing and Removing Functions
Identifying the Advantages of Using Stored Functions in SQL Statements
Using User-Defined Functions in SQL Statements
Using a PL/SQL Function in the SQL WITH Clause
Restrictions When Calling Functions from SQL statements

Creating Packages
Using PL/SQL Packages
The Components of a PL/SQL Package
The Visibility of a Package’s Components
Developing a PL/SQL Package
Creating the Package Specification and Package Body
Invoking the Package Constructs
Creating and Using Bodiless Packages
Removing a Package

Working With Packages
Overloading Subprograms
Using Forward Declarations to Solve Illegal Procedure Reference
Initializing Packages
Using Package Functions in SQL and Restrictions
Controlling Side Effects of PL/SQL Subprograms
Persistent State of Packages
Persistent State of Package Variables and Cursors
Using PL/SQL Tables of Records in Packages

Using Oracle-Supplied Packages in Application Development
Using Oracle-Supplied Packages
Examples of Some of the Oracle-Supplied Packages
How Does the DBMS_OUTPUT Package Work?
Using the UTL_FILE Package to Interact With Operating System Files
Using the UTL_MAIL Package

Using Dynamic SQL
The Execution Flow of SQL
Working With Dynamic SQL
When Do You Need Dynamic SQL?
Using Native Dynamic SQL (NDS)
Declaring Cursor Variables
Executing a PL/SQL Block Dynamically
Using Native Dynamic SQL to Compile PL/SQL Code

Design Considerations for PL/SQL Code
Standardize constants with a constant package
Standardize exceptions with an exception package
Write PL/SQL code that uses local subprograms
Grant Roles to PL/SQL Packages and Standalone Stored Subprograms
Use the NOCOPY compiler hint to pass parameters by reference
Use the PARALLEL ENABLE hint for optimization
Use the AUTONOMOUS TRANSACTION pragma to run independent transactions within a single transaction
Describe the differences between invoker rights and definer rights

Creating Triggers
Describe different types of triggers
Describe database triggers and their use
Create database triggers
Describe database trigger firing rules
Remove database triggers

Creating Compound, DDL, and Event Database Triggers
Describe compound triggers
Describe mutating tables
Create triggers on DDL statements
Create triggers on system events
Display information about triggers

Using PL/SQL compiler
Using the PL/SQL CompilerUsing the Initialization Parameters for PL/SQL Compilation
Using the PL/SQL Compile Time Warnings
Viewing the Current Setting of PLSQL_WARNINGS
Viewing the Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
Guidelines for Using PLSQL_WARNINGS

Managing Dependencies
Describe dependent and referenced objects
Track procedural dependencies with dictionary views
Predict the effect of changing a database object upon stored procedures and functions
Manage local and remote procedural dependencies



Read complete course description: Oracle Database: Develop PL/SQL Program Units




Epost mottat


Du er nå meldt på nyhetsbrevlisten

Epost mottat


Du er nå meldt på nyhetsbrevlisten

Bestill kurset her

arrow

Velg kurssted

    arrow

    Velg dato

    kurs merket med * har startgaranti

    arrow

    Mailen er sendt:

    Ditt tips er registrert og sendt!
    Vi håper snarlig å se deg på kurs hos oss!

    Feilmelding:

    OBS! Vi har problemer med å sende ditt tips!

    Vi anbefaler deg å sjekke om du har skrevet inn en gyldig mailadresse.

    Tips sjefen

    Lyst til å delta på dette kurset, men må overbevise sjefen først?

    Glasspaper har laget en tips funksjon, som gjør det enklere for deg å overbevise din sjef om at dette kurset er perfekt for deg.
    Det eneste du trenger å gjøre er å fylle ut kontaktinformasjon, så sender vi relevant informasjon om kurset rett til dine utvalgte kontaktpersoner.
    Bruk gjerne funksjonen til å tipse venner og kollegaer om at dette er et nyttig kurs for dem





    Kontakt oss

    Kursansvarlig

    Karin Sørensen

    932 10 626

    karin.sorensen@glasspaper.no


    Glasspaper er kåret til Årets Microsoft Kurspartner 2016 - 2015 - 2014 - 2013 - 2012 - 2011 - 2010 - 2008!