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.

    TAKE THIS COURSE

    Recent Posts

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