Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Outline of Contents

  • Oracle: SQL and PL/SQL
  • Creating Views in Oracle Database: 2 Hr.
  • PL/SQL Syntax and Logic: 1:30 Hr.
  • 30 min assignment : Lab assignment : logic, statement and breaking the statement
  • Stored Procedures and Functions: 1:30 Hr.
  • Exception Handling: 2 Hr.
  • Cursors: 1 Hr
  • Maintaining Data Integrity : 2 Hr.
  • Query Processing: 2:30 Hr.
  • When to Use Specific Constructs: 2:00 Hr.
  • Avoid Unnecessary Parsing: 45 min.
  • Using Bind Variables
  • Using Table Aliases
  • SQL Transformations : 3:00
  • Heuristic query transformations: 2 Hr.
  • Cost-based query transformations: 2 Hr.
  • Access path selection: 4 Hrs.
  • Cost Model and Statistics : 3 Hrs.
  • Optimizer statistics
  • Statistics management
  • Optimization cost modes.
  • Dynamic Runtime Optimizations : 2 Hr.
  • Ranking Functions: 3 Hrs.

Course Curriculum

No curriculum found !

Course Reviews

4

4
4 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • PRIVATE
  • 60 Days
  • Course Badge
  • Course Certificate
4 STUDENTS ENROLLED

    Instructor Details

    More Courses by The Skill Pedia

      Advanced Course Search Widget

      Popular Courses

      Recent Posts

      Featured Testimonial

      When I first met Sangwan in December of 2017 he told me verbatim that he will make me an  expert...Read more

      Linux Administration Training

      Yaw A. Boateng

      Philadelphia, PA

      Certificate Code

      Who’s Online

      There are no users currently online

      Last Tweets

      top
      X