Oracle SQL-PL/SQL Training

Lorem ipsum dolor sit amet, consectetur adipiscing elit.


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


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.



19 Courses

195 Students

2901 Reviews

Ram Niwas Sangwan

I have spent 27 years in IT Industry as an Educationist. I have been a software developer/corporate trainer and an information systems specialist with a record of developing and supporting solutions incorporating a wide range of applications. I have an entrepreneurial-mindset and a track record of success in recognizing opportunities spanning more than 26 years. Developing innovative and creative approaches, I have trained top level executives of companies driving revenue growth and enhancing long-term profitability. I have been motivating my team to ensure project success and on-time delivery. I, have time and again proven my ability at managing multiple priorities in fast-paced environments.
Businessman Leading a team of Professionals in the Area of Digital Marketing, Website Design and Development, Software Development with more than 1200 Satisfied Client. Currently I am managing My Own Production Servers with more than 500 Live Websites and Launching my Dream Project after working on for more than 4 Years.