Course code: D80182« Back

Oracle Database: PL/SQL Fundamentals

This Oracle Database: PL/SQL Fundamentals training 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. 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.Gain Experience through Hands-On Practice - In this course, you’ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You’ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

 DateDurationCourse priceHandbook priceCourse languageLocation 
3/23/2020 2 24 392 CZK included in course price Český jazyk GOPAS Praha_GTT
 
5/18/2020 2 24 392 CZK included in course price Český jazyk GOPAS Praha_GTT
 
8/17/2020 2 24 392 CZK included in course price Český jazyk GOPAS Praha_GTT
 
11/2/2020 2 24 392 CZK included in course price Český jazyk GOPAS Praha_GTT
 
3/23/2020 2 24 392 CZK included in course price Český jazyk GOPAS Brno_GTT
 
5/18/2020 2 24 392 CZK included in course price Český jazyk GOPAS Brno_GTT
 
8/17/2020 2 24 392 CZK included in course price Český jazyk GOPAS Brno_GTT
 
11/2/2020 2 24 392 CZK included in course price Český jazyk GOPAS Brno_GTT
 
3/23/2020 2 900,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
5/18/2020 2 900,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
8/17/2020 2 900,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
11/2/2020 2 900,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
Anytime 2 21 632 CZK included in course price Anglický jazyk Virtual Class
 

AffiliateDurationCatalogue priceHandbook priceITB*
Praha2 24 392 CZK included in course price 30
Brno2 24 392 CZK included in course price 30
Bratislava2 900,00 EUR included in course price 30

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

User intensity level

What we teach you

  • 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.

Required skills

  • Familiarity with data processing concepts and technique
  • Familiarity with programming languages
  • Oracle Database: Introduction to SQL

Teaching methods

Expert instruction with practical examples, computer practice

Oracle Training Formats

Training on Demand, one of the most popular learning formats, allows students to learn whenever they need (24/7, 90 days). These video recorded courses are led by TOP instructors. Other learning formats are traditional in-class training, Live Virtual Class, or Self-Study Courses. Read more here.

Teaching materials

The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English.

Course outline

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
  • 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
  • Create Simple Procedures and Functions
  • Create a Simple Procedure with an IN Parameter
  • Execute a Procedure and a Function

Previous courses

Next courses

no following course
Oracle University eKit

Price:
included in course price
The prices are without VAT.