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

    Advanced Course Search Widget

    Popular Courses

    Recent Posts

    WhatsApp chat
    X