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

Download Course Contents

Oracle Database: Develop PL/SQL Program Units Ed 2 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
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Different types of triggers
  • Database triggers and their use
  • Creating database triggers
  • Database trigger firing rules
  • Removing database triggers
  • Compound triggers
  • Mutating tables
  • Creating triggers on DDL statements
  • Creating triggers on system events
  • Displaying information about triggers
  • 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
  • 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
  • Dependent and referenced objects
  • Tracking procedural dependencies with dictionary views
  • Predicting the effect of changing a database object
  • Managing local and remote procedural dependencies
Live Online Training (Duration : 24 Hours)
Group Training 2400 Per Participant Incl. Official Courseware
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 4800 2800 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 2,240

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
     

Trending Technologies

 Cloud Computing
 Security
 Fundamentals
 CRM
 Cloud Architect
 DevOps
 Data Analytics
 Cloud Administration
 Project Management
 System Administration

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner