Oracle SQL-PL/SQL Training

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Beginner

Created by Ram Niwas Sangwan Last Updated 21/05/2018 07:45

What's Included

  • 0 Lectures
  • Access on tablet and phone
  • Certificate of completion

Description

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.

Instructors

(0.00)

21 Courses

227 Students

2 Reviews