ORACLE PL/SQL TRAINING COURSE

Uplatz

Training

Online

£ 96.01 VAT inc.

*Indicative price

Original amount in INR:

₹ 10,000

The best SQL Server courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Month

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Hold 16yrs of IT experience on oracle database, oracle sql, plsql, unix, shell scripting technologies. I have teaching experience on these technologies as well. I can work on freelancing projects on these technologies. I can train individual/group these technologies to experience level. In fact I can work on oracle related projects as well.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • PL/SQL
  • Database training
  • Block Structure
  • Anonymous
  • Executing Blocks
  • SQL Functions
  • Calling PL
  • SQL Blocks
  • Executing PL
  • Data Types
  • Naming
  • Assignment

Course programme

PL/SQL – Part 1

PL/SQL Block
  • Anonymous Block Structure
  • Named Block Structure
  • Executing Blocks
  • Calling PL/SQL Functions
  • Executing PL/SQL Blocks and Functions
Declaring Variables
  • Variable Data Types
  • Variable Naming
  • Variable Assignment
  • Complex Variable Types
Within the Block
  • Conditional Processing
  • The IF Statement
  • The CASE Statement
  • Iterative Processing
  • The LOOP Statement
  • The WHILE Statement
  • The FOR Statement
Handling Exceptions
  • Overview of Exceptions
  • Causing System Generated Exceptions
  • Handling System Generated Exceptions
  • Identifying System Generated Exceptions
  • OTHERS Exception Handler
  • User Defined Exceptions
Use of SQL in PL/SQL
  • Implicit Cursors
  • %TYPE and %ROWTYPE Attributes
  • EXECUTE IMMEDIATE statement
  • Cursors Attributes
  • Implicit Cursor
  • Explicit Cursors
  • Explicit Cursor
  • Cursor FOR loop
Nested Blocks
  • Nesting Blocks
  • Scope of Variables
  • Scope of Exceptions
  • Nested Subprograms
  • Exception Propagation in Nested Blocks
  • Block Variable Visibility
Introducing Subprograms
  • Anonymous blocks
  • Types of Subprograms
  • Finding Subprograms in the Oracle Data Dictionary
  • Object Dependencies
  • Subprogram information in the Oracle Data Dictionary
Stored Procedures and Functions
  • Creating Subprograms
  • Modifying Subprograms
  • Removing Subprograms
  • Application Maintenance
  • Exercise Title
  • Parameters
  • Cursors as Parameters
  • Subprogram Development Techniques
  • Addressing Compilation Errors
  • PL/SQL Subprograms with Parameters
Packages
  • Structure of Packages
  • Purpose of Packages
  • Wrap Utility
  • Positional vs Named Parameter Notation
  • Subprograms Omitted from Specifications
  • Using PL/SQL Packages
Database Triggers
  • Purpose of Triggers
  • Invocation of Triggers
  • Coding Triggers
  • Validation Trigger
  • Modifying Triggers
  • Viewing Triggers
  • Enabling/Disabling Triggers
  • Trigger Errors
Data Retrieval Techniques
  • Cursor Review
  • Cursor Parameters
  • Cursor Variables
  • Dynamic SQL
Using Oracle Supplied Packages
  • Oracle Supplied Packages
  • Identifying Available Packages
  • Identifying Package Subprograms
  • Selected Oracle Supplied Package Demos
  • Packages related to Input/Output
PL/SQL – Part 2

Arrays and Bulk Binds
  • Populating Collections Using Bulk Operations
  • Bulk collect
  • Bulk Collect from an Explicit Cursor
  • Chunking Bulk Collections Using the LIMIT Clause
  • Manually Limiting Bulk Collection Volumes
  • Bulk Collection of DML Results
  • FORALL
  • Bulk INSERT Operations
  • Bulk UPDATE Operations
  • Bulk DELETE Operations
  • Sparse Collections
  • Host Arrays in Bulk Operations
  • BULK_ROWCOUNT
  • Handling Exceptions in Bulk Operations
  • Unhandled Exceptions
  • Handled Exceptions
  • Bulk Operations that Complete
  • Dynamic SQL and Bulk Operations
Table Functions and Pipelining
  • Introduction
  • Pipelining Table Functions
  • Parallel Enabled Table Functions
  • Miscellaneous Information



See related categories

ORACLE PL/SQL TRAINING COURSE

£ 96.01 VAT inc.

*Indicative price

Original amount in INR:

₹ 10,000

The best SQL Server courses

See all

See all