Szkolenia Oracle

Cel szkolenia

kod: OD-ELS-OD-PPL/SQL | wersja: 12c

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

  • Conditionally control code flow (loops, control structures).
  • Create stored procedures and functions.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create custom packages for applications.
  • Write Dynamic SQL code for applications.

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Use Oracle SQL Developer:

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.

Course Bundle:

Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

Plan szkolenia Rozwiń listę

  1. Introduction
    • Course Objectives
    • Course Agenda
    • Describe the Human Resources (HR) Schema
    • PL/SQL development environments available in this course
    • Introduction to SQL Developer
  2. Introduction to PL/SQL
    • Overview of PL/SQL
    • Identify the benefits of PL/SQL Subprograms
    • Overview of the types of PL/SQL blocks
    • Create a Simple Anonymous Block
    • How to generate output from a PL/SQL Block?
  3. Declare PL/SQL Identifiers
    • List the different Types of Identifiers in a PL/SQL subprogram
    • Usage of the Declarative Section to Define Identifiers
    • Use variables to store data
    • Identify Scalar Data Types
    • The %TYPE Attribute
    • What are Bind Variables?
    • Sequences in PL/SQL Expressions
  4. Write Executable Statements
    • Describe Basic PL/SQL Block Syntax Guidelines
    • Learn to Comment the Code
    • Deployment of SQL Functions in PL/SQL
    • How to convert Data Types?
    • Describe Nested Blocks
    • Identify the Operators in PL/SQL
  5. Interaction with the Oracle Server
    • Invoke SELECT Statements in PL/SQL
    • Retrieve Data in PL/SQL
    • SQL Cursor concept
    • Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
    • Data Manipulation in the Server using PL/SQL
    • Understand the SQL Cursor concept
    • Use SQL Cursor Attributes to Obtain Feedback on DML
    • Save and Discard Transactions
  6. Control Structures
    • Conditional processing using IF Statements
    • Conditional processing using CASE Statements
    • Describe simple Loop Statement
    • Describe While Loop Statement
    • Describe For Loop Statement
    • Use the Continue Statement
  7. Composite Data Types
    • Use PL/SQL Records
    • The %ROWTYPE Attribute
    • Insert and Update with PL/SQL Records
    • INDEX BY Tables
    • Examine INDEX BY Table Methods
    • Use INDEX BY Table of Records
  8. Explicit Cursors
    • What are Explicit Cursors?
    • Declare the Cursor
    • Open the Cursor
    • Fetch data from the Cursor
    • Close the Cursor
    • Cursor FOR loop
    • The %NOTFOUND and %ROWCOUNT Attributes
    • Describe the FOR UPDATE Clause and WHERE CURRENT Clause
  9. Exception Handling
    • Understand Exceptions
    • Handle Exceptions with PL/SQL
    • Trap Predefined Oracle Server Errors
    • Trap Non-Predefined Oracle Server Errors
    • Trap User-Defined Exceptions
    • Propagate Exceptions
    • RAISE_APPLICATION_ERROR Procedure
  10. Stored Procedures
    • Create a Modularized and Layered Subprogram Design
    • Modularize Development With PL/SQL Blocks
    • Understand the PL/SQL Execution Environment
    • List the benefits of using PL/SQL Subprograms
    • List the differences between Anonymous Blocks and Subprograms
    • Create, Call, and Remove Stored Procedures
    • Implement Procedures Parameters and Parameters Modes
    • View Procedure Information
  11. Stored Functions and Debugging Subprograms
    • Create, Call, and Remove a Stored Function
    • Identify the advantages of using Stored Functions
    • Identify the steps to create a stored function
    • Invoke User-Defined Functions in SQL Statements
    • Restrictions when calling Functions
    • Control side effects when calling Functions
    • View Functions Information
    • How to debug Functions and Procedures?
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Suggested Prerequisite

  • Previous programming experience

Required Prerequisite

  • Oracle Database: Introduction to SQL
Poziom trudności
Czas trwania 5 dni
Certyfikat

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.

Prowadzący

Autoryzowany wykładowca Oracle.

Pozostałe szkolenia Oracle | Oracle Database

Szkolenia powiązane tematycznie

Bazy danych

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.






* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.

CENA SZKOLENIA

Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle