Glasspaper er Oracle Approved Education Center i Norge


Oracle Database 12c: PL/SQL Fundamentals

Kursavgift: kr 11 500 | 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:
  • Design PL/SQL anonymous block that execute efficiently
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle exceptions in the program units
  • Create and execute simple stored procedures and functions
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL
Students will benefit from this course as it enables programmers with the skill of using this programming language. In the class students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.


Målgruppe:

The audience for this traning is
  • Database Administrators
  • PL/SQL Developer
  • 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
The Human Resources (HR) Schema
Appendices Used in this Course
PL/SQL Development Environments

Introduction to PL/SQL
Understanding the benefits and structure of PL/SQL
Understanding PL/SQL Blocks
Generating output messages in PL/SQL

Declaring PL/SQL Variables
Identifying valid and invalid identifiers
Declaring and initializing variables
Various data types
Identifying the benefits of using the %TYPE attribute
Using bind variables

Writing Anonymous PL/SQL Blocks
Lexical Units in a PL/SQL Block
Using SQL Functions in PL/SQL
Data Type Conversion
Using Nested Blocks as Statements
Referencing an Identifier Value in a Nested Block
Qualifying an Identifier with a Label
Operators in PL/SQL
Using Sequences in PL/SQL Expressions

Using SQL Statements within a PL/SQL Block
Using SQL Statements in PL/SQL
Retrieving Data in PL/SQL with the SELECT statement
Using Naming Conventions in DML Statements and data retrieval
Manipulating Data on the Server Using PL/SQL
SQL Cursors
Using SQL Cursor Attributes to Obtain Feedback on DML
Saving and Discarding Transactions

Writing Control Structures
Controlling PL/SQL Flow of Execution
Using IF and CASE Statements for conditional Processing
Handling Nulls
Building Boolean Conditions with Logical Operators
Using Iterative Control with Loop Statements

Working with Composite Data Types
Composite Data Types of PL/SQL Records and Tables
Using PL/SQL Records
Inserting and Updating PL/SQL Records
Using INDEX BY Tables
Using Associative arrays
Declaring and Using VArrays

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

Handling Exceptions
Concept of Exception
Handling Exceptions with PL/SQL
Predefined Exceptions
Trapping Predefined and Non-predefined Oracle Server Errors
Functions that Return Information on Exceptions
Usage of PRAGMA keyword
Trapping User-Defined Exceptions
Propagating Exceptions

Creating Stored Procedures and Functions
Overview of Stored Procedures and Functions
Differentiating between anonymous blocks and subprograms
Create or replace procedure | function
Understanding the Header Area of a Stored Procedure and Function
Creating Simple Procedures and Functions
Creating a Simple Procedure with an IN Parameter
Executing a Procedure and a Function

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




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@glasspaper.no


    Glasspaper er kåret til Årets Microsoft Kurspartner 2017 - dette er åttende år på rad vi mottar denne hedersprisen