Oracle SQL-PL/SQL Training

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 ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 60 Days
    • Course Badge
    • Course Certificate

    Advanced Course Search Widget

    Popular Courses

    Recent Posts

    Featured Testimonial

    I recommend The Skill Pedia to all those who are looking for a career in Information Technology as Linux Administrator. Trust me, you won't need a certificate after the training, though that would be an added advantage.Read more

    Michael John

    Certified Engineer

    Popular Courses

    About The SkillPedia

    The Skill Pedia is a platform for online training. It offers great learning experience for learners by offering features such as Interactive Videos, Interaction with Trainer, Assignments, Rich Audio Visuals and Handouts.

    The Course Completion Certificate generated automatically based on your performance after the course is complete is an edge.

    For Trainers, it is a platform for sharing your Skills which may be in the form of videos, slides, handouts, e-books or even consulting and get up to 85% of the fee you decide for the course.

    The Skill Pedia - Learn or Teach a Skill

    TheSkillPedia Tweets

    WhatsApp chat


    This Offer is Limited!  Avail 50% Discount on all Courses!

    You have successfully subscribed to the newsletter

    There was an error while trying to send your request. Please try again.

    The Skill Pedia will use the information you provide on this form to be in touch with you and to provide updates and marketing.