Oracle SQL-PL/SQL Training

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

4 STUDENTS ENROLLED

    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.

    Recent Posts

    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

    Designed by  © Alliance Softech Pvt Ltd. All rights reserved.
    WhatsApp chat
    X