Student Portal
  • Home
  • Oracle PL/SQL Fundamentals (TTOR12019)

Oracle PL/SQL Fundamentals (TTOR12019)

Gain the Core Skills Required to Setup, Run and Manage Databases using PL/SQL and Oracle Database Technology
$2,295.00
Select Upcoming Date
  • Apr 13, 2026 - Apr 14, 2026
    2 Days - Live Online - EST
    10:00 AM - 06:00 PM EST
Gain the Core Skills Required to Setup, Run and Manage Databases using PL/SQL and Oracle Database Technology

More Information:

  • Learning Style: Virtual
  • Learning Style: Course
  • Difficulty: Intermediate
  • Course Duration: 2 Days
  • Course Info: Download PDF
  • Certificate: See Sample

Need Training for 5 or More People?

Customized to your team's need:

  • Annual Subscriptions
  • Private Training
  • Flexible Pricing
  • Enterprise LMS
  • Dedicated Customer Success Manager

Course Information

About This Course:

This intensive course trains you in Oracle PL/SQL programming. You will master writing stored procedures, functions, packages, triggers, and working with advanced PL/SQL features. You will practice in hands-on labs against real Oracle environments. After the course you will be able to design, implement, debug, and deploy PL/SQL code aligned with Oracle best practices.

Course Objectives:

  • Structure and execute PL/SQL blocks (anonymous, named) 

  • Create procedures, functions, packages, and triggers 

  • Use cursors, explicit and implicit, and bulk operations 

  • Handle exceptions and design robust error handling 

  • Leverage advanced features: collections, records, object types 

  • Manage large data sets with bulk binds, FORALL, dynamic SQL 

  • Understand PL/SQL compiler optimization, profiling, and performance tuning 

  • Implement secure, maintainable PL/SQL programs 

Audience:

  • Developers building Oracle applications 

  • DBAs supporting PL/SQL environments

Prerequisites:

  • SQL knowledge 

  • Familiarity with Oracle Database concepts 

 

Outline

Hit button to validate captcha