"Vi hjelper deg å nå dine kompetansemål i 2017"


Oracle Database 12c: PL/SQL Fundamentals

Kursavgift: kr 11 300 | Varighet: 2 dager

Beskrivelse:

This Oracle Database: PL/SQL Fundamentals course introduces you to PL/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.

During this training you will learn to:
  • Describe the features and syntax of PL/SQL
  • Design a PL/SQL anonymous block that executes efficiently
  • Write PL/SQL code to interface with the database
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle runtime errors
  • Describe stored procedures and functions
  • Apply declaring identifiers and trapping exceptions
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management Applications

Målgruppe:

The audience for this traning is
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant

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.



Forkunnskaper:

Required Prerequisites:
  • Familiarity with data processing concepts and techniques
  • Familiarity with programming Languages
The course Oracle Database 12c: SQL Workshop I will give you the required knowledge to attend Oracle Database 12c: PL/SQL Fundamentals.


Innhold:


Introduction
Course Objectives, Course Agenda and Class Account Information
Describe the Human Resources (HR) Schema
Identify the Appendices Used in this Course

Introduction to PL/SQL Development Environments
Oracle Database 12c SQL Documentation and Additional Resources
Introduction to PL/SQL
Understanding the benefits and structure of PL/SQL
Examining PL/SQL Blocks
Generating output messages in PL/SQL

Declaring PL/SQL Variables
Identify valid and invalid identifiers
Declare and initialize variables
List and describe various data types
Identify the benefits of using the %TYPE attribute
Declare, use, and print bind variables

Writing Executable Statements
List Lexical Units in a PL/SQL Block
Use SQL Functions in PL/SQL
Use Data Type Conversion
Use Nested Blocks as Statements
Copyright © 2013, Oracle. All rights reserved. Page 2
Reference an Identifier Value in a Nested Block
Qualify an Identifier with a Label
Use Operators in PL/SQL
Using Sequences in PL/SQL Expressions

Using SQL Statements within a PL/SQL Block
Identify and use the SQL Statements in PL/SQL
Retrieve Data in PL/SQL with the SELECT statement
Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
Manipulate Data in the Server Using PL/SQL
The SQL Cursor concept
Use SQL Cursor Attributes to Obtain Feedback on DML
Save and Discard Transactions

Writing Control Structures
Control PL/SQL Flow of Execution
Conditional processing Using IF and CASE Statements
Handle Nulls to Avoid Common Mistakes
Build Boolean Conditions with Logical Operators
Use Iterative Control with Looping Statements

Working with Composite Data Types
Learn the Composite Data Types of PL/SQL Records and Tables
Use PL/SQL Records to Hold Multiple Values of Different Type
Inserting and Updating with PL/SQL Records
Use INDEX BY Tables to Hold Multiple Values of the Same Data Type

Using Explicit Cursors
Define Cursors
Explain Explicit Cursor Operations
Controlling Explicit Cursors
Use Explicit Cursors to Process Rows
Cursors and Records
Cursor FOR Loops Using Subqueries
Explicit Cursor Attributes
The %NOTFOUND and %ROWCOUNT Attributes

Handling Exceptions
Define Exception
Handling Exceptions with PL/SQL
Predefined Exceptions
Trapping Predefined and Non-predefined Oracle Server Errors
Functions that Return Information on Encountered Exceptions
Trapping User-Defined Exceptions
Propagate Exceptions
Basic RAISE Statement

Creating Stored Procedures and Functions
Overview of Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Show the CREATE OR REPLACE PROCEDURE | FUNCTION
Understand the Header Area of a Stored Procedure and Function
Copyright © 2013, Oracle. All rights reserved. Page 3
Create Simple Procedures and Functions
Create a Simple Procedure with an IN Parameter
Execute a Procedure and a Function

Read complete course description: Oracle Database: PL/SQL Fundamentals




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 2015 - 2014 - 2013 - 2012 - 2011 - 2010 - 2008!