Oracle Exadata Online Training Course Content


Who Should Attend

  • Developers with any RDBMS Applications

Module I: Introduction to Oracle Exadata

  • Salient Features of Oracle Exadata

Module II: AbInitio Architecture

  • The Oracle Exadata Co-Operating System
  • Graphical Development Environment (GDE)
  • Intro to The Oracle Exadata Enterprise Meta-Environment (EME)

Module III: Sandbox and Parameter details

  • What is sandbox and its usage
  • Public and private parameters

Module IV: Graph Programming

  • What is graph programming and basic parts of AbInitio graph building
  • What is the Anatomy of Running a Job
  • How do we Connect from GDE to the Server (Run ? Settings)
  • Broad classification of components
  • Editors in the GDE
  • XFR and its usage

Module V: Data Manipulation Language Overview (DML)

  • Record Formats
  • DML Expressions
  • Transform Functions
  • Key Specifiers

Module VI: Components · Dataset Components

  • Input File
  • Output File
  • Intermediate File
  • Lookup file

    Transform Components

    • Filter by Expression
    • Dedup Sorted
    • Reformat
    • Aggregate
    • Scan
    • Rollup
    • Join
    • Match Sorted

    Partition Components

    • Broadcast
    • Partition by Key
    • Partition by Expression
    • Partition by Percentage
    • Partition by Range
    • Partition by Round-Robin
    • Partition with Load Balancing

    De-partition Components

    • Concatenate
    • Gather
    • Interleave
    • Merge

    Database Components

    • Input Table
    • Output Table
    • Run SQL
    • Truncate Table
    • Update Table
    • Join with DB

    Sort Components

    • Sort
    • Sort Within Groups

    Miscellaneous Components

    • Redefine Format
    • Gather Logs
    • Replicate
    • Run Program
    • Trash

Module VII: Parallelism

  • Component Parallelism
  • Pipeline Parallelism
  • Data Parallelism
  • Multifile

Module VIII: AbInitio functions

  • AbInitio in-build functions
  • Lookup fuctions

Module IX: AbInitio Best Practices and Performance Tuning

  • Phasing and Checkpoints
  • Sub-graphs
  • Serial Input Vs Multifile
  • Fan-In and Fan-Out

CASE STUDY COVERING ALL THE ABOVE TOPICS



We are providing Oracle Exadata Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Oracle Exadata online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our Oracle Exadata online training from their home in their convenient timings. For more details on Oracle Exadata Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

Oracle Exadata online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India


Enquiry Form