PL/SQL Essentials: From Fundamentals to Advanced Programming

Master enterprise-level Procedural Language/Structured Query Language (PL/SQL) programming under the guidance of database development experts. Enroll in our comprehensive training program tailored specifically for advanced database programming to build a thorough professional skill set.

Face-to-Face Jan 26-27, 2026 9:00 AM - 5:00 PM Dr. Esther Suria Kala
updated
beginner
PL/SQL Essentials: From Fundamentals to Advanced Programming
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2400/day
Material Fees: MYR 400
Total Fees: MYR 5200 ++

Features

2 days
16 modules
12 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers
managers
executives

Methodologies

lecture
slides
labs
group discussion
q&A

Subsidies

HRDC Claimable logo

What you'll learn

  • Manipulate collections, records, and Large Objects in PL/SQL applications
  • Develop triggers for automated database actions and data integrity
  • Execute dynamic SQL and optimize code performance using best practices
  • Write and execute PL/SQL blocks using proper syntax and structure
  • Create and manage procedures, functions, and packages for code organization
  • Implement control structures and exception handling in database programs
  • Apply advanced PL/SQL features including cursors and bulk operations

Why should you attend?

This comprehensive training program takes you through the complete journey of Procedural Language/Structured Query Language (PL/SQL) development, from basic concepts to advanced programming techniques. You will begin by understanding the fundamental architecture and syntax of PL/SQL, learning how it differs from standard SQL and other database languages, and mastering the essential block structure that forms the foundation of all PL/SQL programs. The course progresses through critical programming concepts including data types, variables, and control structures, providing you with the tools to create sophisticated conditional and iterative logic. You will explore advanced database interaction techniques through cursors, exception handling mechanisms, and comprehensive data manipulation operations including transaction control and bulk processing methods. Advanced topics cover the creation and management of procedures, functions, and packages for modular code organization, along with trigger implementation for automated database actions. You will also master working with complex data structures like collections and records, handle Large Objects (LOBs) for multimedia data, and implement dynamic SQL for flexible query execution. The program concludes with performance optimization strategies, best practices for maintainable code, and an introduction to object-oriented features in PL/SQL, ensuring you have the complete skill set needed for professional database development.

Course Syllabus

Day 1 - PL/SQL Fundamentals Introduction
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Variables and Control
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor

Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

FAQ

Frequently Asked Questions About This Course

Why should you attend?

This comprehensive training program takes you through the complete journey of Procedural Language/Structured Query Language (PL/SQL) development, from basic concepts to advanced programming techniques. You will begin by understanding the fundamental architecture and syntax of PL/SQL, learning how it differs from standard SQL and other database languages, and mastering the essential block structure that forms the foundation of all PL/SQL programs. The course progresses through critical programming concepts including data types, variables, and control structures, providing you with the tools to create sophisticated conditional and iterative logic. You will explore advanced database interaction techniques through cursors, exception handling mechanisms, and comprehensive data manipulation operations including transaction control and bulk processing methods. Advanced topics cover the creation and management of procedures, functions, and packages for modular code organization, along with trigger implementation for automated database actions. You will also master working with complex data structures like collections and records, handle Large Objects (LOBs) for multimedia data, and implement dynamic SQL for flexible query execution. The program concludes with performance optimization strategies, best practices for maintainable code, and an introduction to object-oriented features in PL/SQL, ensuring you have the complete skill set needed for professional database development.


What you'll learn

  • Manipulate collections, records, and Large Objects in PL/SQL applications
  • Develop triggers for automated database actions and data integrity
  • Execute dynamic SQL and optimize code performance using best practices
  • Write and execute PL/SQL blocks using proper syntax and structure
  • Create and manage procedures, functions, and packages for code organization
  • Implement control structures and exception handling in database programs
  • Apply advanced PL/SQL features including cursors and bulk operations

Course Syllabus

Day 1 - PL/SQL Fundamentals Introduction
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Variables and Control
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2400/day
Material Fees: MYR 400
Total Fees: MYR 5200 ++

Features

2 days
16 modules
12 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers
managers
executives

Methodologies

lecture
slides
labs
group discussion
q&A

Subsidies

HRDC Claimable logo

Instructor

Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

FAQ

Frequently Asked Questions About This Course

Close menu