Oracle Database: Develop PL/SQL Program Units Ed 2/1Z0-148

Oracle Database: Develop PL/SQL Program Units Ed 2 Certification Training Course Overview

The Oracle Database: Develop PL/SQL Program Units Ed 2 training course will give a detailed overview on how to create, and execute stored procedures and functions, Design and use PL/SQL packages,Create overloaded package subprograms for more flexibility. During the training you will also learn to Utilize Oracle-Supplied Packages in Application Development, Create triggers to solve business challenges, Build and execute SQL statements dynamically.
 

Who Should Do Oracle Database: Develop PL/SQL Program Units Ed 2 training?

  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • Database Administrators
  • System Analysts
  • Technical Consultant
This course prepares you for Exam 1Z0-148.

Oracle Database: Develop PL/SQL Program Units Ed 2 (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2400
20 - 22 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 06 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 03 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2800
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Full Human Resources (HR) Schema
  • Online Oracle Database 12c SQL and PL/SQL documentation
  • PL/SQL development environments available in this course
  • Using the SQL Worksheet
  • Executing SQL Statements
  • Working With Script Files
  • Creating and Executing Anonymous Blocks
Module 2: Working with Oracle Database Exadata Express Cloud Service
  • Overview of Oracle Database Exadata Express Cloud Service
  • Accessing Cloud Database using SQL Workshop
  • Connecting to Exadata Express Database using Database Clients
  • Using SQL Developer to work with Exadata Express Database
  • Using SQLcl to work with Exadata Express Database
  • Using SQL*Plus to work with Exadata Express Database
Module 3: Creating Stored Procedures
  • PL/SQL blocks and subprograms
  • Uses and benefits of procedures
  • Working with procedures
  • Using formal and actual parameters
  • Identify the available parameter-passing modes
  • Passing parameters using the positional, named, or combination techniques
  • Handling exceptions in procedures
  • Viewing the procedure information
Module 4: Creating Functions and Debugging Subprograms
  • Creating Stored Functions
  • The Difference Between Procedures and Functions
  • Working with 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
  • Defining and executing PL/SQL functions in SQL statements
  • Restrictions When Calling Functions from SQL statements
Module 5: Creating Packages
  • Using PL/SQL Packages
  • Components of a PL/SQL Package
  • 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
Module 6: 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
Module 7: Using Oracle-Supplied Packages in Application Development
  • Using Oracle-Supplied Packages
  • Examples of Some of the Oracle-Supplied Packages
  • Working of DBMS_OUTPUT Package
  • Using the UTL_FILE Package to Interact With Operating System Files
  • Using the UTL_MAIL Package
Module 8: Using Dynamic SQL
  • Introduction to Dynamic SQL
  • The Execution Flow of SQL
  • Working With Dynamic SQL
  • When Do You Need Dynamic SQL?
  • Using Native Dynamic SQL (NDS)
  • Dynamic SQL with mock up application
  • Using BULK COLLECT and FORALL
  • Dynamic SQL using DBMS_SQL package
Module 9: Creating Triggers
  • Different types of triggers
  • Database triggers and their use
  • Creating database triggers
  • Database trigger firing rules
  • Removing database triggers
Module 10: Creating Compound, DDL, and Event Database Triggers
  • Compound triggers
  • Mutating tables
  • Creating triggers on DDL statements
  • Creating triggers on system events
  • Displaying information about triggers
Module 11: Design Considerations for PL/SQL Code
  • Standardizing constants with a constant package
  • Standardizing exceptions with an exception package
  • Writing PL/SQL code that uses local subprograms
  • Grant Roles to PL/SQL Packages and Standalone Stored Subprograms
  • Using the NOCOPY compiler hint to pass parameters by reference
  • Using the PARALLEL ENABLE hint for optimization
  • Using the AUTONOMOUS TRANSACTION pragma
  • Describing the differences between invoker rights and definer rights
Module 12: Using PL/SQL compiler
  • Using the PL/SQL Compiler with initialisation parameters
  • Using the PL/SQL Compile Time Warnings
  • Viewing the Current Setting of PLSQL_WARNINGS
  • Viewing the Compiler Warnings
  • Guidelines for using PLSQL_WARNINGS
  • Conditional Compilation
Module 13: Managing Dependencies
  • Dependent and referenced objects
  • Tracking procedural dependencies with dictionary views
  • Predicting the effect of changing a database object
  • Managing local and remote procedural dependencies
Download Course Contents

Request More Information

Course Prerequisites
  • Basic understanding of data processing concepts and technique
  • Fundamental knowledge of programming languages

Upon Completion of this course you will know following:

  • Using conditional PL/SQL compilation and obfuscate (hide) code
  • Creating triggers to solve business challenges & Managing dependencies between PL/SQL subprograms
  • Using the compiler warnings infrastructure
  • Create, use, and debug stored procedures and functions
  • Designing and using PL/SQL packages
  • Generate screen output, file output, and mail output
  • Dynamic SQL Code