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

      Recent Posts

      Featured Testimonial

      I think the course was excellent for someone like me (Web Designer working on always improving...Read more

      Karen Cadman

      Sr. Web Designer

      Certificate Code

      Who’s Online

      There are no users currently online

      Last Tweets

      top
      X