EXPERT PL/SQL PRACTICES


EXPERT PL/SQL PRACTICES Online Training By IT Experts

Vision Online Training offers EXPERT PL/SQL PRACTICES Online Training.Our EXPERT PL/SQL PRACTICES trainers are highly talented and well experienced trainers.Our EXPERT PL/SQL PRACTICES online training is one of the Best online training in India.All our students were happy With our online training and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. online training is your one stop solution to learn EXPERT PL/SQL PRACTICES at your home with flexible schedules.

Vision Online Training offers the EXPERT PL/SQL PRACTICES Online Training Course in a true global setting.

EXPERT PL/SQL PRACTICES Online Training Concepts :

Oracle11g: Advanced PL/SQL

  • Introduction to PL/SQL
> PL/SQL Block
>  Cursor
  • Implicit
  • Explicit
  • Cursor attribute
  • Parameterize cursor
  • Cursor For Loop
>  Oracle Input Parameter
>  Function, Procedure, Package
>  Trigger

PL/SQL Programming Concepts: Review

  • Programming Concepts
>  Creating Procedures, Function, Package
>  Procedure Overloading
  • Hand exceptions
>  Oracle Define Exception
>  User Define Exception
  • Use Oracle-supplied packages
>  DBMS_OUTPUT
>  UTL_FILE
>  UTL_MAIL

Designing PL/SQL Code

  •  Identify guidelines for cursor design
  • Use cursor variables
  • Create subtypes based on existing types

 Working with Collections

  •  Create collections (nested table, array and associative arrays, PL SQL tables)
  • Use collections methods
  • Manipulate collections
  • Distinguish between the different types of collections and their uses

 Pragma

  • Pragma autonomous_transaction
  • Pragma serially_reusable
  • Pragma restrict_refrences
  • Pragma exception_init
  • Pragma inline

Analytic Functions

  • Rank
  • Dense_Rank
  • First And Last
  • Lag And Lead
  • Top-N Queries

BULK COLLECT and Record Processing in Oracle

  • Introduction
  • BULK COLLECT
  • FORALL
  • SQL%BULK_ROWCOUNT
  • SAVE EXCEPTIONS and SQL%BULK_EXCEPTION

Others

  • Dynamic Query

 Manipulating Large Objects

  •  Create and manage LOB data types
  • Use the DBMS_LOB PL/SQL package
  • Use of temporary LOBs

 Performance and Tuning

  •  Use native and interpreted compilation methods
  • Tune PL/SQL code

 Analyzing PL/SQL Code

  •  Run reports on source code
  • Determine identifier types and usages
  • Use DBMS_METADATA to retrieve object definitions

 Profiling and Tracing PL/SQL Code

  •  Trace PL/SQL program execution
  • Profile PL/SQL applications

 Oracle 11g New Features

  •  Invisible Indexes
  • Trigger Follows
  • Read Only Table
  • Virtual Columns
  • Direct Sequence Assignment
  • Calling Function

 

Our EXPERT PL/SQL Online Training batches start every week and we accommodate your flexible timings.

The Next Concept Of Oracle is Oracle HRMS

Vision Trainings provides online training for various courses like Oracle 11g Online Training,Oracle 11g DBA Online Training,Oracle apps DBA Online Training,

Home    About Us    Contact Us    Sitemap
ContactUs.com