Oracle SQL-PL/SQL Training

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.