Advanced Oracle PL/SQL Programming for Enterprise-Level Applications

  • Home
  • Courses
  • Advanced Oracle PL/SQL Programming for Enterprise-Level Applications

Modules and Content

1. Advanced SQL Concepts & Joins Mastery
  • Views, Indexes, Subqueries
  • Multi-table joins & performance tuning
  • Modular programming in PL/SQL
  • Trigger-based automation
  • Implicit and explicit cursors
  • Structured exception control
  • Explain plan, execution plan tuning
  • Best practices for large-scale data handling
  • Real-world database project (e.g., payroll or inventory)

Reference

  • “Piping Handbook” by Mohinder L. Nayyar ,
  • “Process Piping: The Complete Guide to ASME B31.3” by Charles Becht IV,
  • “Pipe Stress Engineering” by Liang-Chuan Peng and Tsen-Loong Peng
  • “Piping Design Handbook” by John J. McKetta Jr.
  • “The Planning Guide to Piping Design” by Richard Beale and David R. Sherwood