Oracle Database Programming with PL/SQL

28 Sep 2025 04:30 AM CST

Free Webinar
Live Q&A

Free Participation Certificate
Learn from Industry Experts

Learn More About This Topic

Webinar Overview

The webinar provided an in-depth introduction to Oracle 19c PL/SQL, highlighting its role in developing efficient and secure database applications. The session began with an overview of PL/SQL basics, including the structure of anonymous blocks, variables, and control statements. Participants explored how to create stored procedures, functions, and packages to organize business logic effectively. A key focus was placed on error handling through exceptions, ensuring reliability in database programs. The workshop also covered advanced features such as cursors, triggers, and collections, enabling developers to handle complex data processing requirements. Security considerations, including privilege management and safe coding practices, were emphasized to protect applications from risks. Performance tuning techniques and best practices were discussed to help developers build optimized PL/SQL code.

Key Points

Introduction to PL/SQL as Oracle’s procedural extension to SQL.
Writing anonymous blocks, stored procedures, and functions.
Use of variables, control structures, and cursors for program logic.
Error handling with exceptions for reliable applications.

Meet The Trainer

Naveen Kumar Rukkanna

An experienced Oracle consultant and corporate trainer with over 10 years in the field, I possess expertise in Oracle Prod/Dev/UAT DBA support, management of database objects, performance tuning, and troubleshooting. I have hands-on skills in Oracle SQL, PL/SQL, and related utilities, complemented by strong communication and analytical abilities.

Registration successful!
Details have been shared over email.

Explore More Webinars

Diversity & Inclusion in Teams - Build Stronger Collaboration & Innovation

Webinar Summary:

This course helps professionals understand and leverage diversity within teams. It focuses on fostering an inclusive culture, respecting different perspectives, and improving collaboration and innovation through diversity.

28 Sep 2025 | 10:30 AM CST 1 Hour

FortiGate Routing - Optimize Network Traffic with Secure Paths

Webinar Summary:

In this webinar we will understand What is Routing in FortiGate, Routing in FortiGate decides which interface/next-hop traffic should take to reach its destination. It supports static routes, dynamic routing protocols (OSPF, BGP, RIP), and policy-based routing. FortiGate uses a routing table to pick the best path based on metrics and priorities.

28 Sep 2025 | 07:30 AM CST 1 Hour

Data Mesh on Fabric - Scale Domain Driven Analytics with Confidence

Webinar Summary:

This webinar introduces how Microsoft Fabric can be used to implement a data mesh architecture, enabling organizations to move away from centralized bottlenecks and empower domains to manage their own data products. By leveraging OneLake, Shortcuts, Lakehouses, and Governance, Fabric provides the perfect foundation to deliver domain-driven, self-service analytics while maintaining centralized security and cost efficiency.

28 Sep 2025 | 01:30 AM CST 1 Hour

Explore All Webinars

Explore Related Courses

Sales Management in CRM 2016

Learn More

Explore All Courses